useful Links
About
contact us
- 01604 230 371
- [email protected]
-
Aston Recruitment & Training
47-49 Gold Street Northampton
NN1 1RA
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
Work effectively with Excel learning shortcuts, quick and clever ways to enter data saving time. Understand and create basic formulas and charts.
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.
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:
EDITING FEATURES
Working with Sheets:
FORMATTING
Formatting Text and Numbers:
CALCULATIONS
Formulae and Functions:
CHARTING
Creating and Editing Charts:
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.
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.
Delegates should have a basic knowledge of the Introduction outline.
FORMULAE/
FUNCTIONS
An in-depth look into:
DATA MANIPULATION
Controlling data using:
RANGES
Manipulating Worksheets using:
ADVANCED CHARTING
Building on basic Charting using:
Analyse data using Pivot Tables, Automate repetitive task with Macros and build on existing formula knowledge with Nested ifs and Text manipulation formulae.
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.
Delegates should have a good knowledge of the Introduction and Intermediate outline.
ADVANCED FUNCTIONS
An in-depth look into:
PIVOT TABLES
Pivot Tables and Pivot Charts:
TEMPLATES & EDITING
Templates & Advanced Editing Techniques:
SPREADSHEET AUTOMATION
Working with Macros:
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