Return to course list

Excel

Excel is used by over 7,500,000 worldwide and is frequently updated with remarkable features.

Feel free to pick and choose from any of these topics or let us help you decide, based on what you’d like to achieve.

Beginners

If you’re a new Excel user, we’d suggest the following, at a minimum, over two sessions:

• What’s on the screen
• The Quick Access Toolbar
• File commands
• Entering text, numbers, and dates
• Formulas – addition, subtraction, multiplication, division, calculate an average
• Moving around and selecting
• Editing
• Copying and cutting
• Formatting – numbers, dates, font formatting, alignment, borders
• Page setup
• Printing

Likely duration: 6 hours^*

Enhancements

• Filling data
• Freezing titles
• Sorting
• Filtering
• Formula Referencing and Defined Names

Likely duration: 1.5 hours^*

Next Step

• Copying and moving worksheets
• Goto Special
• Linking worksheets and workbooks
• Grouping
• Data consolidation
• Charts
• Functions
  • Counting
  • Rounding
  • Date and Time
  • Text functions

Likely duration: 6 hours^*

Advanced

• Functions
  • Lookup
  • Logical
  • Information
• Conditional Formatting
• Goal Seek
• Protecting data
• Subtotals
• Outlining
• Comparing two workbooks

Likely duration: 6 hours^*

• Pivot Tables

Likely duration: 1.5 hours^*

^*Duration will depend on previous knowledge and aptitude, and whether other topics are also covered