Excel VBA Code Library

FREE BONUS: VBA CODE LIBRARY - 30 OF MY BEST MACROS

Days
Hours
Minutes
Seconds

Advanced Excel Reports Dashboard Masterclass

Create Stunning Single Click Reports & Graphs Using My

Includes:

  • 15.5 hours on-demand video
  • Full Excel Reports Application
  • VBA Code FULLY Commented
  • 11 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
  • Money Back Guarantee
Mal Gib
Mal Gib
"It Was Amazing"
I have just finished this Dashboard Course and it was amazing, Randy has a great way of teaching. I would totally recommend this course if you are looking to expand your Excel skills. Thanks Randy looking forward to more of your courses, Mal
Carlos Mejias
Carlos Mejias
"The Best Excel Course That Exists"
This is definitely the best Excel course that exists. Randy Austin not only has extremely advanced and extensive knowledge of the Excel application and VBA programming techniques but also has a very unique way of explaining what makes complex routines easy to understand.
Raj Maniar
Raj Maniar
"You are magician in Excel"
Truly great Dashboard that All Management wish to have. "Single Click" feature is unique and unbeatable. 👍 You are magician in Excel. 😊
Roberto Velicaz
Roberto Velicaz
"Many Thanks!!!"
There are so many things that I have come across that I would like to incorporate in future projects and I think that is the main take away after the dashboard itself...Many thanks!!!
stingehte
stingehte
"Mind Blowing"
Mind blowing... Couldn't believe my eyes all done with Excel n VBA.
Richard Hainsworth
Richard Hainsworth
"A Brilliant Course"
It's a Brilliant Course...
David Maxwell
David Maxwell
"A God Among Men"
A god among men when it comes to Excel!

Description

Advanced Excel Reports Dashboard MasterclassThis Advanced Dashboard Course will be like nothing you have ever seen before. While other Dashboard courses show you some cool graphs and charts that are hard to duplicate in the real world, this course is going to give you FRAMEWORK to create an incredible dashboard blueprint that you can plug into any project and have a nearly done-for-you Reports & Graphs Dashboard ready to go.

In this 15+ hour course you are going to learn the exact Dashboard structure I have used to gain thousands of dollars of projects from happy customers around the world AND I am going to give you the Actual Template I have used in ALL of my application Dashboards, so you can follow along with every step of the training.

On completion of this course you will be able to create a single Dashboard Foundation that can contain literally hundreds of reports and graphs, all accessed and viewed with a single click of a mouse, and with ANY type of data. 

You can then use the techniques, methods, tricks & designs in your own projects to make more money, gain freedom and reach your own goals and potential

The skills you learn such as Expanding and Shrinking data table along with pop-up dynamic data pictures and single click column sorting will WOW your Bosses and Customers ensuring that you will be the ONLY one then come to when they need Excel solutions.

Plus,  the Unique Custom Reports feature will allow your users to create their own, unlimited customer reports, with just a few clicks. What could be more powerful than that?

Read More

Course Outline

September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 5, 2018
September 6, 2018
September 6, 2018

What Will I Learn?

  • Generating Reports & Graphs With a Single Click
  • Create A Dynamic Date Range Table
  • Emailing Reports With A Single Click (PDF, Excel & Picture Formats)
  • Saving Reports On Single Click (PDF, Excel & Picture Formats)
  • Protecting Your Code, Hard Work & Intellectual Property
  • Create Comprehensive & Powerful Advance Filters in VBA
  • Advanced Drill Down & Drill Up Techniques to Embed a Table In A Table
  • Auto-Filtering Just By Typing (Partial & Exact Matches, From & To Values)
  • Adding, Editing, Updating & Deleting Custom Reports
  • One Click Table Sorting (Ascending & Descending)
  • Dynamic Conditional Formatting Based On Report Data & Position
  • Getting A Unique Record List With Advanced Filters in VBA
  • Create Dynamic One-Click Financial Reports (Profit & Loss, Sales & Balance)
  • Generating Unique ID's using MAX Formula
  • Clear Report Filters On Single Click
  • Single Click To Alternate Between Reports & Graphs
  • Error Handling & Prevention In VBA
  • Accelerate Your VBA Programming with Unique Shortcuts
  • Securing Your Application Against Loss, Corruption & Damage
  • How To Restore A Corrupted or Damaged Excel Workbook
  • Clearing Advanced Filter Criteria Through VBA
  • Setting & Updating Default Date Ranges For Reports
  • Absolute & Relative Cell Formula Differentiation Defined
  • Using Named Shapes & Groups to streamline code
  • Calculating Income, Expense, COGS and Gross & Net Profits
  • VBA Editor & Options Review
  • Tested Techniques That Reduce Memory & Increase Speed
  • Copying, Clearing & Updating Conditional Formatting in VBA
  • 3 Proven Methods To Locate Records
  • Refreshing Reports Automatically On Date Change
  • Determining Last Used Row In A Table Via VBA
  • Hiding Sheets (Standard & Very Well Hidden)
  • Automatically Clearing & Resetting Field Placeholder On Tab In/Out
  • Generating SUMIF & INDEX/MATCH Formulas In VBA
  • Creating Dynamic Text For Both Shapes & Cells
  • Hide & Show Shapes and Groups Using VBA
  • Disabling Copy & Paste and Drag & Drop To Maintain Integrity​
  • Check / Un-check option box through cell selection
  • Setting A Print Area Using VBA
  • Unlimited End-User Custom Report Creation
  • Create Dynamic, Shape-based Drop Down Menu With Icons
  • Speed Up Your Applications with 'Calculation On Demand'
  • Dynamic Named Ranges using COUNTA and COUNTBLANK
  • Automated Printer List For Versatile One-Click Print To Any Printer
  • Single Click Column Toggle to Hide & Show Report Columns
  • Custom Date Range With Pop-up Calendar
  • Perfecting the INDEX/MATCH Formula
  • Grouping & Ungrouping Of Shapes Using VBA
  • Hiding & Showing Columns With VBA
  • Using Dynamic Ranges in Graphs & Charts
  • Techniques To Prevent Loss Of Data
  • Principals For Building Simple Yet Powerful Reports Dashboards
  • Principals For Building Simple Yet Powerful Reports Dashboards
  • Principals For Building Simple Yet Powerful Reports Dashboards
  • Creating And Displaying A Dynamic Data Picture On Click
  • Securing Your Work & Intellectual Property
  • Creating Emails With Variable Content & Report Data
  • Exporting Reports With Automated Report Names (Excel, PDF, Picture)
  • Dynamic Report Headers Based On The Date Range
  • Error Handling & Trapping In Formulas
  • Create A Dynamic Fade Out Message
  • Setting Up For Speed With Shortcuts
  • Tested Techniques That Reduce Memory & Increase Speed
  • Securing Shapes & Groups To Maintain Size & Position Integrity
  • Conditional Formatting for Alternating Rows & Additional Criteria
  • Performing Calculations In VBA
  • Working With Reference Libraries & Possible Issues
  • Minimizing Bugs, Crashes & Data Corruption
  • Accelerating Code Run Time With Proven Techniques
  • Creating & Maintaining Your Application Theme & Colors
  • Assigning Macros To Shapes & Groups
  • Highlight Selected Report Using Conditional Formatting
  • Create An Outstanding Invoice Report
  • Creating Sales By Month Report, Line & Bar Charts
  • Using MONTH Formula in Tables & Charts
  • Using Transpose In VBA
  • Auto-Sum Transactions Based On Account Types & Date Range
  • Create & Assign Macro To Close Picture Pop-up
  • Setting A Custom Background Color On A Form

Requirements

  • Familiarity with Excel, Basic Formulas and Very Basic VBA is helpful but not required as every step is explained and clearly commented out.
  • Application and training were done with Excel 2010. All of the skills and download will function in versions 2007, 2010, 2013 or 2016.
  • While most features will work on either a PC or Mac, a Mac versions may have other variations as training is done on a PC

BONUSES

Hurry & Get EVERYTHING Below Today Before It's Gone...

Private Facebook Group

Instant Access to the Private & Exclusive Excel For Freelancers Students Group where you will be able to network, get immediate help to your questions, and share ideas with like-minded students who also share your passion for Excel. This group is going to be small intentionally, so make sure you get in today, before it’s closed.

AutoHotkey With VBA

I have taken the Open Source software AutoHotkey and created an amazing VBA Accelerator Add-In which will speed up your development time AND Increase your accuracy by AUTOMATICALLY Typing in Code for you. This application ALONE can save you hundreds of hours over time. You can also customize this yourself to add in any of your favorite shortcuts to create the most powerful coding partner you have seen.

Find & Remove Excel Add in

Anyone who works with Excel Workbooks a lot has run into the dreaded “This workbook contains links to other data sources” Finding and removing these links has always been a HUGE headache.
Until Now! With this Find & Remove Links Excel Add-in you can now find all links to external sources and optionally remove them with a single click.

Excel Tips & Tricks eBook

50 Tips To

Excel E-Book​

One of the best Tips & Tricks on Excel, expertly put together by How To Excel. This Excel Bible covers the most important tips and shortcuts , countless hours, and lots of headaches of of time. Each tip is masterfully put together with beautiful screens shots & clear instructions.

Excel User Login & Security Workbook

User Login Workbook

Security is one of the biggest issues in Excel, and that means security might be different for each user and each sheet. In this amazing workbook (and complete training video) I show you how to create a powerful User Login and Per Sheet Security  feature that you can add to ANY workbook.

Excel 95 Tips & Tricks

Excel Tips & Tricks E-Book

This is one of the best books I have read on Excel Tips & Tricks as it’s packed full of amazing tricks even the most Advanced Excel Developers can learn from. This book alone has saved me tons of time and lots of keystrokes with its simple and straightforward insights into the amazing world of Excel Shortcuts.

See A Full Demo Of Every Feature You Will Master Below