info@h2htraining.co.uk

 

Head2Head Training

BACK


Tel: 01494 558988

Fax: 01494 464904

EXCEL WORD ACCESS POWERPOINT
VISIO FRONTPAGE PROJECT OUTLOOK

EXCEL

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