About Our Speaker(s)
Dennis Taylor

Dennis Taylor has taught thousands of Excel seminars and classes since the early 90′s, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses both for online and DVD distribution.

Mike Thomas

Mike has worked in the IT training business since 1989 where his expertise and experience covers designing, delivering training courses, writing training materials and recording and editing video-based tutorials. Although he is a subject matter expert in a range of Microsoft technologies and has worked extensively with Mac OSX and Mac-related software since 2006; however, his passion is for all-things-Excel and in 2012 he founded the website theexceltrainer.co.uk

Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he designs and develops Microsoft Office-based solutions that automate key business tasks and processes.

Business Intelligence with Microsoft Excel Virtual Boot Camp 2017 (VRTCDP527)

Event Information
Product Format
Pre-recorded Audio Conference
Dennis Taylor, Mike Thomas
300 minutes
Event Description



Microsoft Excel has become the world's most popular spread sheet software that lets users perform multiple business tasks, like creating dashboards, charts, pivot tables, and much more.

Gaining mastery over Excel will not only ease your day-to-day work but also provide tools to make the most of your data. Whether you're a beginner or an expert, the Business Intelligence with Microsoft Excel – Virtual Boot Camp will cover vital aspects of Excel that you will find essential in building your professional skills.

This boot camp will help you master charts and graphs, use PivotTables to process huge amounts of data, improve business analytics with dashboards, and learn about cool Excel lesser-known tips and tricks from the top two Excel experts in the industry.

Session Details:

Session 1:

Excel Tips and Shortcuts

Get over 100 Excel tips with various easy techniques, shortcuts, and accelerator tools.

11:00 AM to 12:30 PM ET | Duration: 90 minutes | Presenter: Dennis Taylor

Session Highlights:

  • Navigate seamlessly through workbooks and worksheets with keystroke and mouse shortcuts
  • Copy or move data with simple dragging instead of multi-step command sequences
  • Display/hide all worksheet formulas instantly; select all formula cells with two mouse clicks
  • Use keystroke shortcuts for a various number formats
  • Build lists of dates, times or values without using time-consuming commands
  • Create charts instantly and learn manipulation tips
  • Create formulas faster with entire column references
  • Master over 100 tips to make you a Power User!

12:45 PM to 1:00 PM ET - Break

Session 2:

Mastering Excel Charts and Graphs

Learn how to create and enhance the appearance of traditional charts such as pie charts and bar charts as-well-as represent data graphically.

1:00 PM to 2:00 PM ET | Duration: 60 minutes | Presenter: Mike Thomas

Session Highlights:

  • Creating a simple bar chart
  • Annotating a chart with labels, titles and notes
  • Creating a line-bar combination chart
  • Creating a dynamic chart based on a Table
  • Creating Sparkline charts
  • Creating infographics with Excel
  • Using Conditional Formatting to present data visually

2:00 PM to 2:15 PM ET - Break

Session 3:

Excel PivotTables: Using Excel's Best Analytical Feature

Work your way around Pivot Charts and Tables to analyze data quickly while adhering to source data pre-requisites.

2:15 PM to 3:15 PM ET | Duration: 60 minutes | Presenter: Dennis Taylor

Session Highlights:

  • Pre-requisites for source data – preparing data so that it can be analyzed by PivotTables
  • Creating a PivotTable with a minimum number of steps, including the new Recommended PivotTables option now available in Excel 2013 and 2016
  • Manipulating the appearance of a PivotTable via dragging and command techniques
  • Using Slicers to accentuate fields currently being shown (and which ones are not)
  • Using the new (in Excel 2013) Timeline feature
  • Creating ad hoc and date-based groupings within a PivotTable
  • Exploring the best techniques for updating PivotTables

3:15 PM to 3:30 PM ET - Break

Session 4:

Excel—Business Intelligence with Dashboards

Learn how to create a dashboard with built-in tools for various functionalities.

3:30 PM to 4:30 PM ET | Duration: 60 minutes | Presenter: Mike Thomas

Session Highlights:

  • Working with data sources
  • Using Pivot Tables to create summaries
  • Displaying the "Top X"
  • Creating a rolling 30-day summary
  • Visual communication using charts
  • Using formulas to create KPI summaries
  • Adding user interaction to your dashboard

Take Business Intelligence and Data Analysis with Excel to a Whole New Level!

Who will Benefit?

  • C Level Executives
  • Executive Assistants
  • Accountants
  • Administrators
  • Office Managers
  • Attorneys
  • CPA
  • Finance Professionals
  • Business Analyst
  • Accountants
  • Bookkeeper
  • HR Professionals

Order Now or Call 1-855-237-1396 Today!


Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or service@proedtech.com. You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.

Best regards,
The ProEdTech Team