ms-excel-certybox

MS Excel Training

MS Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.

Enrolment validity: Lifetime

About This Course

MS Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of developing these training modules, we have used Microsoft Excel version 2016.

Learning Objectives

Master Microsoft Excel from Beginner to Advanced
Build a solid understanding on the Basics of Microsoft Excel
Learn the most common Excel functions used in the Office
Learn automating tasks through Macros and VBA
Maintain large sets of Excel data in a list or table
Create dynamic reports by mastering one of the most popular tools, PivotTables
Learn dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Target Audience

  • From beginners, to advanced users, this course is perfect for all ability levels

Curriculum

134 Lessons15h

Getting started with Excel

Create and Open Workbooks
Excel 2016 Interface
Enter Data in a Worksheet
Moving Data in Excel 2016
Deleting and Hiding Excel Data
Managing Excel Worksheets
Modify Excel Document Properties
Saving a Workbook in Excel
Saving to External Locations
Exporting Excel Data
Practical Exercise

Formatting Data

Data Presentation Strategies

Formulas and Functions

Charts, Tables, and Images

Customizing Views, Styles, and Templates

Custom Visual Effects

Working with Data

Macros and Advanced Queries

PivotTables and Advanced Charts

Power Pivot, Custom Formatting, Fills, and Forms

Working With Data In 3D Maps

Accessibility, Transforming Data, and Errors

Share, Review, & Collaborate

certificate

14,999.00

Level
All Levels
Duration 15 hours
Lectures
134 lectures
Language
English

Material Includes

  • Online, Self Paced Learning
  • Lifetime Access
  • Flexible Learning Program
  • Extensive Content for Self-Learning
  • Practice Quizzes
  • Course Completion Certificate