EXCEL TIME SERIES ANALYSIS
Learning Path | 19 Course Series
This Time Series Analysis and Forecasting with Excel includes 19 courses with 59+ hours of video tutorials and One year access. You get to learn forecasting models and methods in Excel with this practical training from scratch.
MOST POPULAR
* One Time Payment & Get One year access
Offer ends in:
What you'll get
- 59+ Hours
- 19 Courses
- Course Completion Certificates
- One year access
- Self-paced Courses
- Technical Support
- Mobile App Access
- Case Studies
Synopsis
- Courses: You get access to all 19 courses in the Projects bundle. You do not need to purchase each course separately.
- Hours: 59++ Video Hours
- Core Coverage: This course's main aim is to teach students how to use Microsoft Excel for real forecasting and time series analysis.
- Course Validity: One year access
- Eligibility: Anyone serious about learning Time Series Analysis and Forecasting with Excel
- Pre-Requisites: Basic knowledge about Microsoft Excel
- What do you get? Certificate of Completion for each of the 19 courses, Projects
- Certification Type: Course Completion Certificates
- Verifiable Certificates? Yes, you get verifiable certificates for each course with a unique link. These links can be included in your resume/LinkedIn profile to showcase your enhanced skills.
- Type of Training: Video Course – Self-Paced Learning
Content
-
MODULE 1: EXCEL & Statistics Essentials Training
Courses No. of Hours Certificates Details Statistical Tools in Microsoft Excel 1h 11m ✔ Microsoft Excel for Data Analyst 2h 35m ✔ Gantt Chart Tutorials 58m ✔ Microsoft Excel Charts and SmartArt Graphics 6h 4m ✔ Power Excel Training 5h 12m ✔ MS Excel Shortcuts 8h 5m ✔ -
MODULE 2: Projects based Learning
Courses No. of Hours Certificates Details Pivot Table for Beginners 1h 28m ✔ Pivot Tables Hands-on! 2h 3m ✔ Data Analysis with Pivot Tables 4h 58m ✔ Power Pivot in Microsoft Excel 3h 31m ✔ Pivot Table Project - Problem Handling and Automation 1h 11m ✔ Working with Pivot Tables Presentation 3h 7m ✔ Pivot Table Case Study - Performance Ratings of Employees 1h 11m ✔ -
MODULE 3: Learning from Practicals & Case Studies
Courses No. of Hours Certificates Details MS Excel Simulations Training 2h 15m ✔ Business Intelligence using Microsoft Excel 5h 06m ✔ MS Excel Sales Productivity Dashboard 6h 41m ✔ Project - Building Dynamic Heat Map in Microsoft Excel 1h 15m ✔ MS Excel Sales Dashboard 1h 3m ✔ MS Excel Dashboard Training 5h 45m ✔
Description
- Time Series Analysis and Forecasting in Excel is the concept that deals with your data, whereas Excel helps us to forecast models. This methodology helps to prepare time series with various varieties of data in data series along with their related values.
- Multiple forecasting techniques are available using statistics. Some already exist in Microsoft Excel. This tutorial helps us deal with various time series analyses and forecasting using Excel methodologies.
Sample Certificate
Requirements
- For taking this course, you have simple things like:
- Basic Computer Knowledge
- Basic Knowledge of Excel/Spreadsheet
- The basic idea of Microsoft Office Work Environment
- Basic knowledge of Excel tools and functions
- Passion to learn and apply
- Advanced familiarity with the Excel 2016 interface
- Ability to apply basic formulas and functions
- This course fit for anyone who has the urge to learn applications of Excel
- No specific educational background or work experience is required
- A computer with internet to view training material
Target Audience
- The Target Audience will be anyone from the below stream:
- Commerce Students
- Anyone who wants to learn Excel simulation
- Students from Business Administration streams like BBA, MBA, etc
- Data Analysts
- Business Analysts
- Sales professionals
- Anyone who wants to learn the Pivot Table.
- Working professionals from any Business Domain.
- Entrepreneurs, Prospective Finance Analysts, Marketing Analysts, Research Analysts, Investment Bankers
Course Ratings
* One Time Payment & Get One year access
Offer ends in:
Training 5 or more people?
Get your team access to 5,000+ top courses, learning paths, mock tests anytime, anywhere.
Drop an email at: [email protected]
Great course for someone like me who's been using Excel everyday but didn't know about data analysis tool available in it. I've always have to open JMP for analysis even just for simple charting and correlation plotting. Now I know I can do that in Excel too. Thanks! 🙂
Michelle Esber
This was very exceptional never even thought i could gather this much. Thanks for this great opportunity.
OYEWOLE, DIMEJI YEMI
This course was great to attend and learn about Excel's "Data Analytics" add-in function!
Sumari Hattingh Van Niekerk
We learn about pivot tables, pivot charts and visualize the raw data by creating the dashboard. An Excel dashboard is a one pager (mostly, but not always necessary) that helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it. It contains charts/tables/views that are backed by data
Sami Haider