Prajith
Basic ExcelConcepts - 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- All About Pivot Tables - Read about my new book! - 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- Table Structures: Good and Not So Good- Synchronize 2 Pivot Tables with a Combo Box- Tie a Chart to a Pivot Table All About Multiple Consolidation RangesPivot Table Based Conditional ChartAdd Dynamic Icons to Pivot Table Reports All About Charts - Formatting Charts- Combo Charts and Formatting Data Points- Create Dynamic Chart Labels- Create a Histogram Chart- Create a Basic Water Fall Chart- Using the Bar to Pie Chart- Add Average Line to a Chart- Invert Negatives in a Chart- Get Graphical without Charts?- Create a Scrolling Chart (Offset Function)- Create a Basic Speedometer Chart- Create a Thermometer Effect in you Column Charts Quick and Easy Organizational Chart Creating a Delta Chart Creating a Benchmark Chart Advanced Excel Functions - Alternate Shading with Conditional Formatting- VLOOKUP formulas made easy- Matrix Lookup Formula (Index and Match)- Cell Information Functions- Text and String Functions- Formula to Convert Trailing Minus Signs- Using IF(AND()) & IF(OR())- Increase Available Undo Actions- Using the SumProduct() Function- Using the COUNTIF() to Find Duplicates- Set Duplicates Warning with Data Validation- Basics of Nested Formulas- Conditional Sums and Array Formulas- Formula to convert your dates to quarters Using the SUBTOTALS Function Sort by Color without an Add-in Turn a Row Oriented Dataset into a Column Oriented Dataset Dynamic Ranges Finally Explained Sort by Capitalization Building Excel Applications - 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 Fun Spreadsheet that does Magic Tricks Getting Started with VBA - Quick overview of VBA- Understanding Reference Libraries Declaring Variables- Using If Statements- Using Select Case Statements- The Basics of the Do Loops- Using For Next Loops- Looping with For Each Statements
Basic ExcelConcepts
- 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-
All About 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- Table Structures: Good and Not So Good- Synchronize 2 Pivot Tables with a Combo Box- Tie a Chart to a Pivot Table All About Multiple Consolidation RangesPivot Table Based Conditional ChartAdd Dynamic Icons to Pivot Table Reports
All About Charts
- Formatting Charts- Combo Charts and Formatting Data Points- Create Dynamic Chart Labels- Create a Histogram Chart- Create a Basic Water Fall Chart- Using the Bar to Pie Chart- Add Average Line to a Chart- Invert Negatives in a Chart- Get Graphical without Charts?- Create a Scrolling Chart (Offset Function)- Create a Basic Speedometer Chart- Create a Thermometer Effect in you Column Charts Quick and Easy Organizational Chart Creating a Delta Chart Creating a Benchmark Chart
Advanced Excel Functions
- Alternate Shading with Conditional Formatting- VLOOKUP formulas made easy- Matrix Lookup Formula (Index and Match)- Cell Information Functions- Text and String Functions- Formula to Convert Trailing Minus Signs- Using IF(AND()) & IF(OR())- Increase Available Undo Actions- Using the SumProduct() Function- Using the COUNTIF() to Find Duplicates- Set Duplicates Warning with Data Validation- Basics of Nested Formulas- Conditional Sums and Array Formulas- Formula to convert your dates to quarters Using the SUBTOTALS Function Sort by Color without an Add-in Turn a Row Oriented Dataset into a Column Oriented Dataset Dynamic Ranges Finally Explained Sort by Capitalization
Building Excel Applications
- 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 Fun Spreadsheet that does Magic Tricks
Getting Started with VBA
- Quick overview of VBA- Understanding Reference Libraries Declaring Variables- Using If Statements- Using Select Case Statements- The Basics of the Do Loops- Using For Next Loops- Looping with For Each Statements
Number of Visits
