Grouping, ungrouping, and dealing with errors How to combine data from multiple worksheets for a PivotTable ![]() How to do a PivotTable (a quick refresher) How to create awesome visualizations using sparklines and data barsĪdvanced charts such as Surface, Radar, Bubble, and Stock ChartsĬreate pivot charts based on PivotTable dataĪdd slicers and timelines to your dashboardsĪdding new data to the original source dataset How to use Goal Seek, Scenario Manager, and Solver to fill data gapsįinancial functions including calculating interest and depreciationĬonnecting to other workbooks and datasets outside of Excel e.g. How to use Conditional Formatting to highlight areas of your data How to display your analysis using Pivot ChartsĪll about forecasting and using the Forecast SheetsĬonducting a Linear Forecast and Forecast Smoothing How to use slicers to draw out information How to standardize and clean data ready for analysisĪbout using the PivotTable function to perform data analysis How to split data using text functions SEARCH, LEFT, RIGHT, MID How to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysis How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUP In this special course, we’ve combined five of our full-length titles into one, huge-value bundle. ![]() In this five-course bundle, we look at a number of advanced Excel techniques all aimed at helping you make sense of the numbers in your business. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct comprehensive data analysis. You don’t need to be able to code or understand algorithms. **This course bundle includes practice exercises**ĭata Analysis is THE skill you need to thrive in the modern workforce.ĭata Analysis is easier than you might think.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |