Excel Module 3
The aim of this session is to provide the Excel user with a more in-depth knowledge of the software and to open up possibilities for its use. We can provide a pre training assessment of current users to determine their current level of knowledge.
Please note that existing users are invited to bring to the session any files which are or have been problematic and our trainer will be happy to have a look and advise.
Review of the Basics
SUMIF / SUMIFS / COUNTIF / COUNTIFS
IF Statements / IF AND OR Statements / Nested If Statements
SUMPRODUCT / VLOOKUP / HLOOKUP
In Linked Files / Using with Named Ranges
Date & Time Calculations
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
Text to Columns / Fixed Width Entries / Delimited
Sorting a Table / Sort Keys / Sorting Left to Right
Using AutoFilter / Advanced Filter
Creating and Editing / Pivot Table Formula / Slicers / Charts / Reports.
Validation Rules / Creating Drop down lists
Pivot Table Drop Down Menu / Pivot Table Formula
Calculations in Pivot Tables
Introduction to Hyperlinks
QUESTIONS & ANSWERS
Special Features and Facilities
The course is devoted to a practical use of the software and is therefore primarily hands-on. An absolute maximum of 1 student per machine will be maintained. The session is fully documented, and each person attending will have unlimited access to our after training Help Desk.
Existing users are invited to bring questions, problematic spreadsheets, and also to ask for design advice on upcoming projects.
This specification can be tailored for onsite training sessions