Level 2: Intermediate Microsoft Excel
Take your Excel skills to a new level as you build on the basics and begin to master this powerful application
This fun and interactive course builds on your basic Excel skills and teaches you to really take control of this flexible software. During the day, you'll use a variety of techniques to analyse and present data, control spreadsheet access by users, and look up information from Excel databases. Discussing real business situations, you'll understand how various techniques can be employed to save time and improve data quality.
This course will give you a solid understanding of Excel formulas, and their myriad applications in business situations. However, rather than just learning lists of functions, you'll learn how to think like Excel and use builtin tools to create any formula you need. Using simulated business exercises and reallife examples, you'll see how Excel can fit into all areas of a business to make things easier, quicker and more efficient.
Who should attend?
Competent Excel users who want to move away from the basics and really take advantage of the software's business possibilities.
"Really great course; made a dry subject very interesting and enjoyable." - Michael Dean, Informa Telecoms & Media, London, UK
Key topics
Relative and absolute references
Working with data
Controlling data quality
Lookup functions
Conditional functions
Showing trends on charts
Displaying data in pivot tables
Workbook security
Why take this course with us?
At Naturally Spreadsheets, we understand the gulf that exists between basic Excel usage and effective Excel usage. Making the jump from displaying data clearly through figures and charts, to actually analysing data and performing effective calculations can be one of the hardest things to achieve. We take the pain out of this important step by working with you to understand Excel's capabilities and relating these to existing knowledge.
When you attend this course, you will leave with a rock-solid understanding of what Excel is really capable of, why various techniques should be employed, and how to achieve amazing results with some of Excel's key formulas.
Classroom training courses from Naturally Spreadsheets...
Excel Classroom Level 1: Introduction to Microsoft Excel
In this first step, you'll look at how Excel can be used in a business environment, and understand how to apply its functionality in your role. Click here for the full course outline.
Excel Classroom Level 2: Intermediate Excel
This course builds on your basic knowledge to help you use Excel's built-in helpers to create and use any formula, as well as using data validation, nested formulas and pivot tables. Click here for the full course outline.
Excel Classroom Level 3: Advanced Microsoft Excel
In this advanced Excel course, you'll use hands-on learning to tackle the most demanding data types using formulas such as INDIRECT, INDEX, MATCH and SUMPRODUCT, as well as some of Excel's most useful advanced tools. Click here for the full course outline.
Live E-learning training courses from Naturally Spreadsheets...
Excel Live E-learning Level 1: The Basics
In this first step, you'll look at how Excel can be used in a business environment, and understand how to apply its functionality in your role. Click here for the full course outline.
Excel Live E-learning Level 2: Using Formulas
This course builds on your basic knowledge to help you use Excel's built-in helpers to create and use any formula. Click here for the full course outline.
Excel Live E-learning Level 3: Working With Data
In this highly interactive module, you'll trace the journey of data from beginning to end, from controlling the quality of data as it enters Excel, manipulating and tidying data within the software, and displaying it in the most effective way for different data types and uses. Click here for the full course outline.
Excel Live E-learning Level 4: Advanced Data
In this advanced data course, you'll go beyond VLOOKUP to learn how Excel's advanced lookup functions can tame the most complex data sets and reporting requirements. Click here for the full course outline.
Excel Live E-learning: Presenting Excel in PowerPoint
In this interactive course, you'll learn how to use Excel and PowerPoint's tools in combination to create slides which engage the audience to get your message across Click here for the full course outline.