Tutorialspoint

Excel Intermediate

Get the best out of the most common and useful features in Microsoft Excel

Description

You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf.  You will also see how you can create create superb visualisations using charts and maps.  The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.

Outline is below:

  • Conditional formatting
  • Average function/Count
  • Maximum function/Sum
  • Minimum function/SumIF
  • Basic Scenarios
  • Sheet Layout and design
  • Named Cells/Ranges
  • Absolute Referencing/ percentages
  • Basic Pivot Tables
  • Using 3-D Referencing
  • Goal Seek
  • Data Tables
  • Sheet and cell Protection
  • Linking Sheets and Workbooks
  • Using Array Formulae
  • Using Group and Outline/Saving Views
  • Naming Worksheets
  • Using the Subtotals Feature
  • Creating Templates
  • Basic Lookups/Basic IF

Goals

  • Understand how to automate Microsoft Excel using formulae and functions
  • Use engaging and dynamic charts and graphs
  • Understand how Data Analysis tools work
  • Understand how Pivot tables work and how to use them
  • Use database tools, Outline and Subtotals

Prerequisites

  • It is advisable to complete the Excel Introduction course before attempting this course. If you have used Excel for some time, this course is suitable. The course is not dependent on the Introduction course as it is a standalone course.  
Show More

Curriculum

Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Tutorialspoint
Feedbacks
  • No Feedbacks Posted Yet..!
Excel Intermediate
This Course Includes
  • 6 hours
  • 39 Lectures
  • 12 Resources
  • Completion Certificate
  • Lifetime Access
  • 30-Days Money Back Guarantee

Sample Certificate

Use your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

We have 30 Million registgered users and counting who have advanced their careers with us.

X

Sample Certificate