![]() ![]() ![]() Plus, learn how to work with the newest features in Excel, including Power Query and dynamic arrays, which make it so much easier to get what you need from your data without clumsy, complicated, and delicate formulas. Next, Oz shares how to work with multiple data sets at once sort and filter data and use functions to isolate and analyze data. He then steps through how to prepare your data for analysis by setting it up into sortable, filterable columns and rows. Oz dedicates the first portion of the course to an often-overlooked part of data analysis: checking data quality. Instead of focusing on pure analysis (forecasting, running regressions, etc.), Oz covers how to use built-in Excel tools to prepare your data for analysis and extract the information that supports your mission. Ready to start working with spreadsheets like a pro? Join Excel MVP Oz du Soleil as he shares how to clean, organize, and analyze large amounts of data with ease using commands, features, and functions within Microsoft Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |