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

Excel Introduction:

Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.

Course Outline Excel Introduction 1 Day

Who is it for?

The course is suitable for those with little or no prior knowledge of Microsoft Excel and focuses on the basics of creating spreadsheets including entering and editing data, formatting spreadsheets, basic formulae, functions and charts.

Prerequisites

Delegates should have a basic knowledge of computers and working in a Windows environment.

Excel Introduction:

Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.

Course Outline Excel Introduction 1 Day

Who is it for?

The course is suitable for those with little or no prior knowledge of Microsoft Excel and focuses on the basics of creating spreadsheets including entering and editing data, formatting spreadsheets, basic formulae, functions and charts.

Prerequisites

Delegates should have a basic knowledge of computers and working in a Windows environment.

WORKBOOK CREATION

A first look at Microsoft Excel:

  • Understanding the Screen layout
  • Opening, Closing & Saving data

EDITING FEATURES

Working with Sheets:

  • Enter & Edit Data
  • Insert and delete columns and rows
  • Cut/Copy & Paste
  • Page setup
  • Printing
  • autofill

FORMATTING

Formatting Text and Numbers:

  • Font Formatting
  • Borders and Shading
  • Number Formatting

CALCULATIONS

Formulae and Functions:

  • Basic calculations
  • Order of Precedence
  • Functions
  • Absolute Referencing

CHARTING

Creating and Editing Charts:

  • Basic Charting
  • Formatting Charts

Excel Intermediate:

This course is quite heavy formula based introducing Ifs, vlookups and linking data between sheets, also you will look at working with large amounts of data helping to sort, filer and hide data.

Course Outline
Excel Intermediate 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel and focuses on working with large spreadsheets, manipulating data, using more advanced formulae and functions and advanced charting techniques.

Prerequisites

Delegates should have a basic knowledge of the Introduction outline.

FORMULAE/
FUNCTIONS

An in-depth look into:

  • IF’s and Lookup Functions
  • Worksheet/Workbook Linking
  • Calculating with Dates
  • Subtotals

DATA MANIPULATION

Controlling data using:

  • Dynamic Ranges
  • Auto Filtering
  • Grouping and Outlining
  • Freeze Panes Sorting Data
  • Working with Comments

RANGES

Manipulating Worksheets using:

  • Named Ranges
  • Conditional Formatting
  • Hiding/Un-hiding Data
  • Password Protecting Worksheets
  • Protecting Specific Cells
  • Changing Default Options

ADVANCED CHARTING

Building on basic Charting using:

  • Combining Multi-Chart Types
  • Custom Chart Formats
  • Creating Secondary Axis

Excel Advanced:

Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.

Course Outline
Excel Advanced 1 Day

Who is it for?

The course is suitable for existing users of Microsoft Excel wanting to further their knowledge – this course covers automating spreadsheets and using advanced data handling techniques.

Prerequisites

Delegates should have a good knowledge of the Introduction and Intermediate outline.

ADVANCED FUNCTIONS

An in-depth look into:

  • Nesting IF’s
  • And/Or Functions
  • Array Formulas
  • Text Functions
  • Database Functions
  • New formulas; XLOOKUP, Filter, Sort and Unique (O365 only)

PIVOT TABLES

Pivot Tables and Pivot Charts:

  • Creating and Editing Tables & Charts
  • Refreshing Data
  • Displaying Pages
  • Slicers

TEMPLATES & EDITING

Templates & Advanced Editing Techniques:

  • Creating & Editing Templates
  • Deleting Templates
  • Paste Special & Paste Link
  • Data Validation
  • Custom Views
  • Shared workbooks

SPREADSHEET AUTOMATION

Working with Macros:

  • Creating & Naming Macros
  • Absolute and Relative Macros
  • Creating Macro Buttons
  • The VBA screen
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