Upgrade your knowledge of Excel! This course indludes:
Spreadsheet Design and Management
Formulae and Functions
PivotTable Analysis
Advanced Charts
Microsoft Excel Intermediate Course Content
Course Duration
Course Objectives
Who is this Course for
Course Prerequisites
Working with Formulas
Creating Simple Formulas:
• Basic Mathematical Operators
Absolute and Relative Formulas:
• Relative Cell References
• Absolute Cell References
Using Formulas across Worksheets:
• Using Formulas across Worksheets
Formula Auditing:
• Fixing Formula Errors
• Displaying And Printing Formulas
Working with Functions
Sum and Average Functions:
• Using the Insert Function Window
• Function Syntax
Using IF and Nested Functions:
• Using the IF Function
• Working with Nested Functions
Naming Cell Ranges:
• What Are Range Names?
• Defining And Using Range Names
• Selecting Nonadjacent Ranges
• Auto Calculate
Functions and Array Formulas:
• What Are Array Formulas
• Using Basic Array Formulas
• Using Functions with Array Formulas
• Using the IF Function in Array Formulas
Text Functions:
• CONCATENATE
• LEFT and RIGHT Functions
• UPPER, LOWER and PROPER Functions
Excel Lists & Tables
• What Is A List/Table?
• Creating Lists/Tables
• Modifying Lists/Tables
• What Is The Total Row?
Working with Records and Fields:
• What Are Records And Fields?
• Adding Fields By Inserting Columns
• Adding Records By Inserting Rows
• Adding Records With A Data Form
• Finding And Deleting Records
Working with Lists and Filters:
• Sorting A List
• What Is An Autofilter
• Custom Autofilters
• Using An Advanced Filter
• Filtering With Wild Card Characters
• Copying Filtered Records
Using Excel as a Database
Using Database Functions:
• Using Database Functions
Data Validation:
• Data Validation
The VLOOKUPÂ & HLOOKUP Functions:
• VLOOKUP • HLOOKUP
Using Excel with Other Programmes
• Inserting Excel Data In Word
• Modifying Excel Data After Insertion
• Linking Excel Data In Word
• Linking An Excel Chart In Word
Using Excel with Other Programs and Files:
• Using Outlook To Send Excel Data
• Opening An Excel File In A Different Format
• Importing Data From A Text File
• Importing Data From A Database
Working with Charts
• Using the Chart Wizard
Modifying a Chart’s Appearance:
• Modifying a Chart’s Appearance
Other Chart Types:
• Other Chart Types
Reusing a Custom Chart:
• Reusing a Custom Chart