Microsoft Office Productivity Specialists
Support, Training & Automation that . . .
Inspires * Saves time,
money & effort Entertains
Second Choice Date
Third Choice Date
An Overview of the the Excel Screen
Help! Not just Microsoft’s help - find “How-To’s” online
You’ve got to start somewhere. Creating a basic spreadsheet
Looking good! Formatting Cells
Formulae or formulas ? Whatever, this is how to calculate in Excel
Absolute Cell References. You’ll absolutely need to know this.
Calculating Percentages. 100% you’ll want to do this.
AutoFill. Save yourself typing-time!
Keeping it tidy: Managing workbooks and Worksheets
Printing & Page Setup. You don’t want to but you will need to print.
Charts: including how to get a chart with one key press!
A quick way to change your spreadsheet from portrait to landscape & back
Creating 3-D Formulas - formulae that look “through” into other sheet and workbooks
Working with Range Names - name your data, it makes spreadsheet life easier to understand
Using Lookup Functions - VLOOKUP, HLOOKUP (& others if you want them)
Using the IF Function - get Excel to take a decision for you
Using the IFERROR Function - trap errors in calculations. VERY useful function.
Using Date Functions
Using Databases in Excel - one of Excel’s top uses and very powerful they are too.
Sorting data - alphabetical, numerical, you name it, we can do it.
Filters - AutoFilter - one of our favourite Excel features. Powerful yet easy-to-use.
Using Subtotals on your data. Quickly see sub-totals for each department etc
Using Advanced Filters
Comments in spreadsheets.
Functions within functions (“Nesting”) - getting more complicated calculations done.
Data Validation: controlling data input. Create drop-down lists & warn about wrong
Conditional Formatting - colour-code data depending on its values.
Auditing your spreadsheet - error trapping.
Custom Views - you can create different views of your data & save them for later
Scenarios - look at data options and save them to view or present to colleagues.
Goal Seek - how do I get there from here? Goal Seek will help you.
Solver - what-if analysis. What if we sell a million but our costs go up? Solver
Pivot Tables. Analyse large amounts of data. Rotate (or “pivot”) the results around.
Using Pivot Table Slicers. Filter your Pivot Table results
Macros. Initially, a recording of repetitive actions, to save you time. Incredibly
Excel Keyboard Shortcuts. Get a chart with on key press. You’ll love shortcuts.
Other Topics (please list them)
Microsoft Excel Training