Chauster logo te360
Thumb teched360 ms excel training

Microsoft Excel

Microsoft is the standard in spreadsheet.  It lays out your data so you can organize your numeric or text data in spreadsheets or workbooks. Viewing it in context helps you make more informed decisions. Our training program teaches you the most basic to the most advance functions of Excel.  Students will learn about calculations and how to modify and format a worksheet. They will also learn how to customize the Excel environment and how to manage and print workbooks.This course builds on your exsisting skills.

Students will also learn about creating formulas, inserting graphics and enhancing workbooks. They will also learn how to organize worksheet data with tables and charts and how to analyze data using PivotTables, Slicers and PivotCharts.  In our Advance modules students will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. They will learn about data validation and database functions such as DSUM. They will learn how to work with PivotTables and PivotCharts, how to import and export data, and how to query external databases. In addition to all that, students will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.

 

Microsoft Excel Course Curriculum

Module 1

  • Lesson 01 - Getting Started with Microsoft Excel 2013
  • Lesson 02 - Performing Calculations
  • Lesson 03 - Modifying a Worksheet
  • Lesson 04 - Formatting a Worksheet
  • Lesson 05 - Printing Workbook Contents
  • Lesson 06 - Managing Large Workbooks
  • Lesson 07 - Customizing the Excel Environment
     

Module 2

  • Lesson 01 - Creating Advanced Formulas
  • Lesson 02 - Analyzing Data with Logical and Lookup Functions
  • Lesson 03 - Organizing Worksheet Data with Tables
  • Lesson 04 - Visualizing Data with Charts
  • Lesson 05 - Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Lesson 06 - Inserting Graphics
  • Lesson 07 - Enhancing Workbooks
     

Module 3

  • Lesson 01 - Creating Advanced Formulas
  • Lesson 02 - Analyzing Data with Logical and Lookup Functions
  • Lesson 03 - Organizing Worksheet Data with Tables
  • Lesson 04 - Visualizing Data with Charts
  • Lesson 05 - Analyzing Data with PivotTables, Slicers, and PivotCharts
  • Lesson 06 - Inserting Graphics
  • Lesson 07 - Enhancing Workbook

Our Excel program is designed to help you use Excel to analyze data on any level. Whether you're just learning how to create spreadsheets or need to perform advanced data analysis with functions, formulas, and charts, these courses will help you unlock the maximum potential of this popular data-analysis program.

Program Components

  • Microsoft Excel Training Program
  • Expert Lectures and Demonstrations
  • Fully Loaded Courseware

 

OUR PROGRAM NOW COMES LOADED ON

Premium

Standard

iStudy App