Advance Excel Master's Program

·         Identifying the different Excel

·         Identifying new features of Excel

·         Working with the ribbon

·         Customizing the Excel program window

·         Zooming in on a worksheet

·         Arranging multiple workbook windows

·         Adding buttons to the Quick Access Toolbar

·         Customizing the ribbon

·         Maximizing usable space in the program window

·         Modifying workbooks

·         Modifying worksheets

·         Inserting rows, columns, and cells

·         Merging and unmerging cells

·         Entering and revising data

·         Managing data by using Flash Fill

·         Moving data within a workbook

·         Finding and replacing data

·         Correcting and expanding upon worksheet data

·         Defining Excel tables

·         Naming groups of data

·         Creating formulas to calculate values

·         Summarizing data that meets specific conditions

·         Working with iterative calculation options

·         Working with automatic workbook calculation

·         Using array formulas

·          Finding and correcting errors in calculations

·         Formatting cells

·         Defining styles

·         Applying workbook themes and Excel table styles

·         Making numbers easier to read

·         Changing the appearance of data based on its value

·         Adding images to worksheets

·         Limiting data that appears on your screen

·         Filtering Excel table data by using slicers

·         Manipulating worksheet data

·         Selecting list rows at random

·         Summarizing worksheets by using hidden and filtered rows

·         Finding unique values within a data set

·         Defining valid sets of values for ranges of cells

·         Sorting worksheet data

·         Sorting data by using custom lists

·         Organizing data into levels

·         Looking up information in a worksheet

·         Using workbooks as templates for other workbooks

·         Linking to data in other worksheets and workbooks

·         Consolidating multiple sets of data into a single workbook

·         Examining data by using the Quick Analysis Lens

·         Defining an alternative data set

·         Defining multiple alternative data sets

·         Analyzing data by using data tables

·         Varying your data to get a specific result by using Goal Seek

·         Finding optimal solutions by using Solver

·         Analyzing data by using descriptive statistics

·         Creating charts

·         Customizing the appearance of charts

·         Finding trends in your data

·         Creating dual-axis charts

·         Summarizing your data by using sparklines

·         Creating diagrams by using SmartArt

·         Creating shapes and mathematical equations

·         Analyzing data dynamically by using PivotTables

·         Filtering, showing, and hiding PivotTable data

·         Editing PivotTables

·         Formatting PivotTables

·         Creating PivotTables from external data

·         Creating dynamic charts by using Pivot Charts

·         Adding headers and footers to printed pages

·         Preparing worksheets for printing

·         Previewing worksheets before printing

·         Changing page breaks in a worksheet

·         Changing the page printing order for worksheets

·         Printing worksheets

·         Printing parts of worksheets

·         Printing charts 

·         Linking to Office documents from workbooks

·         Embedding workbooks into other Office documents

·         Creating hyperlinks

·         Pasting charts into other Office documents

·         Sharing workbooks

·         Saving workbooks for electronic distribution

·         Managing comments

·         Tracking and managing colleagues’ changes

·         Protecting workbooks and worksheets

·         Authenticating workbooks

·         Saving workbooks as web content

·         Importing and exporting XML data

·         Working with SkyDrive and Excel Web App

VBA stands for Visual Basic for Applications, an event-driven programming language from Microsoft. It is now predominantly used with Microsoft Office applications such as MSExcel, MS-Word and MS-Access. This tutorial teaches the basics of VBA. Each of the sections contain related topics with simple and useful examples.

·         Introducing Visual Basic for Application

·         Displaying the Developer Tab in the Ribbon

·         Recording a Macro

·         Saving a Macro-Enable Workbook

·         Running a Macro

·         Editing a macro in the Visual Basic Editor

·         Understanding the Development Environment

·         Using Visual Basic Help

·         Closing the Visual Basic Editor

·         Understanding Macro Security

·         Understanding Modules

·         Creating a Standard Module

·         Understanding Procedures

·         Creating a Sub Procedure

·         Calling Procedure

·         Using the Immediate Window to Call Procedures

·         Creating a Functions Procedure

·         Naming Procedures

·         Working with the code Editor            

·         Understanding Objects

·         Navigating the Excel Object Hierarchy

·         Understanding Collections

·         Using the Object Browser

·         Working with Properties

·         Using the With Statement

·         Working with Methods

·         Creating an Event Procedure

·         Understanding Expressions and Statements

·         Declaring Variables

·         Understanding Data Types

·         Working with Variables Scope

·         Using Intrinsic Functions

·         Understanding Constants

·         Using Interinsic Constants

·         Using Message Boxes

·         Using Input Boxes

·         Declaring and Using Object Variables

·         Understanding Control-of-Flow Structures

·         Working with Boolean Expressions

·         Using the If... End If Decision Structures

·         Using the Select Case... End Select Structure

·         Using the Do....Loop Structure

·         Using the For...To...Next Structure

·         Using the For Each....Next Structure

·         Guidelines for use of control-of-Flow Structure

·         Understanding User Forms

·         Using the Toolbox

·         Working with User Form Properties, Events and Methods

·         Understanding Controls

·         Setting Control Properties in the Properties Windows

·         Working with the Label Control

·         Working with the Text Box Control

·         Working with Command Button Control

·         Working with Combo Box Control

·         Working with Combo Box Control

·         Working with Frame Control

·         Working with Options Control

·         Working with Control Appearance

·         Setting the Tab Order

·         Populating a Control

·         Adding Code to Control

·         Understanding PivotTables

·         Creating a PivotTable Using Worksheets Data

·         Working with PivotTable Objects

·         Working with the PivotTable Collection

·         Assigning a Macro to the Quick Access Toolbar

·         Debugging Code

·         Understanding Errors

·         Using Debugging Tools

·         Setting BreakPoints

·         Stepping through Code

·         Using break Mode during Run mode

·         Determining the Value of Expressions

·         Handling Errors

·         Understanding Error Handling

·         Understanding BA’s Error Trapping Options

·         Trapping Error with the On Error Statement

·         Understanding the Err Object

·         Writing an error-Handling Routing

This Excel  Course is ideal for any business user or student or beginners as well as advanced users who wish to maximize their productivity using Microsoft Excel.

·         Lecture 21: Microsoft business intelligence vision

·         Business intelligence in three ways

·         Tabular business intelligence semantic model

·         Excel 2013 professional power tools

·         Best things that PowerPivot brings to excel

·         What will PowerPivot do for the analyst?

·         New 2013 PowerPivot features

·         PowerPivot and excel 2013

·         PowerPivot and SharePoint

·         Importing data

·         Data models

·         Relationships

·         Simple pivot table reports

·         Calculated columns and calculated fields

·         Refreshing data

·         Calculations

·         DAX

·         Microsoft power view user interface

·         Tables

·         Tiles

·         Charts

·         Multiples

·         Saving and sharing

·         Demonstration 

·         Power query and power query formulas

·         Ribbon

·         Data import

·         Data filtering

·         Merging datasets

·         What is power map?

·         Power map ribbon

·         Data preparation

·         Tours and scenes

·         Preparation

·         Scenario