Microsoft Excel Training For Your Team
Excel is one of the most widely used software packages currently in use. The package can be used for a variety of tasks. On a basic level, you can use Excel for creating tables, storing data and setting up simple calculations like addition, multiplication, division or subtraction.
For more demanding uses, Excel can be used to create charts, automate spreadsheets, apply advanced formulas, create Pivot tables and much much more!
Please select the version that you’re interested in
Please select the level that you’re interested in
Microsoft Excel Intermediate Training Course
Course Overview
- Use Logical Functions – IF, AND, OR, Nested IF
- Financial functions - PMT, FV, PV
- Statistical Functions – COUNTIF, COUNTIFS
- Nest Functions
- Multiple Worksheet Management and Formulae
- Create Charts
- Protect Worksheets & Workbooks
Audience:
This course is designed for users who have basic knowledge of Excel and want to further enhance their skills. It covers more complex formulae, including 3D formulae, linking data and charting your data and protecting worksheets and workbooks.
Prerequisite:
To get the most from this course, you must be able to perform basic Excel actions and create basic formulae and functions.
Duration:
This is a 1-day Excel Intermediate Course. The course starts at 09:30 and runs until 16:30.
Alternate timings can be arranged upon request. The course can be held on a date that suits you.
Location:
Our Microsoft Excel Intermediate course course can be delivered virtually using online training platforms such as MS Teams or Zoom or face-to-face at any preferred location in the UK, Europe or ROW.
Excel Intermediate Course Outline
RECAPPING BASICSAbsolute, Relative References Basic calculations BODMAS Inserting and deleting sheets Changing the default number of Tracing Precedence and Show Formula NAMING CELL RANGESConcept and Purpose Naming Individual Cells Naming Range of Cells Deleting and amending Using Name Ranges in Formulae Named Ranges for Navigation LINKING SHEETS AND FILESChanging the default number of 3D Calculations Linking sheets in the same file Linking different Excel files Using Edit Links VIEWING OPTIONSViewing Different Files Window Split Freeze Panes Viewing Different Parts Watch Window CONDITIONAL AND LOOKUP FUNCTIONSBenefits and Purpose IF Statements Nested IF’s SUMIF, SUMIFS, AVERAGEIF, ISERROR and IFERROR | Nesting IF with AND, OR Basic VLOOKUP FINANCIAL FUNCTIONS PMT, FV, PV CONDITIONAL FORMATTINGData Bars Colour Scales Icon Sets Top/Bottom Clearing Conditional formatting Editing existing Conditional Formatting SHARE THE WORKBOOKShare the workbook to enable co-author – multiple people working simultaneously ESSENTIAL LIST MANAGEMENTSorting Data (by Values, by Multi Column Sort Advanced Filter Adding Subtotals Freeze Panes Group and Outline Data Form Format as Table Feature Data Consolidation FORMULAE AUDITINGTracing Precedence and Using Watch Window Go To Special… ADVANCED CHARTS TECHNIQUESCreating Chart using Shortcut Saving Custom Chart as Setting Chart as Default Formatting and Editing Series, Using Sparklines (Line, Column, |
One to One
(which includes a tailor-made training programme for the individual where they can mix and match the topics from various levels to get the most cost-effective training
Group for up to 8 learners
What Our Clients Say
Extras
This is a sample of some of the Short training videos. Please note that you can get access to many more, once you have done a course with us and are registered as one of our delegates.