Jayne Wilkins & Associates Training Courses In Kent In London

01303 268357

jayne@jaynewilkins.co.uk

Microsoft Excel Courses - Modular

Microsoft Excel Courses

Microsoft Excel Modular Courses

Our one day Excel Introductory, Intermediate and Advanced courses are extremely popular. But your staff may not always want too, or need too, attend a full day course. Time is often short and there may be a need to concentrate on a particular set of features.  The Excel workshops listed below take the form of 1, 1.5 and 2 hour modular sessions with 15 minutes between each. Staff can then return to their desk and immediately put into action what they have learned.

From: £POA
Level: Modular
Duration: Various

Excel 1 - Formatting & Printing Worksheets

Duration 1 hour - Introductory Level

  • Clearing Formats Only
  • Formatting Cells: Numbers, Dates & Text Formats
  • Borders & Shading
  • Formatting with Styles
  • Using Table Formats
  • Printing a Worksheet: Fitting to Page, Page Layout View, Headers & Footers
  • Using Page Break Preview
  • Printing an Area of the Worksheet


Excel 2 - Data Entry & Basic Formulae

Duration 2 hours - Introductory Level

  • Entering Text, Values and Date
  • Using AutoFill to copy contents and formats
  • Automatically enter a sequence of dates and/or numbers
  • Building Formulae, Add, Subtract, Multiply & Divide
  • Adding up using the Sum Function
  • Using the Min, Max, Average, & Count Funtions
  • Excel's order of calculation
  • Absolutely & Relative cell referencing (using the $ in a formula)


Excel 3 - Working with Charts

Duration 1.5 hours - Intermediate Level

  • Creating & Editing Charts
  • Working with Colours, Gridlines, Legends & Titles
  • Adding Text
  • Adding more data to a chart
  • Placing data on a secondary axis
  • Removing data from the chart
  • Adding data from more than one sheet
  • Moving a Chart, Copy a Chart from Excel to Word
  • Changing the Default Chart Type


Excel 4 - Multiple Worksheets v Workbooks

Duration 1 hour - Intermediate Level

  • Copying, Deleting, Moving & Naming Sheets
  • Building a Formula across sheets
  • Using Group Mode
  • Building a linking formula across workbooks
  • Editing links
  • Saving a Workspace


Excel 5 - Database/List Management

Duration 1 hour - Intermediate Level

  • Principles of an Excel List
  • Freezing Panes
  • Sorting & Filtering a List
  • Producing Subtotals
  • Formatting as a Table
  • Entering Data in the Table
  • Adding Totals to the Table
  • Filtering in the Table

Excel 6 - Pivot Tables

Duration 2 hours - Advanced Level

  • Preparing data for a PivotTable
  • Creating a PivotTable
  • Using the Row, Column, Values and Report Filter positions
  • Adding Data to a PivotTable
  • Filtering Fields/Using Slicers
  • Grouping Dates
  • Custom Groups
  • Drilldown to check source values
  • PivotTable Charts
  • Creating Multiple PivotTables
  • PivotTable Calculations
  • Using Functions
  • Using ‘Show Data As’
  • Adding a calculated field
  • Using a field multiple times
  • Creating a PivotTable from Multiple data sources


Excel 7 - Advanced Functions

Duration 2 hours - Advanced Level

  • Range Names and Table Names
  • Using IF to enter data into cells based on the result of a test
  • Nesting IF’s, using AND & OR
  • COUNTIF(S), SUMIF(S), AVERAGEIF(S
  • ISBLANK, ISERROR, IFERROR, NOT
  • Using VLOOKUP & HLOOKUP
  • VLOOKUP & MATCH used together
  • Text Functions: UPPER, LOWER, PROPER, LEN, CONCATENATE, TRIM
  • Using Flash Fill (From Excel 2013)
  • Date Functions: TODAY, NOW, WEEKDAY, YEARFRAC, NETWORKDAY


Excel 8 - Working with Large Worksheets

Duration 1 hour - Advanced Level

  • Freezing & Splitting Panes
  • Creating Outlines
  • Working with large worksheets
  • Collapsing rows and columns
  • Creating Charts from collapsed data
  • Creating Custom Views
  • Saving views within the workbook


Excel 9 - Writing Macros

Duration 1.5 hours - Level Advanced

  • What is a Macro/VBA
  • Recording a Macro
  • Playing a Macro
  • Saving Macros in a Workbook
  • Saving Macros in the Personal Macro Workbook
  • Macro Security
  • Absolute & Relative Macros
  • Editing Macros
  • Adding a Macro to the Quick Access Toolbar
  • Playing a Macro from a button in the worksheet
  • Playing a Macro with a keystroke
  • Editing a macro in the Visual Basic Window