Microsoft Excel - Beginner Excel 2013 Training

Course details

Based on one of our most successful Microsoft Excel 2010 course in Udemy, We have designed this course on Microsoft excel 2013 for you keeping in mind the feedback and suggestions from thousands of our Excel 2010 students. This course starts from scratch. So, even if you are a starter in Excel, you will get it in this course. This course is going to take 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. 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 course on Microsoft Excel 2013 Beginner:

 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