Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course builds on the Excel Level 1 foundations course to teach you how to use the essential tools in Excel. You’ll learn V and H lookup, CountIf and SumIf and database functions. You’ll work with charts, graphs, filters and lists, import different file formats (like XML data) and track changes in a spreadsheet.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Sharing workbooks with others|
This section includes the exercise files for Excel Level 2. Please download these before you start the course.
Save and Send optionsPreview
Using Comments In ExcelPreview
|Section 2: Protecting and maintaining a workbook|
Customising advanced propertiesPreview
Saving as a template
Importing and Exporting XML data
Protecting a worksheet and workbook
|Section 3: Track changes|
Turning on track changesPreview
Accept and Reject changes
Restricting Access to a shared workbook
|Section 4: Naming Cells|
Naming a cell or a range of cellsPreview
Moving to named cells
To delete or edit a named cell
|Section 5: Data lists|
Adding cutsom listsPreview
Advanced sort options
Applying conditional Formatting
Applying custom filters
Subtotalling a list
Grouping and outlining data
Drop down menus using validation lists
Creating a table to manage lists
|Section 6: Advanced Formulae|
V and H lookup FunctionsPreview
|Section 7: Advanced Charts and Graphs|
Saving a Chart Template
Advanced Sparklines options
Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.
Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.