The Microsoft Excel Data Analysis Toolkit Bundle

Partner: Udemy
Affiliate Name:
Area:
Description: **This course bundle includes practice exercises**Data Analysis is THE skill you need to thrive in the modern workforce.Data Analysis is easier than you might think. You don’t need to be able to code or understand algorithms. What you need, is a deep understanding of the Microsoft Excel techniques needed to conduct comprehensive data analysis.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.In this special course, we’ve combined five of our full-length titles into one, huge-value bundle. Here’s what you get:Excel for Business AnalystsWhat you’ll learn:How to merge data from different sources using VLOOKUP, HLOOKUP, INDEX MATCH, and XLOOKUPHow to use IF, IFS, IFERROR, SUMIF, and COUNTIF to apply logic to your analysisHow to split data using text functions SEARCH, LEFT, RIGHT, MIDHow to standardize and clean data ready for analysisAbout using the PivotTable function to perform data analysisHow to use slicers to draw out informationHow to display your analysis using Pivot ChartsAll about forecasting and using the Forecast SheetsConducting a Linear Forecast and Forecast SmoothingHow to use Conditional Formatting to highlight areas of your dataAll about Histograms and RegressionHow to use Goal Seek, Scenario Manager, and Solver to fill data gapsAdvanced Excel 2019 CourseWhat You'll Learn:What's new/different in Excel 2016Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and
Category: Office Productivity > Microsoft > Excel Analytics
Partner ID:
Price: 149.99
Commission:
Source: Impact
Go to Course