Professional certificate on MS Excel-2013
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.
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
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