Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

Public Excel Classes

Our Public Excel Classes are held across the Dallas Fort Worth Metroplex and are open to everyone. We provide you everything you need for the class, so all you need to do is dress comfortably and show up. In each class we will provide you with a full size training computer, Excel training file, Excel training binder, and a laminated Excel shortcut guide.

Public Classes Schedule

DateClassLocationPriceRegistration
May 24, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Class is Full. Waiting List
June 3, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Class is Full. Waiting List
June 20, 2019 Excel Introduction Dallas, TX$395.00 Register
June 21, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Class is Full. Waiting List
July 12, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Class is Full. Waiting List
July 19, 2019 Excel Introduction Fort Worth, TX$395.00 Register
July 25, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Class is Full. Waiting List
August 12, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Register
August 28, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Register
September 16, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Register
September 27, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Register
October 9, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Register
October 23, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Register
November 8, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Register
November 11, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Register
December 6, 2019 Excel Intermediate Part 1 Bedford, TX$395.00 Register
December 9, 2019 Excel Intermediate Part 2 Bedford, TX$395.00 Register

Need to Pay via an Invoice?

No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

Level 1: Excel Introduction

Overview

This class is designed for people who are new to Microsoft Excel or have very limited experience with Microsoft Excel. The learning outcomes of this class cover the basic day to day tasks required to work with an Excel spreadsheet.

Price

$395 per Student

Prerequisites

Participants must have basic keyboard and mouse skills and be familiar with the Windows operating system.

Duration

1 Day

Class Outline

Getting Started with Excel
  • Working with the Excel Environment
  • Title Bar
  • Ribbon and Ribbon Tabs
  • Quick Access Toolbar
  • Worksheet Views
  • Backstage View
Creating and Opening Workbooks
  • Create New Workbook
  • Open Existing Workbook
  • Pin a Workbook
  • Using Templates
  • Compatibility Mode
Saving and Sharing Workbooks
  • Save and Save As
  • Auto Recovery
  • Exporting Workbooks
  • Sharing Workbooks
Cell Basics
  • Understanding Cells
  • Select a Cell
  • Select a Cell Range
  • Inserting Cell Content
  • Deleting Cell Content
  • Cutting & Pasting Cell Content
  • Drag and Drop Cells
  • Completing Series with Fill Handle
Modifying Columns, Rows, and Cells
  • Changing Column Width
  • Changing Row Height
  • Inserting & Deleting Columns and Rows
  • Hiding & Showing Columns and Rows
  • Wrapping Cell Text
  • Merging Cells

Formatting Cells
  • Font Type, Size, Color, and Decorations
  • Cell Borders and Fill Colors
  • Cell Alignment and Styles
Cell Formats
  • Number Formats
  • Percentage Formats
  • Date Formats
Working with Multiple Worksheets
  • Inserting Worksheets
  • Copying Worksheets
  • Deleting Worksheets
  • Moving Worksheets
  • Renaming Worksheets
  • Changing Worksheet Tab Colors
  • Grouping and Ungrouping Worksheets
Using Find and Replace
  • Finding Text
  • Replacing Text
Page Layout and Printing
  • Print Pane
  • Print Area
  • Page Orientation
  • Page Breaks
Intro to Formulas
  • Formulas Overview
  • Mathematical Operators
  • Cell References
  • Creating Formulas
  • Copying Formulas

Creating More Complex Formulas
  • Order of Operations
  • PEMDAS
Relative and Absolute Cell References
  • Relative References
  • Absolute References
  • Cell References Across Worksheets
Functions
  • Functions Overview
  • Parts of a Function
  • Function Arguments
  • Using Functions
  • Function Library
IF Function
  • IF Function Overview
  • IF Function Arguments
  • Using the IF Function
VLOOKUP Function
  • VLOOKUP Function Overview
  • VLOOKUP Function Arguments
  • Using the VLOOKUP Function
Charts
  • Charts Overview
  • Chart Components
  • Chart Layout and Styles

Level 2: Excel Intermediate Part 1

Overview

This class is designed for people who have a basic knowledge of Excel, and who want to increase their knowledge of the practical uses of Excel. By the completion of this class, participants will have a thorough knowledge of using Excel to manage data in multiple sheets in an Excel workbook. Excel Intermediate Part 1 is focused on managing your data through the of a variety of Excel features and functions. After taking this class, we highly recommend taking the Excel Intermediate Part 2 class which is focused on presenting your data.

Price

$395 per Student

Prerequisites

Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Introduction class.

Duration

1 Day

Class Outline

Tables
  • Tables Overview
  • Table Structured Cell References
  • Table Styles
  • Table Options
  • Table Slicers
  • Converting Tables to Ranges
  • Removing Duplicate Rows
Range Names
  • Range Names Overview
  • Navigating Range Names
  • Creating Range Names
  • Creating Range Names in Bulk
  • Assigning Range Names
  • Using Range Names in Formulas
  • Managing Range Names
Functions Overview
  • Functions Overview
  • Functions vs Formulas
  • Why use Functions?
Date and Time Functions
  • NOW Function
  • TODAY Function
  • YEAR Function
  • MONTH Function
  • DATE Function
  • DAYS Function

Statistical Functions
  • SUM Function
  • AVERAGE Function
  • MIN Function
  • MAX Function
  • MEDIAN Function
  • COUNT Function
  • COUNTA Function
  • COUNTBLANK Function
Text Functions
  • CONCAT Function
  • PROPER Function
  • UPPER Function
  • LOWER Function
  • LEFT Function
  • RIGHT Function
  • MID Function
  • TRIM Function
  • LEN Function
  • FIND Function
  • SUBSTITUTE

Logical Functions
  • IF Function
  • IFS Function
  • Nested IFs Function
  • AND Function
  • OR Function
  • COUNTIF Function
  • COUNTIFS Function
  • SUMIF Function
  • SUMIFS Function
  • AVERAGEIF Function
  • AVERAGEIFS Function
Lookup Functions
  • VLOOKUP Function
  • HLOOKUP Function
  • INDEX Function
  • MATCH Function
Flash Fill
  • Using Flash Fill
  • Troubleshooting Flash Fill
  • Limitations of Flash Fill

    Level 2: Excel Intermediate Part 2

    Overview

    This class is designed for people who have basic knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use. By the completion of this class participants will have a thorough knowledge of Excel data presentations tools including Data Validation, Conditional Formatting, Advanced Charts, PivotTables, and PivotCharts. This is the second half of our Excel Intermediate Class. The Excel Intermediate Part 1 is focused on managing your data through the of a variety of Excel features and functions, while the Excel Intermediate Part 2 class is focused on presenting your data.

    Price

    $395 per Student

    Prerequisites

    Participants must have basic knowledge of entering data, formatting and simple formulas. Participants should be familiar with the topics covered in the Excel Introduction class.

    Duration

    1 Day

    Class Outline

    Data Validation
    • Understanding Data Validation
    • Data Validation Rule Setting
    • Data Validation Tool Tips
    • Data Validation Custom Error Messages
    Conditional Formatting
    • Understanding Conditional Formatting
    • Highlight Cell Rules
    • Top/Bottom Rules
    • Data Bars
    • Color Scales
    • Icon Sets
    • Custom Rules
    • Advanced Rules based on Formulas
    • Creating a Schedule (Gantt Chart) using Conditional Formatting

    Advanced Charts
    • Waterfall Chart
    • Histogram Chart
    • Pareto Chart
    • Box & Whisker Chart
    • Treemap Chart
    • Sunburst Chart
    • Sparkline Cell Chart
    PivotTable Fundamentals
    • Preparing the Data
    • Anatomy of a PivotTable
    • Slicing and Dicing with a PivotTable
    • Grouping Data
    • Sorting Data
    • Custom PivotTable Field Names
    • PivotTable Slicers
    • PivotCache
    • Refreshing Data

    PivotTable Calculations
    • Customize Subtotals
    • Showing Values as Calcuations
    • Calculated Fields
    • Calculated Items
    PivotCharts
    • Creating a PivotChart
    • PivotChart Control Buttons
    • PivotChart and PivotTable Filters

    Level 3: Excel Power Query (Get & Transform)

    Overview

    Power Query is a data connection technology that comes with Excel that enables you to discover, connect, combine, and refine data sources to meet your analysis needs. Features in Power Query are available in Excel and Power BI Desktop. With Power Query you can search for data sources, make connections, and then shape that data (for example remove a column, change a data type, or merge tables) in ways that meet your needs. Once you’ve shaped your data, you can share your findings or use your query to create reports. This class is designed to teach Power Query from the ground up and assumes you have not used Power Query in the past. Once we have covered the foundational topics of Power Query, then we will move on to the Power Query M language (code) that is used to create queries in Power Query.

    Price

    $395 per Student

    Who this course is for
    • New to Power Query or never been formally trained in Power Query
    • Users who utilize often the VLOOKUP and INDEX/MATCH Functions
    • People performing Data Analytics in Excel, Power Pivot, Power BI, Tableau, Python, R
    • Business Intelligence Specialists using Excel, Tableau, Power Pivot, Power BI, Python, R
    • Data Analysts / Financial Analysts using Excel, Tableau, Power Pivot, Power BI, Python, R
    • If you or your team needs to fetch data from different sources and transform it so that it can be used in Excel for further analysis, then this course will help you master Power Query features from scratch
    • IT specialists who performs Extract Transform & Load (ETL) activities for business

    Duration

    1 Day

    Class Outline

    Power Suite Overview
    • What is Power Pivot, Power Query, Power View and Power Map
    • The Power Suite Workflow
    • Power Query Examples
    • Power Pivot Examples
    • Power View Examples
    Data Loading Options
    • Common Usage Patterns
    • Load to a Table
    • Load to a Pivot Table
    • Load to a Pivot Chart
    • Only Create Connection
    • Add to the Data Model

    Standard Transformations
    • Basic Data Transformations
    • Text Data Transformations
    • Number Data Transformations
    • Date Data Transformations
    Advanced Transformations
    • Indexes and Conditional Columns
    • Grouping and Summarizing Data
    • Transposing Data
    • Pivoting and UnPivoting Data
    Merging, Appending, and Updating Queries
    • Updating Workbook Queries
    • Combining Multiple Queries
    • Appending Queries
    • Utilizing a Folder of Data Files

     

    Custom Columns
    • Columns From Examples
    • Custom Columns
    M Language and Advanced Query Editor Concepts
    • M Language Overview
    • Parameters in Power Query
    • Maintaining Parameters
    • Custom M Function Overview
    • Custom M Functions with Parameters
    • Custom M Functions using Advanced Editor
    Query Organization and Dependencies
    • Grouping Queries
    • Query Dependency View

    Level 3: Power Pivot and DAX

    Overview

    You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how power pivot  will help to analyze the comprehensive data to make timely business decisions. 

    Price

    $395 per Student

    Who this course is for

    • Excel users that know to pull data in Excel using Power Query and are now ready to summarize and analyze the data in Power Pivot.

    Duration

    1 Day

    Class Outline

    Power Suite Overview
    • What is Power Pivot, Power Query, Power View and Power Map
    • The Power Suite Workflow
    • Power Query Examples
    • Power Pivot Examples
    • Power View Examples
    Data Modeling
    • Introduction
    • Understanding Excel’s Data Model
    • Data View versus Diagram View
    • Database Normalization
    • Data Tables versus Lookup Tables
    • Relationships versus Merged Tables
    • Creating Table Relationships
    • Updating Table Relationships
    • Active versus Inactive Relationships
    • Relationship Cardinality
    • Connecting Multiple Data Tables
    • Data Filter Direction
    • Hiding Fields from Client Tools
    • Defining Hierarchies

    Power Pivot and DAX
    • Introduction
    • Creating a Power Pivot Table
    • Power Pivots versus Normal Pivots
    • Data Analysis Expression (DAX) Overview
    • Calculated Columns
    • DAX Measures
    • Creating Implicit Measures
    • Creating Explicit Measures (AutoSum)
    • Creating Explicit Measures (Power Pivot)
    • Filter Context
    • Measure Calculation Steps
    • Dimensions vs Measures
    • Best Practices

    Popular DAX Functions
    • Introduction
    • DAX Formula Syntax and Operators
    • Common DAX Function Categories
    • Basic Math and Statistical Functions
    • COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS Functions
    • Logical Functions: IF, AND, OR
    • SWITCH Function
    • Text Functions: LEN, CONCATENATE, UPPER, LOWER, PROPER, LEFT, MID, RIGHT, SEARCH, SUBSTITUTE
    • CALCULATE Function
    • Adding Filter Context with FILTER
    • Removing Filter Context with ALL
    • Joining Data with RELATED Function
    • Iterator (“X”) Functions: SUMX
    • Iterator (“X”) Functions: RANKX
    • Date and Time Functions
    • Time Intelligence Formulas
    • Speed and Performance Factors
    • DAX Best Practices

      Level 3: Excel Dashboards – Part 1

      Overview

      This class is designed for people who have intermediate knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use like a dashboard. There are two main Excel dashboard design patterns: PivotCharts with Slicers Dashboard design and Interactive Charts Dashboard Design. This class provides an overview of both design patterns, but goes much more in-depth on the PivotCharts with Slicers Dashboard design pattern.

      Price

      $395 per Student

      Prerequisites

      Participants must have an intermediate level knowledge and experience with Microsoft Excel. Participants should be familiar with PivotTables.

      Duration

      1 Day

      Class Outline

      Dashboard Key Concepts
      • What is the Purpose of the Dashboard
      • What are the data sources
      • Who will use the Dashboard
      • How frequently does the Dashboard need to be updated
      • What version of Office do the stakeholders use
      • What operating system will be used by the stakeholders
      • Mockup the Structure of the Dashboard
      Getting the Data in Excel
      • Copying and Pasting
      • File Import
      • Database Table Import

      PivotChart with Slicers Dashboards
      • Example Dashboards
      • Key Components of Dashboard
      • Basic Steps to Create Dashboard
      • PivotTable Cache
      PivotChart with Slicers Dashboards Integrating Everything Together
      • Creating Dashboards
      • Creating Dashboards with Multiple Sheets
      • Utilizing Hyperlinks for Navigation
      • Utilizing Icons for Navigation
      • Drilling into Details of Dashboard Charts

      Interactive Charts Dashboard Basics
      • Design Overview and Process
      • Form Controls
      • Controlling Chart Series with Check Boxes
      • Controlling Chart Series with a Value in a Cell
      • Controlling Chart Displayed based on a Combo Box
      • Controlling Chart Displayed based on Data Validation List
      • Controlling the Range of Data in a Chart Dynamically with Scroll Bar
      Interactive Charts Dashboard Integrating Everything Together Overview
      • Worksheet Organization
      • Data Sheets, Calculation Sheets, and Dashboard Sheets
      • Understanding Elements of Complex Dashboards

      Level 4: Excel Dashboards – Part 2

      Overview

      This class is designed for people who have intermediate knowledge of Excel, and who want to improve the presentation of data in Excel. Excel provides many tools for analyzing data however it is often a challenge to present the data in a meaningful way for others to use like a dashboard. There are two main Excel dashboard design patterns: PivotCharts with Slicers Dashboard design and Interactive Charts Dashboard Design. This class provides a brief overview of both design patterns, but then goes in a deep dive on Interactive Charts Dashboard. The class is project based and consists of building out multiple Interactive Charts Dashboards in the class.

      Price

      $395 per Student

      Prerequisites

      Participants must have an intermediate level knowledge and experience with Microsoft Excel. It is highly recommended that participants have completed Excel Dashboards Part 1 class before attending this class.

      Duration

      1 Day

      Class Outline

      Dashboard Key Concepts
      • What is the Purpose of the Dashboard
      • What are the data sources
      • Who will use the Dashboard
      • How frequently does the Dashboard need to be updated
      • What version of Office do the stakeholders use
      • What operating system will be used by the stakeholders
      • Mockup the Structure of the Dashboard
      Excel Dashboard Design Patterns
      • PivotCharts with Slicers Dashboard Design Pattern
      • Interactive Charts Dashboard Design Pattern

      Operating Revenue Dashboard
      • Mockup the Dashboard
      • Identify Key Excel Features Required to Make Dashboard
      • Capture the Data for the Dashboard
      • Create Calculation Sheets
      • Create Dashboard Sheets
      • Integrate Process into Seamless Dashboard Experience

      Customer Satisfaction Dashboard
      • Mockup the Dashboard
      • Identify Key Excel Features Required to Make Dashboard
      • Capture the Data for the Dashboard
      • Create Calculation Sheets
      • Create Dashboard Sheets
      • Integrate Process into Seamless Dashboard Experience

      Level 4: Excel Advanced Functions

      Overview

      This class is designed for people who have intermediate knowledge of Excel, and who want to develop a stronger understanding of advanced Excel functions. The Advanced Functions class is designed for people who want to master complex calculations using the built in Microsoft Excel Functions.

      Price

      $395 per Student

      Prerequisites

      For best results, participants should have attended or be familiar with all the topics covered in the Excel Intermediate classes including working with named ranges.

      Duration

      1 Day

      Class Outline

      Logical Functions

      This section covers using the logical functions. IF() is one of the most useful functions, but it is not the only one.

      • IF, COUNTIF, COUNTIFS
      • SUMIF, SUMIFS
      • AND, OR and NOT
      Lookup and Reference Functions

      This section you will learn how to search for and extract important data. There are three different types – lookup functions find and copy data from a particular cell; reference functions retrieve more general information like how many rows or columns are in a range.

      • VLOOKUP, HLOOKUP
      • MATCH
      • INDEX
      • CHOOSE
      • OFFSET
      • INDIRECT
      • COLUMN, ROW

      Date and Time Functions

      If you need to calculate with dates and times, Excel provides a number of useful functions.

      • DATE, DAY, MONTH, YEAR
      • HOUR, MINUTE, SECOND
      • WEEKDAY
      • WORKDAY
      • NETWORKDAYS
      • WEEKNUM
      • DATEDIF
      • EOMONTH
      • EDATE
      Text Functions

      Excel gives you specialized functions to manipulate text rather than performing numerical calculations. You may want to replace a character in a word, capitalize a name, or count the number of letters in a cell.

      • CONCATENATE, TRIM
      • VALUE, LEN
      • LEFT, RIGHT, MID
      • FIND, SEARCH

      Auditing Functions

      These functions let you retrieve information about the type of content found in any particular cell. Most will be used in conjunctions with other functions.

      • ISBLANK
      • ISNUMBER, ISTEXT
      • ISERROR
      • ISLOGICAL
      • ISFORMULA
      Arrays
      • Creating an array
      • SUMPRODUCT

      Level 4: Excel VBA Macro Programming

      Overview

      Visual Basic for Applications is the integrated programming language used in Excel. In this class we take an in-depth look at this language, and how it is applied to developing programs & automating operations in Excel.

      Price

      $895 per Student

      Prerequisites

      For best results, participants should have attended or be familiar with all the topics covered in the Excel Intermediate classes including working with named ranges.

      Duration

      2 Days

      Class Outline

      Introduction to VBA
      • Why use VBA if I can record macros in Excel?
      • Recoding a Simple macro
      • Reviewing the code
      • Familiarisation with the VBA environment
      • Running Code from the VB Editor window
      • Getting help on code
      • Stepping through a procedure
      • Using a Break point
      • Communicating with the User
      VBA Terminology
      • Modules and procedures
      • Components of your code
      • Objects, Collections, Properties and methods
      • Using the Excel Object model
      Data Types, Variables and Operators
      • Working with variables and constants
      • Using Data types
      • Working with operators and expressions
      • Implicit and Explicit Declarations
      • Variable Scope – Procedural, Modular or Public
      • Passing variables by Value
      • Passing variables by Reference
      • Using Arrays
      Workbooks and Worksheets
      • Workbook objects and methods
      • Creating a new workbook
      • Adding and Renaming Sheets
      • Saving and Closing a Workbook

      Functions
      • Mathematical functions
      • Date and time functions
      • String functions
      • Using Excel functions in VBA code
      User Defined Function Procedures
      • Creating User Defined functions
      • Using user-defined functions in a worksheet
      • Declaring Multiple arguments in a function
      • Creating a Function Library
      Loops
      • Do Until and Do While loops
      • Looping at least once
      • For Next Loop
      • For Each Loops with collections
      Decision Structures
      • Using IF to make decisions
      • Testing for multiple conditions
      • Establishing Flow control
      • Branching
      • Call other procedures
      Working with Names
      • Adding Names
      • Deleting Names
      • Creating Hidden Names
      • Checking for the Existence of a Name

      Manipulating data
      • Working with the Ranges and Selections
      • Using the Cells Property to Select a Range
      • Using the Offset Property to Refer to a Range
      • Using the Columns and Rows Properties
      • Using the Union Method to Join Multiple Ranges
      • Using the IsEmpty Function
      • Using the CurrentRegion Property
      • Using the Areas Collection
      File management techniques in VBA
      • Open and Save files
      • Copy, move and delete files
      • Changing folders
      • Using Excel Open and SaveAs dialog boxes in code
      Custom Forms / Dialog boxes
      • Creating a user form
      • Labels, text boxes, combo boxes and list boxes
      • Setting properties for the form and controls
      • Assigning data to combo boxes and list boxes
      • Option buttons, Groups, checkboxes and buttons
      • Creating the event code for controls
      • Initialising the form
      • Closing the form
      • Using RefEdit to allow user interaction
      Managing Information with VBA
      • Linking Excel to an Access database
      • Adding a Record to the Database from Excel
      • Retrieving Records from the Database
      • Updating an Existing Record

      Contact Us

      Phone

      817-841-9560

      Email

      excel@dfwexcel.com

      Office Address

      5608 Malvey Ave,
      Suite 14620,
      Fort Worth, TX 76107

      Mailing Address

      PO Box 712
      Aledo, TX 76008

      Communication Preference

      5 + 10 =

      Share This