Microsoft Excel 2013 Course - Online Excel Basic & Advanced

Course details

This course starts from scratch. So, even if you are a starter in Excel 2013, you will get it in this course. By the completion of this Comprehensive Microsoft Excel 2013 training, you will be comfortable with most of the powerful features and functions of Excel 2013. Working files are included, allowing you to follow along with the author throughout the lessons.

This course begins with taking care of all excel functions and formulas in a comprehensive manner with lots of examples and case studies. To make you understand the importance of Excel in our day to day life, the course starts with a case study and how that case study is being taken completely on an excel spread sheet. You will learn everything from data entry to calculations to formula, formatting, if, sumif, graphs and charts, sorts, pivot table, freeze and split etc. We will also give you lots of shortcuts in excel to make your life easier. Then, the course will take you through some of the most useful functions of Excel 2013, gradually takes you through prominent features like What if Analysis, Arrays, Functions for Working with Text, Pivot Table. Important functions like Pivot Table has been taken comprehensively for better understanding. We will also be covering other smart features like Charts and Graphs, Dashboard and Financial Functions in this course.

This course is ideal for Students, MBA's, BBA's, Gradates & Post- graduates, Working Professionals from HR, Marketing, Sales and Operation etc., Entrepreneurs, Prospective Finance Analyst, Market Analyst, Research Analyst, Investment Banker. There is no Pre-requisite to this course. A complete beginner can start with this course. Our objective with this course is to make you understand what excel is and to know its importance in the current business world. The only requirement from you is to be passionate to learn, be committed to the training and invest your time.

We will be covering the following modules in this online course on Comprehensive Microsoft Excel 2013.

 Overview

 Getting Started

 Case Study

 Data Entry

 Calculations

 Formulas

 Formatting

 Formatting Table formats

 Updating a Calculation

 Percentages & Absolute References

 Conditional Formatting

 IF Function

 COUNTIF

 SUMIF

 Graphs & Charts

 Pie Chart

 Sorts

 Filter Function

 Pivot table

 Freeze & Split

 Presentation

 Print

 Shortcuts

 Common errors

 What If Analysis

 Arrays

 Functions for Working with Text

 Excel 2013 - Pivot Table

 Summarizing Data Using Pivot Table

 Data Filtering

 Basics Pivot Table Formatting

 Advanced Pivot Table Formatting

 Introduction of Pivot Chart

 How to Print the Pivot Table

 Using Macros In Pivot Tables

 Introduction of Power Pivot

 DAX in Power Pivot

 Introduction of Power View

 Names and Dynamic Range

 Auditing and Trouble Shooting Formulas

 Important Excel Tools

 Excel 2013 - Charts & Graphs

 Chart Concept

 Basic Chart

 Fine Tuning of Charts

 Chart Options

 Format Tab

 Adjustment of Specific Chart Types

 Changing Chart Sources

 Specialised Charts & Graphs

 Excel 2013 - Excel Dashboard

 Creating Basic Charts

 Learning Pivot Table, Pivot Chart and Slicer

 Using Form Controls

 Basic Macros

 Assigning Macros to Buttons to Navigate and Dashboard

 Financial functions using Excel

 Future Value, SI, CI, PV, NPER, RATE