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

 

Extras

Cases Example Files Practical Problem Solution