Excel October: Webinars to Save Time and Advance Your Career

with
Jackie Kiadii and Miri Miller
Training Bundle
$1,199.00
Training Includes:
  • All resources and training materials
  • An on-demand recording will be available after each live presentation.

To help you harness the power of Excel, we have enlisted experts Jackie Kiadii and Miri Miller to show you how to do everything from creating a basic workbook to using advanced logical functions and pivot tables.

Bundle Includes:

  • Electronic Spreadsheet Fundamentals Certification
  • Master Excel: A Four-Part Series
  • [2-Part Series] Excel VLOOKUP Function Series
  • [2-Part Series] Excel PivotTables Series
  • [3-Part Series] Excel IF Function Series

Training Overview

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

Who Should Attend?

Everyone who uses or could use Excel, including:

  • Human resources professionals

  • Business owners

  • Plant managers

  • Finance professionals

  • Operations managers

  • Contract managers

  • Contract administrators

  • Commercial managers

  • Supply chain managers

  • Supplier relationship managers

  • Supply base managers

  • Strategic sourcing managers

  • Procurement managers

  • Supervisors

  • Development staff

  • Program directors
  • Hiring staff

  • Nonprofit chief executives

  • Executive directors

  • Development staff

  • Consultants

  • Marketing staff

  • Fundraising staff

  • School district administrators

  • Charter school board members

  • Principals

  • Assistant principals

  • Department chairs

  • Curriculum specialists

  • Community engagement professionals

Expert Presenter

Jackie Kiadii

  • Founder of Phoenix Computer Consultants, LLC, an Atlanta-based IT services firm
  • Helping clients leverage technology to increase their productivity and profitability since 2001
  • Provides curriculum development, consulting, and training in Microsoft 365® applications
  • Microsoft® Certified Trainer and Microsoft® Certified Expert – Excel

Miri Miller

  • Senior Associate at RPX Corporation, a patent mitigation risk firm
  • Data analyst who integrates patent litigation data from various sources and provides easily understood results stemming from complex questions to meet the needs of multiple internal clients
  • Leading excel classes for over three years
  • Leads a discussion group at Common Space Forum