Excel Analytics Courses
- Home
- Excel Analytics Courses
1. 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
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
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
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
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
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
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
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
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
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)
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
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
"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
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
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
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.
Recent Posts
How to reduce workplace stress and boost employees’ mental health
Any type of job can have stressful elements, even if you love what you do. In the short-term, you may experience pressure to meet a ...Read more
Most in-demand IT Skills for the Future of Work
The world is moving too fast and the old skills are replaced with modern digital skills. Information technology (IT) is becoming an important part of ...Read more
Benefits of Earning your Degree from a Liberal Arts College
Many people are questioning the value of a college education after a decade of sluggish economic development and rising college tuition rates. Undergraduates are increasingly ...Read more
How to Write a Marketing Email: 7 Tips to Write Compelling Email Copy?
In the past few years, the trend of email marketing has increased quite a lot. Most of the brands are utilizing fancy functionality and emphasizing ...Read more
What is AWS: Introduction to Amazon Cloud Services
One of the most comprehensive and globally adopted platforms, AWS offers more than 200 featured services. This makes it among the biggest e-commerce businesses in ...Read more
