Mastering Excel Formula and Functions – Learn To Use Powerful Functions & Write Formulas Efficiently

Training Format: Recorded Webinar

Format Type: DVD

Speaker(s): Dennis Taylor

Supporting File(s) : Download Zip (316.35 KB)

Webinar Date: Thursday, February 23, 2017

Training Duration : 75 minutes

Training Material Download : Conference Material (Password Required) (342.18 KB)


Untitled Document

Mastering Microsoft Excel: Tips, Tricks, and Shortcuts

For many Excel users, working with formulas and functions is the most important thing they do. There are many shortcuts for working with formulas more efficiently and there are auditing tools that help identify the location of formulas, as well as identifying formula dependencies. Excel has over 450 built-in functions, but without any guidance as to which ones might be important for any specific user, it cn be intimidating. Are you also under-utilizing the power of this vital software package—you could be saving minutes every day and hours every week if you learn some of the many tips presented in this fast-paced webinar.

This webinar Mastering Excel Formula and Functions – Learn to Use Powerful Functions and Write Formulas Efficiently by Dennis Taylor provides numerous tips and shortcuts for working with formulas, provides in-depth coverage of powerful functions, like IF, VLOOKUP, MATCH, INDEX, and SUMIF, and provides an overview of many date, statistical, mathematical and frequently overlooked text functions.

Learning Objectives

This “must attend” and “don’t miss” webinar will give you how you can increase your productivity and work smarter MS Excel. Dennis will show you:

  • Formula and function shortcuts to make you more efficient Excel user
  • Reducing formula complexity with auditing tools
  • Using the programming-like IF function and using the AND and OR functions
  • Performing approximate and exact match lookups with the powerful VLOOKUP function
  • Tackling more complex lookups with the MATCH and INDEX functions
  • Analyzing data with the COUNTIF, SUMIF family of functions
  • Selected uses of date, statistical, and mathematical functions

 Session Highlights

In this power-packed session, Dennis will discuss:

  • A variety of real-world examples of formulas that will equip you with the tools to understand and create formulas more efficiently and apply them in ways that will accelerate their ability to analyze data
  • Over 100 Excel shortcuts to make you a power user!
  • Use keystroke shortcuts for most of the important numeric formats
  • Learn multiple tools and techniques for copying formats
  • Learn the fastest ways to add formatting features to your worksheets
  • Create custom formats and quickly access built-in formats
  • 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

Who Should Attend

This webinar is highly advised for marketing, sales, legal, medical, engineering personnel; office administrators, managers,
and directors within the business arena, financial analysts, educators, students, research personnel, home users — anyone who is using MS Excel.

Ask a question at the Q&A session following the live event and get advice pertaining to your situation, straight from our expert speaker.



Dennis Taylor has over 25 years of experience working with spreadsheet programs as an author, speake.. Read More >>


Leave Work On Time Using Microsoft Outlook As A Workflow Implementation Tool
Karla Brandau

Managing Lists And Databases With Microsoft Excel
Mike Thomas