This Excel course starts by teaching basic Excel functionality, and core Excel formulas and techniques, including calculations, formatting, and charts. You will finish up the course with a project that pulls together all your newly learned Excel skills. This one-day Excel class provides a solid foundation to leverage Excel in your job. Attend this Excel workshop and learn:
- Data Entry & Calculations: Discover basic Excel calculations like averages, sums, and counts.
- Text Functions: Use functions to format and correct text such as changing the case of text automatically.
- Formatting and Format Painter: Learn to customize formatting and quickly replicate it to other cells.
- Conditional Formatting: Set format and appearance for cells based on specific criteria.
- Charts: Learn the essentials of creating and formatting line charts, bar charts, and pie charts.
- Excel efficiency tips: Learn to use Autofill & Quick Access so Excel can automate your work.
Excel Class - Introduction Course Dates
All classes are led by a live instructor. Class times listed are Eastern time.
| Course Title | Course Dates | Course Location | Fee | Register |
|---|---|---|---|---|
|
Excel Class - Introduction
Weekdays
Online |
Mon, Oct 11 2021 10:00 am to 5:00 pm |
Online Live instructor-led class online |
$249.00 | |
|
Excel Class - Introduction
Weekdays
Online |
Mon, Nov 8 2021 10:00 am to 5:00 pm |
Online Live instructor-led class online |
$249.00 | |
|
Excel Class - Introduction
Weekdays
Online |
Mon, Dec 6 2021 10:00 am to 5:00 pm |
Online Live instructor-led class online |
$249.00 |
Introductory Excel Class Topics Covered
Topics covered in the introductory Microsoft Excel course include the following:
Getting Started with Excel
- Getting to know the Excel Interface: learn to navigate within the Excel interface to access commands and functions.
- Data Entry using Excel: Understand various ways of entering data into an Excel file.
Using Excel Formulas
- Autofill in Excel: Learn to use Excel's predictive data entry
- Excel Calculations: Use excel for mathematical expressions
- True / False: Learn to have Excel test for matching data using true/false
- Functions in Excel: Discover essential AutoSum functions including: Sum, Average, Max, Min, and Count Numbers
- Excel’s Text Functions: Learn to use functions to modify text
- Multi-Input Functions: Learn advanced functions that require multiple inputs
- Constant (Absolute) Cell References: Learn to create constant cell references when required for calculations
Formatting Worksheets in Excel
- Formatting Excel sheets and content: Learn to provide visual cues to those reviewing sheets with formatting.
- Using the Format Painter in Excel: Learn to duplicate formatting from one cell to others.
- Applying Conditional Formatting: Discover how to apply formatting depending upon rules relating to content.
Working with Charts in Excel
- Understanding chart types
- Creating Line Chart: Create a line charts and spark lines to represent data visually.
- Column Charts using Excel: Learn to create column charts for data visualization.
- Pie Charts in Excel: Discover how to create pie charts for data visualization.
- Customizing charts: Adjusting charts to meet your design requirements.
- Creating Tables: Understand the functionality available when data is presented as a table.
Excel Workbook Management
- Printing & Exporting from Excel: Understand ways to easily print or convert Excel content to PDF.
- Using Multiple Worksheets in Excel: Learn to organize data by creating, moving, copying and managing Excel worksheets.
- Using Repeat Action: Learn to quickly duplicate prior actions in Excel.
- Saving Time with Excel Shortcuts: Discover shortcuts that save time and help you to work more efficiently.
Course prerequisites
We recommend that you have Microsoft Excel available to use after your return from this Excel class. A computer with Excel is provided for use during the course.
Course materials
You will receive a comprehensive Excel course manual for this class.
Free retakes
Detailed curriculum
Live instructor
Flexible rescheduling