Aston Recruitment and Training offer well resourced apprenticeships, learning programmes and courses. Which include Engineering, Sales, marketing, health, hairdressing and a whole host of others . Whether its short or long term development Aston can help

Microsoft Excel Course (6-7 hours)
Level 1 (Foundation – Minimal PC User)
  •  The Ribbon toolbar, Mini Toolbar, Menu Tabs

  •  Quick Access Toolbar

  •  New Views / Key Tips

  •  Live Preview

  •  New File Format (Including PDF)

  •  The Backstage View (The File Tab – Saving / Opening files / Print etc.)

  •  Excel basics

  •  Working with formulae

  •  Autosum function

  •  Average function

  •  Automatically filling a range

  •  Move and copy cell entries

  •  Insert new rows and columns into a worksheet

  •  Formatting cells

  •  Number Formatting

  •  New Table Formats

  •  Add a border and shading to a worksheet

  •  Change the page setup and preview a worksheet

  •  New Print Layout View – Headers and footers

Microsoft Excel Course (6-7 hours)
Level 2 (Intermediate – Regular PC User)
  •  Recap from earlier course

  •  Quick Access Toolbar

  •  Work with absolute cell references

  •  Using a percentage Formula

  •  Brackets in Formulas (order of operation)

  •  More functions (e.g. COUNTA, COUNTIF)

  •  Enter a formula to link related worksheets

  •  Create links between workbooks

  •  Hiding rows and columns

  •  Sort database records

  •  Filter database records

  •  Use the subtotal feature

  •  Controlling the screen

  •  Conditional formatting

  •  Charts

Microsoft Excel Course (6-7 hours)
Level 3 (Advanced / Dependant PC User)
  •  Customisation of Excel

  •  Advanced Formulas

  •  Define a range name

  •  Advanced functions (IF, VLOOKUP, SUMIF,)

  •  Nested Functions (Auto comparison of data)

  •  Lookup tables (find and match data)

  •  Workbook Management Tools

  •  Create and display a view

  •  Picture editing tools

  •  Protecting a workbook

  •  Protecting part of a workbook

  •  Data Validation

  •  Create a Pivot table (electronic reports)

  •  Macros (Auto command sequences)

Excel (L4) Macros and Introduction to Visual Basic with Aston

Visual Basic is engineered for productively building type-safe and object-oriented applications. Visual Basic enables developers to target Windows, Web, and mobile devices. As with all languages targeting the Microsoft .NET Framework, programs written in Visual Basic benefit from security and language interoperability.

Target audience:          Experienced users of Excel who have attended Excel level 3 training

Duration                          1 Day

Objectives                       For users wishing to automate Excel procedures by writing macros and gain a rudimentary understanding of Visual Basic.

Course content:

  • Recording Macros and Running Macros

Editing a macro

Avoiding errors

Worksheet buttons

Toolbar buttons

  • General Macros

Global macros using the Personal Macro Workbook

Absolute v Relative cell Addressing

  • More Complex Macros

Using the VB Toolbar

Debugging macros using Step

Introduction to common VB statements

  • Repetitive Tasks within Macros

Making decisions (IF)

Loops

Ending a macro

learning with Aston

We use cookies on our site by continuing to browse our site, you agree to the use of these cookies.
You can read our cookie policy and learn more here