Excel Tutorials (Video Guide)

CA CS CIMA Prakash Somani (Landmark Group) (23502 Points)

17 July 2009  

Excel Basics

Using "Paste Special"

Using Text to Columns

Tips on Filtering with "AutoFilter"

Using Goal Seek

Data Validation in Excel

About Conditional Formatting

Basics of Protecting a Worksheet

Basics of Using Subtotals

Basics of Print Setup Options

Formatting Tricks

Grouping Tabs to Save Time

Conditional Format with Four Conditions

Adding Tool Tips to Cells

 

Pivot Tables

Create a Basic Pivot Table

Sorting in a Pivot Table

Create a Drill Down Effect with a Pivot Table

Adding a Calculated Field in a Pivot Table

Grouping in a Pivot Table

Creating Pivot Charts

Using Pivot Table Advanced Options

Convert Pivot Tables Into Hard Data

Synchronize 2 Pivot Tables with a Combo Box

Tie a Chart to a Pivot Table

All About Multiple Consolidation Ranges

Pivot Table Based Conditional Chart

Add Dynamic Icons to Pivot Table Reports

Pivot Tables and Spreadsheet Bloat 

 

Excel Charting Techniques

Combo Charts and Formatting Data Points

Create Dynamic Chart Labels

Create a Histogram Chart

Using the Bar to Pie Chart

Add Average Line to a Chart

Invert Negatives in a Chart

Create a Scrolling Chart (With Dynamic Ranges)

Create a Basic Speedometer Chart

Create a Thermometer Effect in you Column Charts

Creating a Delta Chart

Creating a Benchmark Chart

Use Excel Charts in PowerPoint Without Bloat

Creating Bullet Graphs in Excel

 

Excel Functions Explained

Matrix Lookup Formula (Index and Match)

Cell Information Functions

Text and String Functions

Formula to Convert Trailing Minus Signs

Using IF(AND()) & IF(OR()


Using the SumProduct() Function

Basics of Nested Formulas

Conditional Sums and Array Formulas


Using the SUBTOTALS Function

Dynamic Ranges Finally Explained

 

Excel Tips and Tricks

Increase Available Undo Actions

Using the COUNTIF() to Find Duplicates

Set Duplicates Warning with Data Validation

Formula to convert your dates to quarters

Sort by Color without an Add-in

Turn a Row Oriented Dataset into a Column Oriented Dataset

Sort by Capitalization

 

Using Excel Macros

All About Recording Macros

Cleaning up your Macro generated VBA

Using Spreadsheet Form Controls

Using Macros to create a user interface

Send Emails with SENDEMAIL method

Create your First User Form (Create a Splash Screen)

Calling up Excel Dialog Boxes

Force Users to Enable Macros