|
|
 |
 |
|
In this Microsoft Excel tutorial for the intermediate user, you'll explore some powerful features in Excel for calculating and analyzing data. Learn how to write complex formulas using IF statements, work with PivotTables and add-ins, use database features such as forms and data validation and create your own Microsoft Excel macro commands and functions with VBA. |
|
|
Be notified when future sessions of this class open for enrollment.
Enter your name and email address below and we'll send you email notification when the next session becomes
available.
-
Write logical functions with IF statements
-
Set up conditional formatting
-
Use Boolean operators and concatenation
-
Analyze data with PivotTables
-
Install and use add-ins
-
Work with database functions, forms and validation
-
Record and save macros
|
|
-
This course is for intermediate-level Excel users who are already comfortable with data entry, formulas, functions, and formatting.
|
|
- Microsoft Excel tutorial: advanced Excel formulas and functions
- Microsoft Excel tutorial: working with data analysis tools
- Microsoft Excel tutorial: using Excel database tools
- Microsoft Excel macro commands and the VB Editor
|
|
|
|
|
