Microsoft Excel

icon5

SOFTWARE: Microsoft Excel 2013

DURATION: 1 Session per level (8 hours per session)

Offered in Beginner, Intermediate and Advanced level. Learn how to analyse, share and manage information to make more informed decisions with the world’s premier spreadsheet application. Take your Excel skills to the next level!

BEGINNER LEVEL

Areas of training:

  • Getting Started with Excel
  • Excel Selection Techniques
  • Manipulating rows and columns
  • Manipulating cells and cell content
  • Sorting a Cell Range
  • Excel Worksheets
  • Freezing Row and Column Titles within Excel
  • Font, Number and Alignment Formatting within Excel
  • Excel Formulas
  • Functions and Chart
  • Customising Excel

INTERMEDIATE LEVEL

Areas of training:

  • Excel Setup and Viewing Options
  • Excel Functions and Formulas
  • Excel Time and Date Functions
  • Excel Mathematical, Logical and Statistical Functions
  • Excel Financial, Lookup, and Database Functions
  • Excel Named Ranges
  • Excel Cell and Range Formatting
  • Advanced Worksheet Manipulation within Excel
  • Excel Templates
  • Paste Special Options within Excel
  • Proofing and Printing

ADVANCED LEVEL

Areas of training:

  • Excel Pivot and Input Tables
  • Excel Charts and Hyperlinks
  • Linking within Excel
  • Embedding within Excel
  • Importing Text Files into Excel
  • Sorting, Filtering and Totalling Data within Excel
  • Tracking and Reviewing Changes in Excel
  • Excel Scenarios
  • Validating within Excel
  • Auditing Techniques in Excel
  • Macros within Excel
  • Excel Passwords and Security Issues

DURING THE PROGRAM:

Hands-on practical training

Customised for specific industry needs

Training facilities and materials provided

Experienced Excel trainers

Online forum for on-going support

Certificate provided upon completion