Microsoft Excel - Intermediate
Microsoft Excel Intermediate
This course is designed for existing users of Microsoft Excel who would like to expand their
knowledge and learn more of the techniques associated with creating better and more
productive workbooks.
Learning Outcomes
• Modify Excel Options
• Understand and use Formula Cell Referencing
• Use the fill operations
• Create and use Defined Names
• Use Common Worksheet Functions
• Apply a range of number formatting techniques
• Apply conditional formatting to ranges in a worksheet
• Use a variety of data validation techniques
• Use data linking to create more efficient workbooks
• Use goal seeking to determine the values required to reach results
• Work with tables in Microsoft Excel
• Understand and create simple Pivot Tables
• Use a range of elements and features to enhance charts
Course Subjects
• Understanding Excel Options
• Personalising Excel
• Setting the Default Font
• Setting Formula Options
• Understanding Save Options
• Absolute vs Relative Referencing
• Relative Formulas and Problems
• Creating Absolute References
• Creating Mixed References
• Understanding Filling
• Extracting with Flash Fill
• More Complex Flash Fill Extractions
• Extracting Dates and Numbers
• Understanding Defined Names
• Defining Names from Worksheet Labels
• Using Names in Typed Formulas
• Applying Names to Existing Formulas
• Creating Names Using the Name Box
• Using Names to Select Ranges
• Worksheet Functions
• Using IF with Text
• Using IF with Numbers
• Nesting IF Functions
• The VLOOKUP Function
• Counting Functions
• And more Functions
• Scoping a Formula
• Long-Hand Formulas
• Preparing for Complex Formulas
• Creating the Base Formula
• Adding More Operations
• And more Formulas
• Alternate Currencies
• Alternate Date Formats
• Formatting Clock Time & Calculated Time
• Understanding Number Formatting & Format Codes
• Understanding Conditional Formatting
• Formatting Cells Containing Values
• Clearing Conditional Formatting
• Top Ten Items
• Understanding Data Validation
• Number Range Validation
• Input & Error Messages
• Drop Down Lists
• Linking Between Worksheets
• Linking Between Workbooks
• Updating Links
• Using Names to Link
• Understanding Goal Seek
• Using Goal Seek
• Creating Tables
• Table Styles
• Inserting/Deleting Columns & Records
• Removing Duplicates
• Understanding Pivot Tables
• Recommended Pivot Tables
• Creating Your Own Pivot Table
• Defining Structure
• Adding Titles, Axis Titles, Legends
• Showing Data Labels & Gridlines
• Formatting Chart Area
• SUMIF Functions
• Special Pasting
• Find & Replace
• Financial Functions
• Grouping & Outlining
• Summarising & Subtotalling
• Chart Object Formatting
The above topics may include additional information and further insight depending
on the audience
John Wayne
7 Hrs + 3 Hrs Self Study
Intermediate
English