• Home
  • Classes and Prices
  • Course Outlines
    • Windows 10/11
    • Word 365
    • Excel 365
    • PowerPoint 365
    • Access 365
    • Outlook 365
    • Office 3-Day Boot Camp
  • 2025 Schedule
  • Register
  • Downloads
  • More
    • Home
    • Classes and Prices
    • Course Outlines
      • Windows 10/11
      • Word 365
      • Excel 365
      • PowerPoint 365
      • Access 365
      • Outlook 365
      • Office 3-Day Boot Camp
    • 2025 Schedule
    • Register
    • Downloads
  • Home
  • Classes and Prices
  • Course Outlines
    • Windows 10/11
    • Word 365
    • Excel 365
    • PowerPoint 365
    • Access 365
    • Outlook 365
    • Office 3-Day Boot Camp
  • 2025 Schedule
  • Register
  • Downloads

Excel 365 All Levels

Excel Level I: 1 Day $295

Chapter 1: Getting Started

  • A tour of the interface
  • Spreadsheet terminology
  • The Excel environment
  • Navigating a worksheet
  • Using a template

Chapter 2: Entering and Editing Data

  • Entering and editing text and values
  • Using Autofill for text and numbers
  • Entering editing formulas
  • Saving and updating workbooks

Chapter 3: Modifying a Worksheet

  • Using cut, copy, and paste
  • Moving, copying, and viewing formulas
  • Absolute and relative cell references
  • Inserting and deleting ranges, rows, and columns

Chapter 4: Functions

  • Using SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, TODAY, and NOW
  • Using Autosum
  • Other common functions

Chapter 5: Formatting

  • Text formatting
  • Row and column formatting
  • Number formatting
  • Using the Conditional Formatting tool
  • Formatting guidelines

Chapter 6: Graphics

  • Inserting a picture
  • Moving and resizing a picture
  • Formatting a picture
  • Using SmartArt graphics

Chapter 7: Printing

  • Preparing to print
  • Page setup options
  • Printing your final worksheet

Excel Level I: 1 Day $295

Chapter 2: Entering and Editing Data

  • Entering and editing text and values
  • Using Autofill for text and numbers
  • Entering editing formulas
  • Saving and updating workbooks

Chapter 3: Modifying a Worksheet

  • Using cut, copy, and paste
  • Moving, copying, and viewing formulas
  • Absolute and relative cell references
  • Inserting and deleting ranges, rows, and columns

Chapter 4: Functions

  • Using SUM, AVERAGE, MIN, MAX, COUNT, COUNTIF, TODAY, and NOW
  • Using Autosum
  • Other common functions

Chapter 5: Formatting

  • Text formatting
  • Row and column formatting
  • Number formatting
  • Using the Conditional Formatting tool
  • Formatting guidelines

Chapter 6: Graphics

  • Inserting a picture
  • Moving and resizing a picture
  • Formatting a picture
  • Using SmartArt graphics

Chapter 7: Printing

  • Preparing to print
  • Page setup options
  • Printing your final worksheet

Excel Level II: 1 Day $295

Chapter 1: Managing Workbooks and Worksheets

  •  Viewing large worksheets
  • Printing large worksheets
  • Working with multiple worksheets
  • Linking worksheets and 3-D formulas
  • Using multiple workbooks
  • Linking workbooks

Chapter 2: Advanced Formatting

  •  Using special number formats
  • Working with themes
  • Other advanced formatting

Chapter 3: Outlining and subtotals

  • Using the Outlining tool
  • Manipulating the outline
  • Creating subtotals

Chapter 4: Cell and Range Names

  • Understanding why named ranges are important
  • Creating and using named ranges in formulas
  • Managing names

Chapter 5: Data Structure and Tables

  • Sorting and filtering data
  • Using the Format as Table tool

Chapter 6: Documenting and Auditing

  • Auditing features
  • Comments in cells
  • Protection
  • Workgroup collaboration

Excel Level III: 1 Day $295

Chapter 1: Advanced Functions and Formulas

  • Logical functions (IF, AND, NOT, and OR)
  • Conditional functions (SUMIF, AVERAGEIF, COUNTIF)
  • Financial functions (PMT)
  • Text functions (CONCAT, RIGHT, LEFT)
  • Date and time functions (NOW, TODAY, NETWORKDAYS, DAYS360)

Chapter 2: Lookups and Data Tables

  • Using look functions (VLOOKUP, HLOOKUP, XLOOKUP)
  • Creating data tables

Chapter 3:Advanced Data Management

  • Validating cell entries
  • Advanced filtering

Chapter 4: Pivot Tables and Pivot Charts

  • Preparing to insert a Pivot Table
  • Inserting a Pivot Table
  • Modifying a Pivot Table
  • Formatting a Pivot Table
  • Inserting a Pivot Chart
  • Modifying a Pivot Chart
  • Inserting and manipulating Slicers

Chapter 5: Importing and Exporting Data

  • Preparing to import text files
  • Importing text files

Chapter 6: Analytical Tools

  • Using Goal Seek
  • Inserting a Scenario

Add a footnote if this applies to your business

Special Topics in Excel

Excel Advanced: Analyzing Data $395

This Instructor-led Training course covers the advanced skills and concepts students need to use Microsoft Excel 365 for analyzing data. Students will learn how to analyze data with advanced Excel formulas and learn how to take advantage of Excel’s built-in tools for summarizing data including advanced functions such as Pivot Tables, slicers, outlines, Sort, Filter, and advanced functions. They will also learn how to work with larger workbooks and “clean up” data. This class is perfect for stu

Chapter 1: A Review of Basic Functions

  • A review of basic mathematical operations
  • Using AutoSum and the Sum function
  • Using Average, Count, and CountA
  • Using  the Min and Max functions

Lesson 2: Calculate with Advanced Functions

  • Vlookup (exact match)
  • Vlookup (approximate match)
  • Hlookup (exact match)
    Hlookup (approximate match)
  • IF, OR, NOT, AND
  • SumIf
  • Proper
  • Concat (formerly "concatenation")
  • Average
  • AverageIf 
  • Count
  • CountIf 

Chapter 3: Organize Worksheet and Table Data Using Various Tools

  • Conditional formatting
  • Grouping and outlining
  • Using the subtotals tool
  • Advanced sorting techniques
  • Using the filter tool
  • Using formulas with custom filters

Chapter 4: Formulas in Multiple Workbooks

  • Creating 3-dimensional formulas (formulas that calculate values across worksheets and workbooks) 
  • How to create a Dashboard to tell a story about your data

Chapter 5: Tools for Analyzing Data

  • Introduction to large worksheets
  • Inserting PivotTables
  • Inserting PivotCharts
  • Inserting Slicers
  • Inserting Sparklines

Chapter 6: Charting and Graphing

  • Understanding available graph styles
  • Creating a pie chart
  • Formatting a pie chart
  • Creating a column chart
  • Formatting a column chart
  • Manipulating chart data

Chapter 7: Cleaning up Data

  • Proper spreadsheet setup
  • Using find and replace
  • Using the LEFT and RIGHT function
  • Using the TRIM function

OfficeTrainingLady.com

3840 Regal Oaks Dr., Suwanee, GA 30024

(678) 389-1878

Copyright © 2025 OfficeTrainingLady.com - All Rights Reserved.

Powered by GoDaddy

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept