Duration: a 1-day course for people with some knowledge of using Microsoft Excel.
The Microsoft Excel User Training Course course aims to provide people already familiar with Microsoft Excel with a more in-depth knowledge of the programme than they currently have. Building on basic Excel skills, it will give users a thorough grounding of the features that make Excel the most popular spreadsheet software available. By the end of the training, users will be familiar with all of the key functions including formulas and macros.
Review of the Basics
SUMIF / SUMIFS / COUNTIF / COUNTIFS
IF Statements / IF AND OR Statements / Nested If Statements
SUMPRODUCT / VLOOKUP / HLOOKUP / INDEX / ARRAYS
In Linked Files / Using with Named Ranges
Date & Time Calculations
Using Named Ranges in Formula
Goal Seek / the Scenario Manager
Data Cleansing / Creating Uniformity
TRIM /UPPER / LOWER / PROPER / CONCATENATE
LEFT / RIGHT / MID / LEN
Working with Multiple Sheets / 3D Data Entry
Changing the Tab names / Inserting / Deleting / Rearranging Worksheets
Linking the Sheets / 3D Data Entry / 3D Formula
Using Multiple Windows / Linked Files
Link and Pasting to other Applications
Working with External Data Sources
Introduction to MSQuery
Text to Columns / Fixed Width Entries / Delimited
Sorting a Table / Sort Keys / Sorting Left to Right
External Links and Connections
Using AutoFilter / Advanced Filter / Process Automation
Creating and Editing / Pivot Table Formula / Slicers / Charts / Reports.
Validation Rules / Creating Drop down lists
Pivot Table Drop Down Menu / Pivot Table Formula
Introduction to Hyperlinks
Introduction to Macros
Macro Recorder / Macro Button / Embedded Button
Adding to the Ribbon
Viewing the VB Code
QUESTIONS & ANSWERS
Venues and Delivery:
We offer this course on a regular basis at our training venue in at The Travelodge, Cumbernauld- located on the A80 Cumbernauld Road, 10 minutes north of Glasgow, as well as offering in-house or bespoke training for HR departments or companies.
Please visit our IT training course schedule page to find out when our Excel User training is running.
To book this course, please complete our on-line booking form or contact us on 01236 733898 or