February 13, 2020 from 10:00 am to 4:00 pm
Please Note: This course requires a basic knowledge of Windows and a PC laptop/ mouse with Excel 2016 or newer installed – we do have a few laptops that can be hired for use during the course but should be arranged in advance.
Excel Level 2 delegates will go “Beyond The Basics” to learn about formula syntax, creating charts, formatting tables, and using new functions and features that are beyond the absolute beginner level and well into higher productivity levels overall!
The aim of this Excel intermediate training course is to build on the knowledge gained through the use of Excel (self-taught users) or users who have completed the Introduction Course Excel Level 1: The Fundamentals
To avoid booking a course that is either too hard or too easy, too fast or too slow, we ask that you take a quick 24-question multiple choice assessment of your current level of Excel knowledge to ensure that all delegates are on the right course and moving at the same pace:
Delegates will be taken from the introductory basics to making more of the productive and effective features of Excel. Managing data and processing department information will ascend to a whole new level.
Delegates will come away with:
- Review of Excel fundamentals
- Working with Worksheets
- Using Formulas in Excel
- Use the Excel ‘Functions’ (SUM, MIN MAX, AVERAGE, COUNT, COUNTA)
- Understanding formula syntax
- Understanding and using ‘arguments’ in functions
- Using brackets in formulas
- Correcting errors in Formulas
- Relative and Absolute Cell References
- Using Auto-sum and Auto-calculate
- Creating effective Data Lists (Tables)
- Formatting Tables and ranges
- Format painter
- Sorting of data tables
- Printing options – set print area
- Introduction to Charts
The bold items above are critical concepts to grasp and once delegates have completed this course, they will be ready for the Excel Level 3: Power Users course where we will address many of the higher-level features that Excel has to offer.
Delegates are required to bring a PC laptop with Excel 2016 installed – if delegates do not have one, then we do offer a few laptops for hire at £20 per day on a first-come first-served basis.
Does this course date/time/location not work for your organisation? We’re flexible, contact us to bring the training directly to your facility through in-house or bespoke training. Call us for a quote or to book a training time, date, or location that is most convenient to you!