DLA Energy has created a 3-level training program in Excel designed to take you from a novice to an expert level talent utilizing Excel for Data Analytics. We’ve pulled out the training assets in each level and developed a learning pathway for those interested in learning more about Excel. The playlists are: Data Explorers, Data Navigators, and Data Voyagers. The Data Voyagers playlist covers advanced material to include Power BI, Power Query, Dax, creating responsive automated user-friendly spreadsheets that will pull your data from a secondary source, using VBA (Visual Basic for Application) to understand the background of macros, advanced techniques, some reinforcement of that storytelling aspect, and finally some financial business functions that everyone can benefit from. Playlist Owner: Kevin Linden.
Online Class
Excel: Creating a Dashboard with Power Query (Microsoft 365)
1 Hour, 20 Minutes
External Content
Top 10 Advanced Excel Tricks for Data Analysis-Free Masterclass with Sample Files
2 Hours, 11 Minutes