The Intermediate Excel Level
The intermediate level is the basic level plus more. The more here is defined by depth. The intermediate Microsoft Excel user, driven by what can be done with Excel functions learned in the basic level, delves into the tools in the FORMULA tab and the function library therein. S/he learns and knows how to use the function wizard to enter function arguments/inputs. The function wizard enables basic users to understand, through use and over time, two things: (1) The arguments/inputs that some difficult- to- comprehend functions require e.g Lookup functions and (2) The order at which arguments/inputs are entered.
The Intermediate Level is a level where more on TEXT Functions, DATE Functions, LOOKUP functions and MATH functions should be learned and used. Formula Auditing is also a group in the FORMULA Tab that should be learned and used in the Intermediate level of Excel usage. This prepares users for auditing more complex use of functions in formulas such as those found in complex/compound formulas – formulas that have two or more functions.
DCM's Intermediate Excel Course
Our course is designed for learners who have used Excel before and want to expand their knowledge, improving formatting, organising data, highlighting key information and creating formulas/links between sheets.
The course will introduce new concepts for sorting data, and building conditional formulae. If you think you know Excel, this course will show you what you've been missing. Learners will leave feeling a new confidence in their Excel expertise and ready to take on new challenges with data.
During the training session, each learner will work through exercises and practise using the various Excel features covered during the course.
Learning Outcomes
By the end of the session you will be able to:
- Quickly summarise multiple sheets of data into one
- Turn long lists and reports into easy to read tables
- Use formulas to check whether cells pass or fail your rules
- Create links between cells so that they all update automatically
- Highlight targets, trends, duplicates and errors with Conditional Formatting
- Use templates for consistent layouts and formatting
