Learn how to get going inside of Excel and build your foundations
- Navigate the Excel User Interface
- Explore the Ribbon, Customize the Quick Access Toolbar
- Use Excel Commands
- Navigation tools, selection tools
- Create and Save a Basic Workbook
- Excel Online
- Comparing online versus desktop versions
- Enter Cell Data
- Data entry tools, using the Fill Handle, Duplicate, Copy Above
- Use Excel Help
- Search bar, Help, What’s New
Learn to go-to formulas for Excel
- Create Worksheet Formulas
- Basic Formulas, Absolute References, Show/Hide Formulas
- Insert Functions
- Sum, Average, Max, Min, Count, Counta, Today, Now
- Reuse Formulas and Functions
- Quick Calculator, Fill formulas
- Use Specialized Functions
- Countif, Sumif, Averageif, Maxif, Minif
Learn the best tools to dress up your spreadsheets
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Colors, Borders, and Styles
- Apply Basic Conditional Formatting
- Create and Use Templates
Learn the advanced formulas you need to master your data
- Work with Ranges
- Absolute References, Named Ranges, Apply Names, Create from Selection
- Work with Logical Functions
- Comparison Operators, If, And, Or, Not, Nested formulas
- Work with Date and Time Functions
- Today, Now, Date, Networkdays, Weekday, Workday, Isoweeknum
- Work with Text Functions
- Left, Right, Mid, Find, Text to Columns, Concat, Upper, Lower, Proper
See what you want to see with the power of Sorts, Subtotals, Filters, and Slicers
- Sort Data
- Quick Sort, Multi-level Sorts, Custom Sorting
- Outline and Subtotal Data
- Subtotal, Format Subtotals
- Filter Data
- AutoFilter, Text and Number Filters, Custom Filters
- Filter with Slicers
- Format as Table, Total Row, Slicers
- Query Data with Database Functions
Learn the power of Table Formats and Conditional Formatting to help you analyze your data
- Create and Modify Tables
- Apply Intermediate Conditional Formatting
- Apply Advanced Conditional Formatting
Take your charts to the next level with advanced features
- Create Charts
- Quick charts, Recommended charts, chart types
- Modify and Format Charts
- Data source, elements, layouts, styles
- Use Advanced Chart Features
- Change scale, dual axis charts, trendlines, templates
Learn how to pivot and slice your data to make better decisions with your data
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data by Using Timelines and Slicers
Learn how to reduce errors and do repetitive tasks with one click
- Apply Data Validation
- Settings, Input Messages, Error Messages
- Search for Invalid Data and Formulas with Errors
- Circle invalid data, Go To Special
- Work with Macros
- Record macro, view macro, VBA basics
Find it Faster – Using Lookup Functions and Formula Auditing | AUGUST 30, 10 AM
Learn the power of lookup functions and eradicate your errors
- Use Lookup Functions
- Vlookup, Hlookup, Index and Match, Xlookup
- Trace Cells
- Trace Precedents, Trace Dependents
- Watch and Evaluate Formulas
- Watch Window, Freeze Panes, Split Screen, New Window and Arrange All
- Error Checking, Evaluate Formula, Iferror
Work smarter, faster and easier with the shortcuts and tools you didn’t know you needed
- Work Smarter
- Customize the Quick Access Toolbar, Formatting tools, Formula tricks, Named Ranges
- Work Faster
- Shortcut keys, Fill Features, Flash Fill, Quick Charts, Save As
- Work Easier
- Paste options, screenshots, working with worksheets
- Work Error-Free
- Ignore errors, hide zeroes, autocorrect, iferror