Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Excel (365/2019) Course

Microsoft Excel (365/2019) Self Paced Training Course


Course Description:

Learn all the new features of Microsoft Excel 2019 (Office 365). This Excel 2019 Self Paced online class covers the basic, intermediate and advanced features of Microsoft's newest spreadsheet program.



Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-Month License $99

12-Month License $129


Microsoft Excel (365/2019) Self-Paced Course Syllabus


Getting Started with Excel 2019

  • Understanding the Excel Screen
  • Creating a Workbook
  • Navigating a Worksheet
  • Opening and Saving a Workbook
  • AutoRecover
  • Quick Access Toolbar
  • Printing a Workbook
  • Getting Help
  • Closing and Exiting
Editing a Workbook
  • Select Cells and Ranges
  • Edit Cell Data
  • Cut, Copy, and Paste
  • Undo, Redo, Repeat
  • More Pasting Options
  • Using AutoFill
  • Inserting, Moving, and Deleting Cells
  • Checking Spelling
  • Finding and Replacing Text
  • Hiding Rows and Columns
  • Document Properties
Basic Formulas
  • Formula Basics
  • AutoFill
  • Working with Sums and Averages
  • MIN and MAX
  • Count
Basic Formatting
  • Formatting Text
  • Aligning and Merging Cells
  • Formatting Numbers and Dates
  • Borders and Background Colors
  • Copying Formatting
  • Row Heights and Column Widths
Inserting Objects
  • Images
  • Shapes
  • Hyperlinks
  • Object Properties and Alt text
Viewing and Managing Worksheets
  • Viewing Worksheets
  • Multiple Windows
  • Moving and Copying Worksheets
  • Insert, Rename, and Delete Worksheets
  • Freezing Rows and Columns
  • Hiding Worksheets and Gridlines
Working with Charts
  • Creating a Chart
  • Moving, Resizing, and Deleting a Chart
  • Chart Types
  • Changing Chart Layout and Style
  • Working with Titles and Legends
  • Gridlines, Labels, and Data Tables
  • Chart Elements
  • Modifying Chart Data
  • Filtering Charts
  • Trendlines
  • Dual-Axis Charts
  • Chart Templates
  • Sparklines
Printing adn Distributing Worksheets
  • Changing Page Size and Scale
  • Setting the Print Area and Viewing Page Breaks
  • Print Titles, Gridlines and Headings
  • Headers and Footers
  • Margins and Orientation
  • Inspect for Issues
Intermediate Formulas
  • Referencing External Worksheets
  • Absolute and Relative Cell References
  • Order of Operations
  • Cell and Range Names
  • Insert Functions
  • CONCAT Function
  • PMT Function
  • Display Formulas
  • Date Formulas
Manage Data
  • Quick Analysis
  • Outline and Subtotal
  • Data Validation
  • Flash Fill
  • Import and Export Data
Tables
  • Insert a Table
  • Sorting Data
  • Filtering Data
  • Add Rows and Columns
  • Table Styles
  • Remove Duplicates
  • Slicers
  • Structured References
Intermediate Formatting
  • Applying Conditional Formatting
  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Find and Replace Formatting
  • Apply a Theme
Collaborating with Excel
  • Working with Cell Comments
  • Sharing Workbooks
  • Co-Author Workbooks
  • Version History
  • Protecting a Worksheet
  • Protect Workbook Structure
  • Password Protection
Working with PivotTables
  • Creating a PivotTable
  • Adding Multiple Fields to a PivotTable
  • Changing a PivotTable’s Calculation
  • Add Calculated Fields
  • The GETPIVOTDATA Function
  • Filtering a PivotTable
  • Working with Timelines
  • Working with PivotTable Layout
  • Grouping PivotTable Values
  • Refreshing a PivotTable
  • Formatting a PivotTable
PivotCharts
  • Create PivotCharts
  • PivotChart Options
  • PivotChart Styles
  • Drill-Down Data
Troubleshooting Formulas
  • Formula Errors
  • The Watch Window
  • Evaluate Formulas
Advanced Formatting
  • Customize Conditional Formatting
  • Conditional Formatting with Formulas
  • Manage Conditional Formatting
  • International Currency and Formats
  • Body and Heading Options
  • Color Formats
  • Custom Themes
  • Form Controls
  • Save Form Templates
Advanced Formulas
  • IF Function
  • Nested Functions
  • AND, OR, and NOT Functions
  • SUMIF, AVERAGEIF, and COUNTIF Functions
  • VLOOKUP
  • HLOOKUP
  • INDEX and MATCH
  • UPPER, LOWER, and PROPER
  • RIGHT, LEFT, and MID
  • Formula Calculation Options
Analyzing Data
  • Goal Seek
  • Scenario Manager
  • Consolidate Data
Macros
  • Enable Macros
  • Create Macros
  • Modify Macros
  • Copy Macros

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile