Pivot Tables
-
Speaker : BOB UMLAS
-
When : Monday, May 20, 2024
-
Time : 12 : 00 PM EST
-
Add To Calendar
Refer a Friend
Bob Umlas worked for a major tax and accounting firm, using Microsoft Excel® 8 hours a day, writing custom applications for staff and clients from 1998 to 2018.
He has been using Excel since 1986 - version 0.99 (on the Macintosh)! He was a contributing editor to Inside Microsoft Excel for many years, a magazine devoted exclusively to Microsoft Excel and published by The Cobb Group and later Ziff-Davis. At the time, most issues contain either an article by Mr. Umlas on using VBA (Visual Basic for Applications) or some tip or technique from him on using Excel. He has had more than 300 articles published on subjects ranging from beginner to advanced macros, and on tips, shortcuts, and general techniques using virtually all aspects of Excel.
Mr. Umlas was voted an “MVP” (Most Valuable Professional) by Microsoft each year from 1994-2018 (25 years!) for his contributions to the various online Forums about Excel and is known world-wide for his contributions in Excel. As an MVP, he met yearly with his fellow-MVPs at Microsoft’s headquarters in Redmond, where he had access to the product developers. He has been a beta tester for new versions of Excel since version 1.5, and was asked by Microsoft for his input for newer versions of Excel. In 1995 he led a session called "Maximizing Excel Development Using Array Formulas" at Microsoft's Tech Ed Conference in New Orleans, and he led a session called Tips and Tricks at a Microsoft convention in New York City.
He has been the host of the Excel Conference held in London for the past 3 years and is again hosting for 2024, as well as leading a session on tips and tricks. He is also leading a session at the Active Cell conference in Las Vegas in December, 2023.
He is also the author of “This isn’t Excel, it’s Magic!” which is available from http://www.iil.com/publishing as well as from Amazon.com. Another book, “Excel Outside the Box” is available from http://www.mrexcel.com and is for the very advanced Excel user. Another book, “More Excel Outside the Box” is also available from mrexcel.com. One more, “Cool Excel Sh*t” is more tips & tricks. Lastly, published for Kindle, is “Excel Preschool: Finally Understanding what Excel is all About” – a book for the very beginner!
He has co-authored several chapters in many books on Excel and has done the technical editing for 4 books for Excel 2019, as well as about 12 books for prior versions of Excel and 4 books for Office 365’s Excel.
An Excel pivot table is a powerful data analysis tool that allows users to summarize and analyze large sets of data in a spreadsheet. It helps users organize and aggregate data from a table or range into a more meaningful format, making it easier to understand and draw insights.
Pivot tables are useful for quickly analyzing and visualizing large datasets, identifying patterns, and gaining insights into your data without the need for complex formulas. They are a key feature in Excel for data analysis and reporting.
Areas Covered
- How to create one?
- How to manipulate/rearrange the data?
- Various ways of showing and summarizing the data
- Using calculated items and fields
Course Level - Intermediate
Who Should Attend
Data Analysts, Financial Analysts, Business Analysts, Project Managers, Marketing Professionals, Sales Representatives, Human Resources Specialists, Operations Managers, Educators and Researchers, Entrepreneurs and Small Business Owners, Supply Chain Managers, Healthcare Analysts, Quality Assurance Professionals.
Why Should You Attend
Pivot tables provide a convenient way to summarize and aggregate data. You can quickly create subtotals, averages, counts, and other summary statistics without the need for complex formulas.
Pivot tables allow for dynamic reporting. You can easily rearrange, filter, and sort your data to view it from different perspectives without altering the original data set.
The insights gained from pivot tables can support better decision-making. Whether you're working on business analytics, financial analysis, or any other field, pivot tables provide a valuable tool for making informed decisions.
-
$160.00
-
