Type and hit enter to Search
×

Intermediate Microsoft Excel 2016

  • 4.8(45,582 Rating)

Course Overview

In this hands-on course, you will learn how to create informative, eye-catching charts and graphs, and harness the power of Excel’s data analysis tools and AutoFilter commands. In addition, you will find out how easy it is to create macros that let you manipulate data with the push of a button. You will also discover how to use Goal Seek and Solver and apply them to real-world problems. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other time-saving functions to your repertoire.

Course Outcome

  • Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016
  • Learn to create useful and eye-catching charts
  • Discover how to manipulate data with the push of a button
  • Add the time-saving functions of advanced Excel users to your repertoire

Prerequisites:

There are no prerequisites to take this course.

Target Audiance

  • Office Managers: Office managers seeking to enhance their data management and analysis skills for better efficiency.
  • Data Analysts: Data analysts aiming to deepen their Excel proficiency for more advanced data manipulation and visualization.
  • Financial Analysts: Financial analysts looking to streamline financial modeling and reporting tasks.
  • Human Resource Professionals: HR professionals wanting to improve their ability to organize and analyze employee data.

Schedule Dates

Intermediate Microsoft Excel 2016
15 July 2024
Intermediate Microsoft Excel 2016
15 October 2024
Intermediate Microsoft Excel 2016
15 January 2025
Intermediate Microsoft Excel 2016
15 April 2025

Course Content

  • Using Named Ranges in Formulas
  • Naming a Single Cell
  • Naming a Range of Cells
  • Naming Multiple Single Cells Quickly
  • Using Formulas That Span Multiple Worksheets
  • Using the IF Function
  • Using AND/OR Functions
  • Using the SUMIF, AVERAGEIF, and COUNTIF Functions
  • Using the PMT Function
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • Using the CONCATENATE Function
  • Using the TRANSPOSE Function
  • Using the PROPER, UPPER, and LOWER Functions
  • The UPPER Function
  • The LOWER function
  • The TRIM Function
  • Using the LEFT, RIGHT, and MID Functions
  • The MID Function
  • Using Date Functions
  • Using the NOW and TODAY Functions
  • Creating Scenarios
  • Utilize the Watch Window
  • Consolidate Data
  • Enable Iterative Calculations
  • What-If Analyses
  • Use the Scenario Manager
  • Use Financial Functions

  • Converting a List to a Table
  • Removing Duplicates from a List
  • Sorting Data in a List
  • Filtering Data in a List
  • Adding Subtotals to a List
  • Grouping and Ungrouping Data in a List

  • Working with Clip Art
  • Using Shapes
  • Working with SmartArt

  • Creating a Custom Chart Template
  • Inserting Charts
  • Add and Format Objects
  • Insert a Text Box
  • Create a Custom Chart Template

  • Format Data as a Table
  • Move between Tables and Ranges
  • Modify Tables
  • Define Titles

  • Applying Conditional Formatting
  • Working with Styles
  • Creating and Modifying Templates

  • New Functions in Excel 2013
  • Using New Chart Tools
  • Using the Quick Analysis Tool
  • Using the Chart Recommendation Feature

  • New Charts
  • Treemap
  • Sunburst
  • Histogram
  • Waterfall
  • Box and Whisker
  • Pareto

FAQs

Participants should have a basic understanding of Microsoft Excel, including knowledge of fundamental operations like creating and editing worksheets, basic formulas, and formatting cells.

The course covers advanced functions and formulas, data analysis tools, PivotTables and PivotCharts, conditional formatting, data validation, and advanced charting techniques.

The course is delivered through a combination of lectures, hands-on exercises, and practical projects. This blended approach ensures that participants can apply what they’ve learned in real-world scenarios.

Yes, the Intermediate Microsoft Excel 2016 course covers many of the skills and knowledge areas tested in the MOS certification for Excel 2016.

It depends on the training provider. Some providers supply computers equipped with the necessary software, while others may require you to bring your own laptop with Excel 2016 installed.

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?