The Microsoft Excel "All the Power" Bootcamp will be held on Thursday evenings from 7:00-9:00 p.m. Central Time from October 29 through November 19, 2020.
This multi-week program will cover Excel's Power BI (Business Intelligence), Power Query, Power Pivot, and Power View. These are Microsoft Excel's data connection and transformation tools that really expand how you can arrange and rearrange data in your workbooks. You DEFINITELY want to learn about these functions and the huge timesaving benefits they will bring to your workday!
We'll discover how to consolidate data from multiple data sources (internal or external), navigate the Power Query editor, build relationships between tables, learn how to unpivot data, utilize the Power Query M Formula language, and much more.
I will demonstrate with Office 365/2019 (Windows). PowerBI was integrated into Excel 2016. In earlier versions, it was a separate add-in software and it is still available today as a separate program with some additional functionality. You may need to access add-ins to work with some of these functions, but they are all Microsoft products and your IT folks should be ok with them.
Cost for this program is $100.
Live sessions aren't convenient for you? No problem! These sessions will all be recorded so that you can listen at your leisure. Recordings will be available for a minimum of 30 days following completion of bootcamp. Please note CAP points are only awarded for attendance on the live sessions.
A letter can be provided for attendees on the live sessions that is suitable for submitting for Certified Administrative Professional (CAP) recertification points following completion of the bootcamp.
About the Instructor
Marie Herman, CAP, OM, ACS, MOSM
MRH Enterprises LLC
When it comes to career and professional development to help administrative professionals advance, Marie Herman, CAP, OM, ACS, MOSM knows how to take you from where you are, to where you want to be. She has made her career helping others to develop their skills through strategic planning, website design, and technology. With certification as an internet webmaster designer, Microsoft Office Specialist (Master Level), Advanced Toastmaster-Silver, and an Associate's Degree in Business, Marie has an expansive knowledge in many areas, and can help you become an expert as well. She is an author, mentor, and expert on a number of computer and professional development topics. Marie is the owner of MRH Enterprises and teaches classes on Microsoft Office, Windows, and various other internet topics. She has been a member of the International Association of Administrative Professionals (IAAP) since 1997 and was the 2012-2013 President of the Illinois Division of IAAP. She has more than two decades of experience as an administrative professional and efficiency consultant.