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

Excel Intermediate Part 1

Loading Map....

Class Date/Time
Date(s) - November 8, 2019
9:00 am - 4:30 pm

Class Location:
1800 Airport Freeway Bedford, TX 76022

Class Status:

Class is Full. Add Your Name to the Waiting List

Class Price:
$0.00

Class Outline

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.


Duration:

1 Day

Continuing Professional Education (CPE):

8 CPE Credits

Audience:

The class has been designed for users of Excel who have a basic knowledge of Excel.

Prerequisites:

Participants must have basic knowledge of entering data, formatting and simple formulas.  Participants will need to be familiar with the topics covered in the Excel Introduction course.


Course Content:

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
  • 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

Register for Class

This class is full. Bookings are closed for this class.