Excel 2016 Essential Training

84 Video Lessons

Was: $20

Deal Price: $12

You Save: $8 (40%)

About this Course

Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert.

Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables.

Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.

 

Topics include:

  • Identify two navigational features within the Excel interface.
  • Distinguish the best approach to managing data in cells.
  • Recognize how Excel processes simple formulas.
  • Describe the different ways to access formatting features.
  • Identify page layout parameters for printing worksheets.
  • Determine the best approach to creating charts.
  • Explain how best to manage multiple worksheets and workbooks.

 

Contents

 

Introduction
Welcome

Using the exercise files

 

1. Getting Started with Excel
What is Excel used for?

Using the menu system

Using the Quick Access Toolbar

Understanding workbooks and worksheets

Using the Formula bar

Using the Status bar

Using navigation tools

Using shortcut menus and the Mini toolbar

Creating new workbooks

Using Excel Help

 

2. Entering Data
Exploring data entry and editing techniques

Entering data with AutoFill

Working with dates and times

Using Undo and Redo

Adding comments

Using Save or Save As

 

3. Creating Formulas and Functions
Creating simple formulas

Copying a formula into adjacent cells

Calculating year-to-date totals

Creating a percentage-change formula

Working with relative, absolute, and mixed references

Using SUM and AVERAGE

Using other common functions

 

4. Formatting
Exploring font styles and effects

Adjusting row heights and column widths

Working with alignment and Wrap Text

Designing borders

Exploring numeric and special formatting

Formatting numbers and dates

Using conditional formatting

Creating and using tables

Inserting shapes, arrows, and other visual features

 

5. Adjusting Worksheet Layout and Data
Inserting and deleting rows and columns

Hiding and unhiding rows and columns

Moving, copying, and inserting data

Finding and replacing data

 

6. Printing
Exploring the Page Layout tab and Page Layout view

Previewing page breaks

Working with Page Setup and printing controls

 

7. Charts
Creating charts

Exploring chart types

Formatting charts

Working with axes, titles, and other chart elements

Creating in-cell charts with sparklines

New charts in Excel 2016

 

8. Adjusting Worksheet Views
Freezing and unfreezing panes

Splitting screens horizontally and vertically

Collapsing and expanding data views with outlining

 

9. Multiple Worksheets and Workbooks
Displaying multiple worksheets and workbooks

Renaming, inserting, and deleting sheets

Moving, copying, and grouping sheets

Using formulas to link worksheets and workbooks

Locating and maintaining links

 

10. IF, VLOOKUP, and Power Functions
Using IF functions and relational operators

Getting approximate table data with the VLOOKUP function

Getting exact table data with the VLOOKUP function

Using the COUNTIF family of functions

 

11. Security and Sharing
Unlocking cells and protecting worksheets

Protecting workbooks

Assigning passwords to workbooks

Sharing workbooks

Tracking changes

 

12. Data Management Features
Sorting data

Inserting subtotals in a sorted list

Using filters

Splitting data into multiple columns

Splitting and combining columnar data with Flash Fill

Removing duplicate records

Using validation tools

 

13. Data Analysis Tools
Using Goal Seek

Using Solver

Using Scenario Manager

Using data tables

 

14. PivotTables
Creating PivotTables

Manipulating PivotTable data

Grouping by date and time

Grouping by other factors

Using slicers to clarify and manipulate fields

Using PivotCharts

 

15. Introduction to Macros
Exploring the need for macros

Creating a simple macro

Running a macro

1. Language: English. 

2. Secure download. 

    Video file format: MP4.

3. Learn anywhere. Switch between

    your computer, tablet, or TV.  

4. Practice while you learn

    with exercise files.  

5. Secure payment by PayPal.

6. 30 days refund.

7. No subscription needed.

8. Lifetime access.

9. This course without a sponsored ads.

 

Watch. Listen. Practice. Learn.