Microsoft Excel Introduction
Spreadsheets Made Easy

Overview

One of the hardest problems users face in Excel is Percentages (Finding, Adding and Deducting). Stage 2 shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively.
In addition, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today, Median, Mode and Absolute Cell Referencing. Delegate’s confidence will quickly grow allowing them to start learning filtering and subtotal functions.

Course Outline

  • Screen Layout (Terminology/Toolbars/Shortcut /Cursors/ Navigation)
  • Formatting (Open/ Close/ Saving/ Text/ Columns & Rows/ Borders)
  • Editing (Planning, Autofil / Copy / Cut / Paste, Hiding & Showing Columns / Creating & Amending Spreadsheets / Paste Special & Paste Link)
  • Printing ( Selection / Entire Workbook / Worksheet / Page Setup)
  • Basic Graphs (Creating & Amending Bar / Area / Pie / 3D – more advanced options)
  • Basic Formulas ( Sum / Basic Percentages / Dates / Averages)
  • Settings (Tools – Customise / Tools – Options / Custom Lists)
  • Linking Spreadsheets (Basic Linking / Paste Link & Special)
  • Formulas (+ – ÷ × / More on Percentages / Absolute Cell Referencing (using $ symbols) / VAT )
  • Data Sorting (Basic Sorting / AutoFilter / Splitting & Freezing panes / Subtotals)