Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Excel with Top Microsoft Excel Hacks

Video Introducing this tutorial

Course Introduction :
A Quick Introduction and Welcome
Download this Exercise File


Microsoft Excel Hacks 101 :
Hack 01 - Linking Text Boxes to Worksheet Cells
Hack 02 - Effectively Deleting Empty Rows in a Data Set
Hack 03 - Quickly Fill Blank Cells with a Value
Hack 04 - The Secret Excel Camera Tool
Hack 05 - Quickly Navigating Between Excel Worksheets
Hack 06 - Quickly Navigating Between Excel Workbooks
Hack 07 - Jump Quickly to Formulas
Hack 08 - Adding an Average Line to Chart
Hack 09 - Opening the Excel Clipboard
Hack 10 - Creating Custom AutoFill Lists


New Excel Hacks March 2016 :
Hack 11 - Status Bar Calculations
Hack 12 - Data Entry Shortcuts
Hack 13 - Grouping Worksheets


New Excel Hacks April 2016 :
Hack #14 - Email as PDF
Hack #15 - Excel Calculator
Hack #16 - Add to AutoCorrect


New Excel Hacks May 2016 :
Hack #17 - Hidden Excel Function - DATEDIF()
Hack #18 - Excel Function SUMPRODUCT()
Hack #19 - Excel Array Formulas
Hack #20 - Excel SUMPRODUCT() with Criteria


New Excel Hacks June 2016 :
Hack #21 - Creating an Excel Table of Contents with VBA (UPDATED)
Hack #22 - Creating a Dynamic Range with Excel's OFFSET() Function
Hack #23 - Working with Excel Spin Controls


New Excel Hacks July 2016 :
Hack #24 - Import Data from a Website
Hack #25 - Paste Special - Transpose Data
Hack #26 - Evaluate Formulas with F9


New Excel Hacks August 2016 :
Hack #27 - Custom Views in Excel
Hack #28 - Excel's xlSTART Folder
Hack #29 - Automate with the Excel Macro Recorder


New Excel Hacks October 2016 :
Hack #30 - Convert Text To Number
Hack #31 - Flash Fill (New Excel 2013 Feature)
Hack #32 - Quick Analysis (New Excel 2013 Feature)

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396