1 Day Excel For Executives Click to print this pagePrint
You are here: / Home / Courses / Course Categories / Excel Courses / 1 Day Excel For Executives

Introduction
 This application driven 1-day programme leads delegates through selected advanced Excel functions and procedures, explaining the function or procedure and their uses.

This is a very hands-on, non-intimidating, course - delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with the nuances of Excel's advanced functions.

To The Top

Who Should Attend
  • All executives using Excel spreadsheets
  • All executives who receive spreadsheets and wish to validate or manipulate same
  • All executives involved in the construction and use of spreadsheets and financial models, including budgets, projections, evaluations, cash flows, projects, etc.
To The Top

Pre Requisite(S)
  • Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise).

    Excel knowledge required:
  • Basic & Intermediate Excel skills, including:
    1. Moving around the spreadsheet & workbook
    2. Inserting & deleting rows and columns
    3. Inserting text & formulas
    4. Copying formulas
    5. Formatting cells
    6. Basic Formula structure
    7. Making cell addresses absolute
To The Top

Outcomes
 By the end of the course delegates will recognize areas where they could improve their own spread sheeting. They will be in a position to immediately apply the lessons learnt to their own spreadsheets in their own environment.

To The Top

Course Content
 Amongst other things the delegates will learn:
  1. 30 useful tips
  2. Customising toolbars
  3. Data tables -creating one and two input tables
  4. Databases - extracting, filtering, searching, sorting - DB Functions
  5. Dates - formatting dates, time and date functions
  6. Drilling down and hyperlinking
  7. Formatting cells - numbers, dates, copying, custom formatting, comments
  8. Formulas- auditing, copying, displaying, locating, making absolute, naming
  9. Functions - the function wizard, locating, identifying, using Ctrl key
  10. Goalseeking
  11. Grouping and Outlining - collapsing rows and columns
  12. Identifying input cells, formula cells, value cells
  13. If statements, and multiple (nested) "if" statements, sumif and countif
  14. Importing text files - text to columns, text import wizard
  15. ISError and ISNumber functions
  16. Linking - cells, worksheets, workbooks
  17. Lookup, Hlookup,Vlookup, Match, Index
  18. Lookups - Looking up and extracting data from tables
  19. Macros - recording, running and assigning buttons and icons
  20. Masks and their uses
  21. Multi sheet workbooks - navigating, summing through sheets
  22. Naming cells, ranges and formulas
  23. Protection - files, worksheets, workbooks, hiding formulas
  24. Reviewing spreadsheets - identifying input and formulas
  25. Scenarios - creating and managing, producing summaries
  26. Sensitivity Analysis - sensitivity factors, tables - using Goalseek
  27. Sheets - copying, deleting, moving, naming, hiding, unhiding
  28. Uses of the CTRL key
  29. Views - creating custom views
  30. Viewing worksheets - freezing panes, viewing two sheets/books simultaneously
  31. Watch Window
  32. Working with strings (words) - dynamic descriptions
To The Top