Microsoft Excel: Intermediate  (Level 2)

This one-day course is designed to:  Help a delegate to develop skills in using Microsoft Excel as a spreadsheet tool.  A delegate will learn to manage and link together multiple worksheets, create charts (graphs), apply more advanced formatting & work with databases.

Duration: 1 Day
Who should attend? Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheets to solve accounting and data analysis tasks.
Course Prerequisite: Microsoft Excel: Introduction

Course Outline

  • Databases
  • Creating a Database
  • Naming a Database
  • Working with Table
  • Advantages of using Tables
  • Sorting a Database
  • Multiple Sorts
  • Sort in a Special Order
  • Sort by Custom Lists
  • Using Filters
  • Types of Filters
  • Using Custom Filters
  • Understanding the And/Or
  • Turning the Filter Off
  • Advanced Filter
  • Filter Unique Records
  • Remove Duplicates
  • Highlight Duplicates
  • Relative & Absolute References
  • Text Functions
  • Concatenate Function
  • Date & Time Functions
  • Linking – Copy & Paste Link
  • Create Links to Different Worksheets
  • Create Links to Different Workbooks
  • Using the Edit Links to Open Source Files, Change Source Files, Breaking
  • Links to Source Files
  • Create Picture Links
  • Create Links between Excel & Word
  • Consolidate
  • Reports & Subtotals
  • Nested Subtotals
  • Outlining a Worksheet
  • Controlling Worksheet Display
  • Splitting of Panes
  • Freezing Panes
  • Validating Data
  • Separate Text into Columns
  • Transpose a Range
  • Copy a Sheet to the same Workbook
  • Copy a sheet between Workbooks
  • Moving Sheets
  • Working with Comments
  • Sheet Protection with a password
  • Workbook Protection with a password
  • Charting: Creating Charts, Sizing & Moving Charts, Modifying Charts,
  • Changing Chart Types
  • Adding & Deleting Data
  • Inserting Chart Titles
  • Data Labels
  • Change the Legend
  • Line Charts
  • Creating Charts with a Secondary Axis
  • Creating Picture Charts
  • Create a Shape
  • Modify & Align Shapes
  • Insert a Picture
  • Format Pictures
  • Comprehensive Manual
  • Lunch & Refreshments (not applicable to on-site training)
  • Electronic Certificate (on successful completion of the course)
  • Electronic Trainer Feedback Report
  • Electronic Delegate Feedback Questionnaire

Download Information

Click on the button to download

Course Schedule

View the available course dates

Contact Us

Contact Us now to find out more…