Product ID : DETA-0001
Level : Intermediate
Duration : 60 Minutes
Dennis Taylor is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s travelled the United States and Canada giving seminars to help his students unlock the full potential of Excel (so far, he’s been to over 40 states, and Saskatchewan is the one Canadian province he’s missed, but he’ll get there soon enough!). Dennis has a unique ability to describe, decode, and demystify the myriad functions of Excel for individuals and businesses. He’s taught hundreds of workshops and authored numerous tomes on this program.
Chances are if you have a question about LOOKUP, data tabulation, statistics, math functions, or financial features, Dennis has an answer for you (actually, he probably has a training video, book, and seminar chock full of relevant information). He is one of the few Microsoft masters who understand and can bridge the gap between the divergent worlds of Mac and PC. He even taught Apple’s own high-tech team how to use Excel. He also stays at the cutting edge of Microsoft technology—he’s already released hours of training materials on Excel 2016, which launched mere days ago. Dennis’s comprehensive knowledge, decades of experience, and passion for helping others learn Excel make him a perfect fit for our company. When he’s not exploring North America on his Excel training adventures, Dennis makes his home in beautiful Boulder, Colorado.
Accomplishments: Dennis’s 25-year track record of Excel exploits is nearly overwhelming in scope and volume. He has penned and presented more than 400 webinars on various Excel topics in the past nine years. Dennis has also produced numerous Excel courses on video, CD, and DVD. As if this wasn’t enough contribution to Excel education, he’s taught more than 500 seminars and over 5,000 workshops on the subject. Dennis recently partnered with Lynda.com to make his training even more widely available—he’s posted nearly 100 hours (over 30 courses’ worth) of easy-to-understand Excel explanations there. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field. Whether you’d prefer to read, watch, or listen, he can share his expertise with you.
He’s also helped develop custom Microsoft coding solutions for impressive firms such as Harvard. LinkedIn. Core Labs, Red Bull, Honda, Toshiba, Ralph Lauren, General Electric, AT&T, Merrill Lynch, Union Bank, Walgreens, Verizon, Toyota, BMW, In-N-Out Burger, Amazon, Hewlett Packard, Staples, Ford, and even Microsoft itself.
Creating charts in Excel has long been one of its most popular features. Numerical information can be boring and some of us just don’t read and absorb the meaning of such data until we see the information depicted in a chart. You can create an Excel chart with just a few keystrokes or mouse clicks and can easily alter a chart’s appearance by changing its type into a line, bar, pie, or column chart as well as numerous other types.
This session shows you quick ways to create charts, explores which chart types work best for different data, gives you tips on when and how to add gridlines, change background colors, adjust scaling, insert titles, insert ClipArt images, insert trendlines, and how to add functionality, and pizzazz to your charts with simple formatting techniques.
Charting is a powerful and easy-to-use Excel feature that lets users quickly display numerical information in an appealing and concise way. Attendees will learn the best and fastest ways to prepare data for charts and create and modify them with a minimum of effort. They will also learn about the various chart types and which ones are most effective for the type of data being depicted. They will learn the best ways to adjust chart elements and add such eye-appealing features as ClipArt, arrows, text boxes, and color backgrounds.
- How to select source data for a chart from non-adjacent ranges or from multiple sheets
- Learn the fastest ways to create a chart – one keystroke shortcut to create a chart on the same sheet as the source data, another keystroke shortcut to create a chart on a separate sheet
- Learn which chart types are best for the data being depicted and how to change types quickly
- Learn how to insert trendlines and adjust gridlines and axes
- Learn how to annotate charts with data labels, arrows, and boxes
- Set up dynamic charts (those that grow daily, weekly, or monthly) with Excel’s Table feature
- Create in-cell charts with Sparklines
Who Should Attend
Any Excel user who needs quick methods to show
numerical information visually needs to know the basics of chart
creation, how to create in-cell charts with sparklines, how to use
different chart types and how to alter the look of a chart efficiently.