MS Excel Training Course with Microsoft Certificate

01/02/2016

MS Excel Training Course with Microsoft Certificate

 

Learn in easy to follow videos, exercises and assignments

In this program, learn exactly what you need to know including important skills like cell formatting, creating pivot tables, and writing what-if equations–plus explore how to visually represent data with charts and graphs, and even best practices for sharing your data on the web.

MS Excel Training Course with Microsoft Certificate includes:

  • 30 Videos with PDF
  • 26 Practice Exercises
  • 12 Data files and Assessments

Bonus: Online Access to Official Level 3 Course

ms-excell-course-image

Contents

  • Introduction
  • The Backstage View
  • Help System
  • Editing Workbooks and Worksheets
  • Entering Data in Worksheet
  • Introduction to Formulas
  • Using Math & Statistical Functions
  • Using Tables
  • Using Paste Special
  • Formatting Cells
  • Naming Cell Range
  • Using Find & Replace
  • Sorting & Filtering Data
  • Adding Comments
  • Auditing Formulas
  • Text & Date Functions
  • Using Cell References
  • Transposing Data and LookUp Functions
  • Creating,Editing & Formatting Charts
  • Adding Trendlines to Charts
  • Creating and Editing PivotTables
  • Creating Pivot Charts
  • Using Goal Seek
  • Using Scenario Manager
  • Recording and Using Macros
  • Printing Excel Files
  • Different File Formats
  • Grouping and Outlining Data
  • Linking and Protecting Worksheets

Each Section includes:

  • A set of videos that demonstrate the features
  • A comprehensive PDF document that serves as course book. You can download it and read offline at your own pace and use as a reference material.
  • A data file (workbook) for completing guided exercises
  • A practice session to help you better understand each concept
  • A self-assessment assignment to help you test yourself and improve the learning outcome. You also get the solution for the assignments for reference.
  • The course has a reference section (Section 15) which has a downloadable PDF file with commonly used short cuts, tips & tricks.
  • This program also includes access to official advanced program. It is an online program for which you will receive a key and instructions to download the program.

Why Should You Do This MS Excel Training Course with Microsoft Certificate:

  • Quality & Reliability – We are a Microsoft Learning Solutions Partner which means it has validated our capability to teach their products & Technology
  • Experienced Instructor – The instructor has over 15 years of experience in a variety of projects
  • Comprehensive Curriculum – Everything you need to know to become an expert
  • Lots of Practice – There is nothing like some real, hands on practice to sharpen your skills. This includes lots of solved assignments and exercises for you to practice.
  • Bonus – Access to official Level 3 program
  • Market Validation – Completion certificate from MS and Trainedge to validate your skills

CLICK on the link below for more details.

GetInstantAccessBlue

MS Excel Training Course with Microsoft Certificate

buy-it-now