Excel Level 2

Essential skills


Overview

What does the course cover?

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.

Aims

Why take this course?

This course provides you with solid knowledge in the most important tools in Excel. Once you have finished the course you will know more than most people who are using Excel each day. You’ll have powerful skill-set that you can use in building spreadsheets that make you even more efficient in your role.

Audience

Who should attend?

If you work with Excel on a regular basis there is a huge amount to gain by being confident at this level. There are many features to learn and this course will save you hours and hours of work as you start to start make the most of the functionality of Excel.


Course preview

Each course contains high quality, professional, Live demo’s, Downloadable exercise files and Real-world templates for you to use.


Live demo’s

Downloadable files

Real-world templates

Course detail and sample lessons

Section 1: Sharing workbook with others

Lesson 1: Sharing workbook with others
Demo Not Available
Lesson 2: Save and Send options
View Demo
Lesson 3: Saving an excel file in a different file format
Demo Not Available
Lesson 4: Using Hyperlinks
View Demo

Section 2: Protecting and maintaining a workbook

Lesson 1: Protecting and maintaining a workbook
View Demo
Lesson 2: Customising advanced properties
View Demo
Lesson 3: Saving as a template
Demo Not Available
Lesson 4: Importing and Exporting XML data
Demo Not Available
Lesson 5: Protecting a worksheet and workbook
Demo Not Available

Section 3: Track Changes

Lesson 1: Track Changes
View Demo
Lesson 2: Turning on track changes
Demo Not Available
Lesson 3: Accept and Reject changes
Demo Not Available
Lesson 4: Sharing workbooks
Demo Not Available
Lesson 5: Restricting Access to a shared workbook
Demo Not Available

Section 4: Naming Cells

Lesson 1: Naming Cells
View Demo
Lesson 2: Naming a cell or a range of cells
Demo Not Available
Lesson 3: Moving to named cells
Demo Not Available
Lesson 4: To delete or edit a named cell
Demo Not Available

Section 5: Data lists

Lesson 1: Data lists
View Demo
Lesson 2: Adding cutsom lists
View Demo
Lesson 3: Advanced sort options
Demo Not Available
Lesson 4: Applying conditional Formatting
Demo Not Available
Lesson 5: Applying Filters
Demo Not Available
Lesson 6: Applying custom filters
Demo Not Available
Lesson 7: Subtotalling a list
Demo Not Available
Lesson 8: Grouping and outlining data
Demo Not Available
Lesson 9: Data validation
Demo Not Available
Lesson 10: Drop down menus using validation lists
Demo Not Available
Lesson 11: Creating a table to manage lists
Demo Not Available

Section 6: Advanced Formulae

Lesson 1: Advanced Formulae
View Demo
Lesson 2: V and H lookup Functions
View Demo
Lesson 3: SUMIF Function
Demo Not Available
Lesson 4: COUNTIF Function
Demo Not Available
Lesson 5: Arrays
Demo Not Available
Lesson 6: Database Functions
Demo Not Available

Section 7: Advanced Charts and Graphs

Lesson 1: Advanced Charts and Graphs
View Demo
Lesson 2: Trendlines
View Demo
Lesson 3: Dual Axes
Demo Not Available
Lesson 4: Saving a Chart Template
Demo Not Available
Lesson 5: Sparklines
Demo Not Available
Lesson 6: Advanced Sparklines options
Demo Not Available


Skills you’ll learn

What you’ll be able to do after the course

  • Save and export Excel into different formats
  • Protect workbooks and worksheets
  • Import and export XML and CSV files
  • Work with Vlookup and Hlookup functions
  • Filter and subtotal lists
  • Work with named cells and ranges
  • Use validation in a spreadsheet

How you can apply these skills

What you’ll be able to use these skills for

  • Perform data analysis
  • Lookup prices or products based on IDs or dates
  • Create advanced charts
  • Create charts with trend lines
  • Understand more complex spreadsheets
  • Use conditional formatting to highlight key data
  • Share workbooks with other users

Certification

When you pass the exam you will receive an internationally recognised accreditation certificate like this:

Excel_Core_Certificate


What’s next?

Upon completion, you can move onto Excel Level 3. After you have completed the 3 levels you will be ready to take the Expert and Specialist courses in Excel for advanced Certification and for preparation for the Microsoft Certification exams.


Careers that require these skills at this level?

Excel is used in practically every business and in nearly all departments in those businesses – ranging from sales to accounting and administration. Any office role will require you to be proficient to this level.


Want to start learning today?

Joining is simple, easy and risk free with our 7 day money back guarantee.