Excel October: Webinars to Save Time and Advance Your Career

Excel October: Webinars to Save Time and Advance Your Career

Microsoft Excel is an application used in almost every organization. As the year-end approaches, now is the perfect time to master this powerful tool.

Spreadsheets will enable you to analyze annual results, budget for 2022, draw conclusions from large volumes of data, and save time. To help you harness the power of Excel, we have enlisted experts to show you how to do everything from creating a basic workbook to using advanced logical functions and pivot tables.

Excel October is packed with 16 webinars filled with accessible instructions and engaging examples. Even if you can’t attend live, all of the sessions will be available on demand for you to get the information you need. Register yourself for all sessions or split the registrations amongst your team for the same price. This special bundle represents a savings of over $700, available exclusively for you.

Electronic Spreadsheet Fundamentals Certification

How To Create Microsoft® Excel Workbooks

Monday, October 4

2:30 PM Eastern; 1:30 PM Central; 12:30 PM Mountain; 11:30 AM Pacific

• Five ways to create an Excel workbook in less time
• How to navigate the workbook
• The quickest way to select data
• Entering text and numbers
• Copying, cutting, pasting, and moving data
• Saving workbooks to multiple formats

Microsoft® Excel How To: Basic Formulas And Functions

Tuesday, October 5

2:30 PM Eastern; 1:30 PM Central; 12:30 PM Mountain; 11:30 AM Pacific

• Creating basic formulas
• Creating basic functions
• AutoSUM, COUNT, AVERAGE, etc.
• Absolute vs. relative references

Microsoft® Excel How To: Formatting

Wednesday, October 6

2:30 PM Eastern; 1:30 PM Central; 12:30 PM Mountain; 11:30 AM Pacific

• Formatting worksheets
• Easy ways to copy formats
• Using styles
• Conditional formatting

Microsoft® Excel How To: Tables And Charts

Thursday, October 7

2:30 PM Eastern; 1:30 PM Central; 12:30 PM Mountain; 11:30 AM Pacific

• Using lists and tables
• Creating charts
• Formatting charts
• Modifying charts

Microsoft® Excel How To: Date And Text Functions

Friday, October 8

2:30 PM Eastern; 1:30 PM Central; 12:30 PM Mountain; 11:30 AM Pacific

• Absolute vs. relative references (continued)
• Date functions (with commonly used examples)
• Text functions
• How to lock your cells to protect functions

Master Excel: A Four-Part Series

Master Excel: Excel Fundamentals

Tuesday, October 12

2:00 PM Eastern; 1:00 PM Central; 12:00 PM Mountain; 11:00 AM Pacific

• Excel terms and navigation
• Data organization through filtering and sorting
• Transpose
• Text functions and nest statements
• Basic math functions
• Advanced math functions

Master Excel: Next Steps With Excel

Wednesday, October 13

2:00 PM Eastern; 1:00 PM Central; 12:00 PM Mountain; 11:00 AM Pacific

• Text to columns
• Nested IF statements
• Duplicate values
• Conditional formatting
• Excel chart basics

Master Excel: Intermediate Excel

Thursday, October 14

2:00 PM Eastern; 1:00 PM Central; 12:00 PM Mountain; 11:00 AM Pacific

• Navigation, terminology, and keyboard shortcuts
• Lookups
• PivotTables
• Visualization

Master Excel: Advanced Excel

Friday, October 15

2:00 PM Eastern; 1:00 PM Central; 12:00 PM Mountain; 11:00 AM Pacific

• Advanced PivotTables
• Advanced PivotCharts
• Dashboards
• Slicers

[2-Part Series] Excel VLOOKUP Function Series

[2-Part Series] Excel VLOOKUP Function Series: Part 1

Tuesday, October 19

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• How to create named ranges
• VLOOKUP function
• Exact and approximate matches

[2-Part Series] Excel VLOOKUP Function Series: Part 2

Wednesday, October 20

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• VLOOKUP to match data from two workbooks
• MATCH function
• INDEX function
• XLOOKUP function

[2-Part Series] Excel PivotTables Series

[2-Part Series] Excel PivotTables Series: Part 1

Thursday, October 21

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• When to use PivotTables
• What you should know before you create a PivotTable
• Creating a PivotTable
• Formatting, sorting, and filtering PivotTables
• Creating PivotCharts

[2-Part Series] Excel PivotTables Series: Part 2

Friday, October 22

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• Customizing PivotTable formatting
• Changing PivotTable calculations
• Formatting PivotCharts
• Creating Advanced PivotCharts
• Sharing PivotTables and charts in PowerPoint, Word, and other apps
• Power tips, tricks, and shortcuts

[2-Part Series] Excel IF Function Series

Logical Function Overview

Tuesday, October 26

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• Four key skills needed for logical functions
• IF functions
• How to handle multiple IFs

Nested IF Functions

Wednesday, October 27

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

• IFs()
• Boolean functions (AND, OR, NOT)

Introduction To Aggregate IF Functions

Thursday, October 28

12:30 PM Eastern; 11:30 AM Central; 10:30 AM Mountain; 9:30 AM Pacific

Runtime: 90 minutes (including Q&A)

• SUMIF
• COUNTIF
• AVERAGEIF
• Pivot table alternatives