EXCEL TIME SERIES ANALYSIS
Learning Path | 19 Course Series
This Time Series Analysis and Forecasting with Excel includes 19 courses with 60+ hours of video tutorials and One year access. You get to learn forecasting models and methods in Excel with this practical training from scratch.
Offer ends in:
What you'll get
- 60+ 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: 60++ 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 15m ✔ MS Excel Shortcuts 8h 22m ✔ -
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
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]
This course is simple and easy to understand. Henceforth, I learned a lot about Pivot Tables, Pivot Charts, and Slicers from this. The person discussing is straight to the point. He does not use a lot of confusing words. He is clear and precise on the discussion. This is best for beginners such as I. I have never created Pivot Tables, Pivot Charts, or Slicers before, but after completing this course, I am confident in creating all of those.
Jasmin Charlotte A. Poblacion
The ability to build simple-to-read and highly insightful dashboards in excel is a necessity for any data analyst or business intelligence professional worth their salt. I recommend this short course to anyone out there trying to start learning how to build interactive dashboards in excel. Learn with ease and fun. Thank me later!
Joel Baidoo
Easy environment and objective teaching.
Marcus Vinicius de Sant Anna Agnelli
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