Revision of the Basics
Revision of the topics from the Introduction Course.
Conditional formatting.
Relative v's Absolute Cell Addressing
Relative cell addressing explained.
Working with absolute cell references.
Working with Multiple Sheets
Renaming, duplicating and moving sheets.
Entering and consolidating data across multiple sheets.
Creating Charts
Creating an Auto Chart
Using the Chart Wizard to create and edit charts.
Range Names
Understanding the advantages of using range names
Defining or creating range names.
Using or applying range names.
Importing Data from another Application
Converting a text file into a spreadsheet.
Fixed width and delimited text files.
Using Logical and Reference Functions
Using the IF function for analysis
Using the VLOOKUP and MATCH functions for reference
Course Overview:
This course is designed for existing users of Microsoft Excel. Delegates will acquire further Spreadsheet skills in order to manipulate Microsoft Excel and become more efficient with the product.
Course Duration:
1 Day
Course Pre-requisites:
Delegates should have attended the Microsoft Excel Introduction course or have the equivalent skills and knowledge to that level.At the end of this course
you will be able to:
- Revisions of the Basics.
- Relative v's Absolute Cell Addressing.
- Working with Multiple Sheets.
- Creating Charts.
- Introducing Range Names.
- Importing Data from another Application.
- Using Logical & Reference Functions.
Price Band:
General
