Excel Analytics Courses

1. Microsoft Excel Data Analysis - Learn How The Experts Use It

Microsoft Excel Data Analysis - Learn How The Experts Use It

Learn the analytics capabilities of Excel and its add-ins, like PowerPivot & How it is used by business data analysts.
Content:
- Understand and Identify the principles of data analysis
- Build presentation ready dashboards in Excel
- Apply analysis techniques to datasets in Excel

2. Microsoft Excel Data Analysis and Dashboard Reporting

Microsoft Excel Data Analysis and Dashboard Reporting

Build Dynamic, Interactive Microsoft Excel Dashboards (Excel 2010, 2013, 2016) with a Best Selling Excel Instructor
Content:
- Understand and Identify the principles of data analysis
- Effectively summarize and present data clearly
- Use effective design principles when creating and presenting data

3. Data Analytics with Excel PivotTables

Data Analytics with Excel PivotTables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples
Content:
- Understand the importance of Data analytics in today's business.
- Understand the types of Business analytics and real life examples of Business analytics
- How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.

4. The Complete Microsoft Excel Pivot Tables and Pivot Charts

The Complete Microsoft Excel Pivot Tables and Pivot Charts

Excel Charts, Excel Analytics, Excel Pivot Table , Excel Pivot Charts, Excel Dashboard, Excel Data Analysis & Reporting
Content:
- What Is Pivot Table and Pivot Charts and Key Benefit of Pivot Table?
- How to Normalize the Data for Pivot Table?
- How to Convert Normal Data to Table?

5. Excel Analytics: Linear Regression Analysis in MS Excel

Excel Analytics: Linear Regression Analysis in MS Excel

Linear Regression analysis in Excel. Analytics in Excel includes regression analysis, Goal seek and What-if analysis
Content:
- Learn how to solve real life problem using the Linear Regression technique
- Preliminary analysis of data using Univariate analysis before running Linear regression
- Predict future outcomes basis past data by implementing Simplest Machine Learning algorithm

6. R Tidyverse Reporting and Analytics for Excel Users

R Tidyverse Reporting and Analytics for Excel Users

From Excel To Big Data and Interactive Dashboard Visualizations in 5 Hours
Content:
- How R implements common Excel functions and how it can actually be faster
- easier and more flexible than the familiar Excel methods. By the end of this course you will have the knowledge to work with large sets of data faster and easier than you ever thought possible. This course uses the tidyverse libraries in R which provide an elegant solution for solving 99% of our reporting requirements. Tidyverse is incredibly well supported and by focusing solely on this one set of libraries we can massively shortcut the amount of time that is required to get up and running with R. Many beginner courses in R will start teaching what is known as base R which covers the original methods for working with R that have been enhanced and simplified through the tidyverse. Although it maybe useful to have some understanding of base R it is neither a requirement of this course or a requirement to becoming really productive in the R language. As we go through the exercises we are going to be comparing to the most common way that processes are typically carried out in Excel.

7. Advance Analytics with Excel - data analysis toolpak/ Solver

Advance Analytics with Excel - data analysis toolpak/ Solver

Advanced data analysis in excel: Data Analysis tools (toolpak add-in) for statistics / solver for linear optimization
Content:
- Perform Data Analysis / Statistical Analysis using Excel
- Be comfortable with data analysis tool pack / solver / goal seek
- Understand the business context / scenario where the statistical procedure is applicable

8. Microsoft Excel DATA ANALYSIS Using my Proven 4-Step System

Microsoft Excel DATA ANALYSIS Using my Proven 4-Step System

Excel Data Analysis w/Pivot Tables. Learn my valuable 4-step system to IMPORT, CLEAN, ENHANCE, & ANALYZE data in Excel.
Content:
- Learn my effective 4-step process for importing
- cleaning
- enhancing and analysing your data.
- Learn how to use Pivot Tables to do lightning fast data analysis.

9. Excel Data Analysis Masterclass with Excel Dashboards

Excel Data Analysis Masterclass with Excel Dashboards

Master Advanced MS Excel topics - Excel Formulas, Excel Formatting, Excel Pivot Tables, Excel Dashboards & Analytics
Content:
- Learn about basic formatting in excel.
- Learn about sorting and filtering functions in excel.
- Learn about UPPER
- LOWER
- PROPER
- LEFT
- RIGHT
- SEARCH
- CONCATENATE functions in excel.

10. Excel Crash Course: Dashboards, Data Analysis & Heatmaps

Excel Crash Course: Dashboards, Data Analysis & Heatmaps

Learn core, business-focused Excel skills for data analysis, data visualisation and dashboard modelling in 3 hours
Content:
- Explore Microsoft Excel from a data science & data visualisation and data analysis perspective
- Design three dashboard systems in Excel - Twitter Activity Heatmap
- Advanced Currency Converter
- Business Invoicing Dashboard
- Learn to use Excel dynamic arrays with other functions like a pro to build automated systems

11. HR Analytics using MS Excel (Excel Analytics)

HR Analytics using MS Excel (Excel Analytics)

Using MS Excel's Data Analysis Toolpak to perform HR analytics on various business cases.
Content:
- MS Excel
- Data analysis toolpak
- t test

12. MS Excel - Preparing an HR and Employee Dashboard

MS Excel - Preparing an HR and Employee Dashboard

Learn to create HR Dashboard and explore powerful analysis for HR data
Content:
- Learn index designing and tab designing supported with interactive charts and graphs
- Learn how to create and use Pivot table and charts effectively to arrange and analyze your data.

13. Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

Learn Advanced Excel: Take the Next Step w/ Microsoft Excel

"Do you know any good Excel jokes? I know SUM." Learn advanced Excel w/a touch of humor, from an experienced instructor.
Content:
- Learn advanced Charts
- Formulas
- Shortcuts
- Pivot Tables and Visualizations.
- Build on your existing beginner to intermediate Excel skills.
- This course uses fun examples
- humor
- and an experienced instructor to make learning advanced Excel easy and interesting.

14. Advanced Data Analytics & Story-Telling Techniques

Advanced Data Analytics & Story-Telling Techniques

Learn story-telling with data skills to derive insights from raw data using slicers, pivot-tables and graphs in Excel
Content:
- Create pivot-tables and pivot-graphs in Excel
- Use slicers in Excel for data mining
- Undertake data analysis in Excel

15. Tax & Adjusting Entry Year-End Accounting Excel Worksheet

Tax & Adjusting Entry Year-End Accounting Excel Worksheet

Build Excel worksheet for adjusting adjusting & tax entries, reconciling net income calculated on a book and tax basis
Content:
- How to build an adjusting and tax worksheet from scratch in Excel
- What the benefits of an adjusting and tax worksheet are
- How to enter adjusting entries into an adjusting and tax Excel worksheet

16. Excel for Data Analysis: Basic to Expert Level

Excel for Data Analysis: Basic to Expert Level

Learn data analysis main concepts from basic to expert level through a practical course with Excel.
Content:
- Use main Excel file or workbook types and protect them before sharing.
- Store data in workbooks consisting of one of more worksheets.
- Navigate worksheets through their cells which can be grouped in ranges.