Professional certificate on MS Excel-2013

Course Descriptions

Microsoft Excel has more than 750 Million users worldwide. It’s an electronic spreadsheet and considered as most essential application in Microsoft Office package. The application provides an outstanding combination of functions and tools for working with quantitative data analyzing, reporting and decision making.Scientist or Business Manager! Wherever you grow your career. You need Excel. It will give you job, make you essential at your job and bring you tremendous career success.

If you are a new comer in Excel or after all these years of random use of Excel you want to start back learning Excel systematically, this course is for you. This is a 16 Hours course that will build you the skills and level of confidence you need to succeed in your career.

Microsoft Excel has numerous functions, tools and options for wide range of users. Topics of this course are of advanced nature. All the topics have real life practical application and may help users to enhance productivity and work quality.

Learning Outcomes

At the end of this course, you will be able to:

  • Explore Excel Options and Apply Protections ;
  • Write Functions and Formulas using Names;
  • Apply Lookup and Reference Functions;
  • Use Advanced Data Tools;
  • Conduct What-if-Analysis and Prepare Risk Analysis Reports;
  • Explore & Apply Pivot Table, Charts and Dynamic Reporting;
  • Design Macros and Run Automation;
  • Apply Microsoft Power BI (Business Intelligence) Tools
Learning Methodology

Practical Demonstration, Group Discussion and Case Studies.

We will follow a simple, quick and easy method for learning. We will spend almost no time in discussing theories until it is extremely essential. Each module will have an intro session followed by practical examples for understanding the need and importance of the function or tools that you will learn. After that, we go for practical video demonstration followed by exercise session. You will get a sample Excel works for most of the sessions.

Training Sessions and Content

Hour 1 – Introduction

Introduction to Microsoft Excel 2013 Tabs, Ribbons and Commands Accessing Commands with Keyboards Backstage File Management


Hour 2 – Options & Customization

Excel Options Quick Access, Toolbar Menu Customization


Hour 3 – Data and Numbers

Data Entry Basics and Tips Clipboard, Font and Alignment Number and Styles Cells and Editing


Hour 4 – Looks and Prints

Themes, Colours, Fonts and Effects Margin, Orientation and Page Size Scale-to-fit and Shit Options Printing Workbooks.


Hour 5 – Number Basics

Introduction to Quantitative Analysis Arithmetic Fractions and Decimal Percentages and Ratios


Hour 6 -Algebra, Equations and Formulae

Introductory Definitions Algebraic Notations Solving Equations Formulae


Hour 7 – Basic Business Applications

Currency & Exchange Rates Discounts and Commission Simple and Compound rates Pay and Taxation


Hour 8 – Excel Functions and Formulas

Defined Names Formula Auditing Calculation and Formula Protection


Hour 9 – Data Management

Sorting and Filtering Data Tools Outline External Data


Hour 10 – Essential Functions

Function Library Introduction to Statistics Statistical Functions Date and Time Functions


Hour 11 – Advanced Functions

Introduction to Database Vlookup Function Match Function Index Function


Hour 12 – Advanced Functions II

IF Nested IF IF with and IF with OR


Hour 13 – Data Presentation

Charts and Sparkline Pivot Table Pivot Charts


Hour 14 – Macros

Creating Macros Editing Macro Codes


Hour 15 – Controls

Combo Box and List Box Spin Button and Scroll Bar Check Box, Options and Group


Hour 16 – User Defined Functions

Modules in VB Creating Functions Saving Functions as Add-ins



Cases Example Files Practical Problem Solution