Skip to main content

Microsoft Excel Advanced (Level 2)

ID : 51147   
« back to classes page
DIVE DEEP INTO EXCEL!
Begin a deep dive into automating spreadsheets. Learn how to create linking formulas that automatically connect data over many different worksheets, allowing for easy one-time data entry. Add to your portfolio a group of the most powerful formulas frequently used in Excel. And then splash your spreadsheet with useful graphics and templates to highlight and connect key informational points.

What Will I Learn?
(1) Advanced Formatting – Themes, Cell Styles, Customizing Page Setup
(2) Date and Time Functions, Conditional Formatting
(3) Advanced Functions for Text and Analysis – IF Criteria, Troubleshooting Formulas
(4) Introducing Lookup (VLOOKUP and HLOOKUP) Functions and the Outline Features.

Prerequisite: Proficiency using any level of Microsoft Excel is required.

Class Details

2 Sessions
Weekly - Tue, Wed

Location
LFCC Fauquier Campus

Instructor
James Naccash 

CEUs : 1

Price: 

$205.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
10/23/2018 - 10/24/2018 Weekly - Tue, Wed 9:00 AM - 3:00 PM Warrenton, LFCC Fauquier Campus  Map, Room: FC, Wolk Hall, Rm 202 James Naccash 

Other Class Offerings

ID: 51069

11/07/18 - 11/08/18
Weekly - Wed, Thu
2 sessions.

ID: 51072

11/13/18 - 11/15/18
Weekly - Tue, Wed, Thu
3 sessions.

ID: 51073

03/26/19 - 03/28/19
Weekly - Tue, Wed, Thu
3 sessions.

ID: 51070

04/10/19 - 04/11/19
Weekly - Wed, Thu
2 sessions.