16 hours (2 days)
8:30 a.m. – 4:15 p.m. Central Time
A 45-minute break for lunch. One morning break of 15-minutes and two-afternoon breaks.
This class will be held online using GoToMeeting. Class participants will receive a PDF of the book and will be able to access the class files online.
When you register, be sure to use the email that you would like your GoToMeeting invitation sent to. The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account. You do not have to have a GoToMeeting subscription to participate.
The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.
It is a good idea to download this prior to the online meeting.
Many advanced Excel users such a Mr. Excel have called Power Pivot the Best Thing to Happen to Excel in 20 Years. Class will begin with a quick overview or refresher on how to create a Table and a basic PivotTable. We will then move into more advanced PivotTable topics such as creating Measures, Calculated Fields, and Calculated Items. And we will look at PivotTables settings.
Next, we will learn how to take multiple tables, add them to Excel’s Data Model, relate them and then create a Power Pivot. We will look at the Get and Transform feature also called Power Query. Power Query is often called a self-service Business Intelligence (BI) tool. In newer versions of Excel, Power Query has been renamed Get & Transform because it allows you to connect to a source, combine and clean up data and then analyze the data.
We will learn how to write formulas both in Power Query and the Data Model. Many of these formulas will be like what you have used in Excel. However, these formulas have a different structure and are often more powerful and work better with large data sets. And a major advantage is the ability to get new data or change data and then simply refresh your query. If you write formulas using a VLOOKUPS, INDEX, and MATCH or IF statement in Excel, with large data sets you will be amazed at the speed of these newer features. And if you write macros to clean up data, you might find these new features will work much better than a macro.
The student should have an Intermediate to Advanced knowledge of Excel. You will need basic understanding of formulas such as a VLOOKUP and an IF statement. Please read the Course Description and Outline to see if this course is for you.
EXCEL 2013, 2016 or Office 365. The curriculum will show you how to perform a task in Excel 2013, 2016 or Office 365. If you have Excel 2010, you will be limited in what you will be able to do after class.
In this class, we will learn how to use the Excel features called Get and Transform also called Power Query. This class will teach you how to use data from multiple Excel spreadsheets, database tables, CSV files or other sources, transform it and then analyze the data. We will also review PivotTables and learn how to create more advanced PivotTables called Power Pivots. If you are an Intermediate to Advance Excel users would like to expand your knowledge of Excel this class is for you.
The cancellation deadline is 5 business days prior to the class. If you are unable to attend, you may send a substitute. If you are a "no show" or you do not send a substitute you will be charged full price for the class.
Cloud Training Services will consider emergency situations such as a death in the family, illness, and weather, and will make every attempt to work with the person in the event of an emergency.
|Event Date||02-02-2021 8:30 am|
|Event End Date||02-03-2021 4:15 pm|
|Cut off date||02-02-2021 8:00 am|