Excel 2019 Essential Training

32 Video Lessons

Was: $20

Deal Price: $12

You Save: $8 (40%)

About this Course

Learn how to enter and organize data, create formulas and functions, build charts and PivotTables, and use other powerful Excel 2019 features.
Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more.

 

Topics include:

  • Explain the benefits of using Excel to create and manage spreadsheets.
  • Recall the appropriate action for activating shortcut menus.
  • Explore data entry, editing, and autofill.
  • Name three actions that can be undone in an Excel worksheet.
  • Identify the correct method for saving files in Excel.
  • Apply unique font styles and effects to enhance charts.
  • Recognize helpful keyboard shortcuts.

 

Contents

 

01 - Getting Started with Excel
What is Excel used for?
Using the Quick Access Toolbar and Ribbon menu
Using shortcut menus and the mini toolbar
Understanding workbooks and worksheets
Using Excel Help

 

02 - Entering Data
Exploring data entry, editing, and AutoFill
Working with dates and times
Using Undo and Redo
Using Save or Save As

 

03 - Creating Formulas and Functions
Using simple formulas
Using SUM and AVERAGE
Copying a formula into adjacent cells

 

04 - Formatting
Exploring font styles and effects
Applying borders and color backgrounds
Adjusting row heights and column widths

 

05 - Adjusting Worksheet Layout and Data
Rows and Columns
Moving, copying, and inserting data
Finding and replacing data

 

06 - Printing
Using the Page Layout view and commands
Using Page Break Preview and Print Setup Options

 

07 - Charts
Creating charts
Exploring chart types

 

08 - Adjusting Worksheet Views
Freezing and unfreezing panes
Splitting screens horizontally and vertically

 

09 - Multiple Worksheets and Workbooks
Renaming, inserting, and deleting sheets
Moving, copying, and grouping sheets

 

10 - Data Management Features
Sorting data
Using filters
Creating PivotTables

 

11 - Security and Sharing
Protecting worksheets and workbooks
Sharing workbooks
Tracking changes

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.