Purchase any Event and get
20% Off
CODE: TWENTY20
T&C applicable, please referFAQ
Validity : 25th Dec'24 to 04th Jan'25
Excel: Pivot Tables Crash Course
- Quickly summarize data with Pivot Tables
- Manipulate (or Pivot) the Pivot Table for varying results
- Group data by custom number ranges and date ranges
- Create a calculated field within the Pivot table
- Learn the built in “Summarize By…” features
- Learn how to “drill down” to details
- Learn how to keep your Pivot table spreadsheet tidy
- Create Dashboard tools to assist others who might use the workbook
- Apply design techniques
- Learn the little known – but vital – ‘Pivot Table Options’ that will save time and frustration
Overview of the webinar
Pivot Tables have been a mainstay of the Excel program for two decades, and yet they remain a daunting and little understood tool.
If you are a daily user of Excel, eventually you will be faced with the challenge of data summaries and analysis.
The 1st level of that process is sorting and filtering. The 2nd level is Pivot Tables. Without them, you will be spinning your wheels trying to make sense of data.
In this crash course, Andy Lanning will take you from Pivot intro to Pivot advanced - with many tips and tricks along the way!
This course will demonstrate the Pivot Table window, the design process, the advanced level features, and also provided is a downloadable PDF guide with step-by-step instructions on each feature covered.
You will see various Pivot Table and dashboard examples in order to provide ideas on handling different projects and data sets.
Take this course and benefit from Andy Lanning’s 30+ years of experience. At the finish, you will realize how easy Pivot Tables are in helping you through your data summaries!
Who should attend?
- Anyone that is using Data Sets and has the need to summarize data into a presentable format
Why should you attend?
Pivot Tables are a “data summary” tool useful in data analysis spreadsheets
Attend this webinar for a crash course in Pivot Tables and you’ll be amazed how often you will use Pivots for any task that involves summarizing data.
Excel Pivots can be a mystery until you learn the handy tips in this webinar that will bolster your confidence when summarizing data.
Faculty - Ms.Andy Lanning
Andy Lanning has worked extensively with Microsoft Office products since the early 1990s.
She has traveled the United States presenting at conferences and corporate classes to help attendees unlock the full potential of the most common office software programs faced daily in our lives: Microsoft.
Andy considers herself a computer “nerd” and has been training individuals and groups since 1995. She continues to teach computer VoTech classes at Boise State University in Idaho and is the owner of a computer consulting business.
She is a Certified Microsoft Office Specialist and trains most Microsoft programs. With 30+ years’ experience in the computer industry, Andy focuses every class on using software to solve common workflow issues.
Be prepared to learn more than you bargained for in her class. Andy always teaches the 5 Super Secrets to computers and believes firmly in efficiency training.
“My goal is to lower frustration and raise productivity. And maybe have some laughs along the way!”
Software specialty areas include:
- Microsoft 365: Word, Excel, Outlook, PowerPoint, Publisher, Teams
- Excel topics: Charts and Data Visualization, Formulas, Hidden Tools of the Trade, Data Analysis tools, Pivot Tables and Power Queries
- Office Processes: mail merges, forms, databases, data analysis, including
- Power BI training
- How to set up accessible PDF and Word docs to comply with the US Federal
- ADA Law (American’s with Disabilities Act)
- Video Conferences: Zoom, Teams, and standalone VTC systems
- Internet and E-mail
- Computer Basics