Excel 2019 (Office 365)

This course is included (as well as over 200 others) in every subscription!
Description
Materials

Who it's for: Beginners - experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Excel.

What it is: Microsoft’s spreadsheet application used to clean and organize data.

What you'll learn:  We start with the basics, showing you the user interface and quick ways to navigate. Once you’re comfortable with the software’s layout, we quickly move on to calculating data with basic formulas and functions. In the Intermediate section, we show you the various tools and ways to sort and filter data in a timely manner. Then, we dive into one of Excel’s most popular features; the Pivot Table. Our Advanced training starts with basic functions like the IF function. After that, we explore complex Database functions, provide an introduction to Macros, and show you how to save time by automating common Excel tasks.

Excel 2019 Beginner

Sign up to view this video Video Description
  • Start Screen & Templates
  • Ribbon & Quick Access Toolbar
  • Backstage View
  • Smart Lookup & Tell Me
  • Interface
  • Navigation
  • Keyboard Shortcuts
  • Entering Text
  • Number Formats
  • Deleting & Formatting
  • AutoSum
  • Simple Formulas
  • Simple Functions
  • Absolute Referencing
  • Moving & Copying Data
  • Inserting Rows & Columns
  • AutoFill
  • Cell Styles
  • Worksheet Themes
  • Excel Templates
  • Freeze Panes
  • Grouping Worksheets
  • Page Layout View
  • Custom Views
  • Spell Check
  • Printing
 

Excel 2019 Intermediate

Sign up to view this video Video Description
  • Overview of List Design
  • Formatting Lists as Tables
  • Filtering Records from Lists or Tables
  • Removing Duplicates from Lists or Tables
  • Flash Fill
  • Single & Multi-Level Sorting
  • Inserting Automatic Subtotals in Lists
  • Inserting Data Charts Using Recommended Charts
  • Formatting & Editing Chart Elements
  • Creating & Applying Custom Chart Templates
  • Adding & Removing Data from Charts
  • Inserting Sparklines
  • Printing Charts
  • Inserting Pivot Tables
  • Filtering Pivot Tables
  • Using Report Layouts in Pivot Tables
  • Refreshing & Changing Source Data in Pivot Tables
  • Inserting Pivot Charts
  • Data Validation
  • Applying Built-In Conditional Formatting
  • Creating Custom Conditional Formats
  • Linking Data
  • Comments
  • Protection
 

Excel 2019 Advanced

Sign up to view this video Video Description
  • Creating & Applying Named Ranges
  • Navigating with Named Ranges
  • IF Functions
  • Introduction to Nesting Functions
  • The Round Function
  • Formula Auditing Tools
  • Introduction to VLOOKUP
  • VLOOKUP
  • IFERROR
  • Database Functions - SUMIF & AVERAGEIF
  • Database Functions - SUMIFS
  • Text Functions
  • Consolidate by Position
  • Consolidate by Category
  • Goal Seek
  • Introduction to Data Tables
  • Data Tables
  • Scenario Manager
  • Macros - Adding the Developer Tab
  • Macros - Recording & Running the Header Macro
  • Macros - Visual Basic Editor & Form Control
  • Macros - Adding Macros to the Ribbon
  • Macros - Exercise
 
No Practice Files

Related Courses

Why Choose Anytime

Over 450,000 students since 1996

Over 20 years teaching software to industry leaders

100% 7-day money back guarantee

Feel secure: Ask a teacher if you have questions

Classroom Training available in Downtown San Francisco - 33 New Montgomery, SF CA 94102