Excel 2013 – Level 2

Essential skills


Overview

What does the course cover?

This course builds on the Excel 2013 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 would benefit?

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 make the most of the functionality of Excel 2013.


Course preview

Each course contains high quality, professional, Video lessons, Downloadable exercise files and Real-world templates for you to use.

Excel 2013 Level 2 - Intro
Simple interface
Excel 2013 Level 2 - Demo
Video lessons
Excel 2013 Level 2 - Download
Downloadable files

Course detail and sample lessons

Section 1: Advanced Formatting

Lesson 1: Introduction
Demo Not Available
Lesson 2: Custom Formats
Demo Not Available
Lesson 3: Conditional Formatting
Demo Not Available
Lesson 4: Custom Lists
Demo Not Available
Lesson 5: Custom Views
Demo Not Available
Lesson 6: Freeze Panes
Demo Not Available

Section 2: Charts

Lesson 1: Introduction
Demo Not Available
Lesson 2: Insert & Delete A Chart
Demo Not Available
Lesson 3: Inserting A Chart For Selected Data Only
Demo Not Available
Lesson 4: Chart Elements
Demo Not Available
Lesson 5: Chart Styles
Demo Not Available
Lesson 6: Chart Filters
Demo Not Available
Lesson 7: The Chart Design Tab
Demo Not Available
Lesson 8: The Chart Format Tab
Demo Not Available

Section 3: Sparklines

Lesson 1: Introduction
Demo Not Available
Lesson 2: Insert A Sparkline
Demo Not Available
Lesson 3: Edit A Sparkline
Demo Not Available
Lesson 4: Changing The Sparkline Type
Demo Not Available
Lesson 5: Deleting A Sparkline
Demo Not Available

Section 4: Pivot Tables And Charts

Lesson 1: Introduction
Demo Not Available
Lesson 2: What Is A Pivot Table
Demo Not Available
Lesson 3: Importance Of The Table Format
Demo Not Available
Lesson 4: Inserting A Pivot Table
Demo Not Available
Lesson 5: Using A Recommended Pivot Table
Demo Not Available
Lesson 6: Pivot Table Options
Demo Not Available
Lesson 7: Refreshing A Pivot Table
Demo Not Available
Lesson 8: Pivot Table Design
Demo Not Available
Lesson 9: Drill Down Options
Demo Not Available
Lesson 10: Calculations
Demo Not Available
Lesson 11: Pivot Charts
Demo Not Available
Lesson 12: Filters And Slicers
Demo Not Available
Lesson 13: Timelines
Demo Not Available

Section 5: Advanced Formula

Lesson 1: Introduction
Demo Not Available
Lesson 2: COUNTIF And SUMIF
Demo Not Available
Lesson 3: SUMIFS And COUNTIFS
Demo Not Available
Lesson 4: If Statements
Demo Not Available
Lesson 5: The VLOOKUP
Demo Not Available
Lesson 6: Absolute And Relative Referencing
Demo Not Available
Lesson 7: Named Ranges
Demo Not Available
Lesson 8: Formula Auditing
Demo Not Available

Section 6: Data Tools

Lesson 1: Introduction
Demo Not Available
Lesson 2: Flash Fill And Strings
Demo Not Available
Lesson 3: Data Validation
Demo Not Available
Lesson 4: Consolidation
Demo Not Available
Lesson 5: Goal Seek
Demo Not Available
Lesson 6: Scenarios
Demo Not Available
Lesson 7: The Data Table
Demo Not Available

Section 7: Advanced Reviewing

Lesson 1: Introduction
Demo Not Available
Lesson 2: Sheet Protection
Demo Not Available
Lesson 3: Workbook Protection
Demo Not Available
Lesson 4: Tracking Changes
Demo Not Available
Lesson 5: Switch And Arrange Workbooks
Demo Not Available

Section 8: Macros

Lesson 1: Introduction
Demo Not Available
Lesson 2: Record And Save A Macro
Demo Not Available
Lesson 3: Running A Macro
Demo Not Available
Lesson 4: Assigning A Macro To A Button Or An Icon
Demo Not Available
Lesson 5: Absolute And Relative Referencing In Macros
Demo Not Available
Lesson 6: Storing The Macro In The Personal Macro Workbook
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:

IACT_Specialist


What’s next?

After you have completed the two 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.