EXCEL

• Fundamentals
• Formula and Functions
• Data Analysis
• Forecasting

Excel Fundamentals

¨      The Excel Workspace

¨      Creation and saving of workbooks

¨      Opening, closing and switching between multiple workbooks

¨      Navigating in a workbook

¨      Worksheets: insert, delete, rename, move and copy

¨      Selecting Cells

¨      Entering/deleting/editing data in cells

¨      Undo and Redo

¨      Columns & Rows: width and height; inserting and deleting

¨      Moving and copying data; using AutoFill

¨      Creating formulae to calculate values

¨      Using the AutoSum function

¨      Formatting: font, size, colour, borders, font styles, effects, number formats

¨      Formatting: aligning, merging and wrapping text in cells; changing text orientation

¨      Sorting data alphabetically, numerically and chronologically

¨      AutoFilter – show specific data from a larger list

¨      Preparing for Print

Back to Top

Formula and Functions

¨      Creating formulae to calculate values

¨      Theory: the order of precedence that Excel uses in calculations

¨      Copying formulae using relative and absolute references

¨      Using the AutoSum key/Sum function

¨      Using Excel functions: Average, Max and Min

¨      IF functions

¨      VLOOKUP / HLOOKUP functions

¨      Naming cells and ranges

¨      Linking spreadsheets and workbooks

¨      Cell protection

¨      Functions and features to combine data from multiple cells / splitting data into multiple cells

Back to Top

Data Analysis

¨      Create, format and modify Charts
¨      Link charts to other applications (Word or PowerPoint)
¨      Hide columns, rows and formulae
¨      Apply formatting to numeric data depending upon values
¨      Use data validation to restrict the type of data entered in a specific area within a spreadsheet
¨      Use a Data Form to enter, delete and search for records
¨      Use Subtotals to flexibly show totals and averages of sections of data
¨      Use Advanced Filters to condense a large list of data
¨      Create and modify Pivot Tables:- grouping, showing/hiding data, adding subtotals, consolidating multiple ranges

Back to Top

Forecasting

     ¨    What-if analysis using one- and two- variable tables
¨    Forecast, Growth, and Trend functions
¨    Goal Seeking
¨    Moving Averages
¨    Regression Analysis
¨    Scenarios
¨    Solver
¨    Goal Seek
¨    Using Trend lines in Charts

Back to Top