Data Analysis and Forecasting in Excel

Description

This comprehensive course on Data Analysis and Forecasting in Excel will deepen your understanding on this topic.

After successful completion of this course you can acquire the required skills in this sector. This Data Analysis and Forecasting in Excel comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market.

So enrol in this course today to fast track your career ladder.

You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate.

There is no experience or previous qualifications required for enrolment on this Data Analysis and Forecasting in Excel. It is available to all students, of all academic backgrounds.

Our Data Analysis and Forecasting in Excel is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.

There is no time limit for completing this course, it can be studied in your own time at your own pace.

Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to-

And much more!

10 sections • 31 lectures • 04:43:00 total length

•Insert, Delete, and Adjust Cells, Columns, and Rows: 00:10:00

•Search for and Replace Data: 00:09:00

•Use Proofing and Research Tools: 00:07:00

•Sort Data: 00:10:00

•Filter Data: 00:10:00

•Query Data with Database Functions: 00:09:00

•Outline and Subtotal Data: 00:09:00

•Apply Intermediate Conditional Formatting: 00:07:00

•Apply Advanced Conditional Formatting: 00:05:00

•Create Charts: 00:13:00

•Modify and Format Charts: 00:12:00

•Use Advanced Chart Features: 00:12:00

•Create a PivotTable: 00:13:00

•Analyze PivotTable Data: 00:12:00

•Present Data with PivotCharts: 00:07:00

•Filter Data by Using Timelines and Slicers: 00:11:00

•Use Links and External References: 00:12:00

•Use 3-D References: 00:06:00

•Consolidate Data: 00:05:00

•Use Lookup Functions: 00:12:00

•Trace Cells: 00:09:00

•Watch and Evaluate Formulas: 00:08:00

•Apply Data Validation: 00:13:00

•Search for Invalid Data and Formulas with Errors: 00:04:00

•Work with Macros: 00:18:00

•Create Sparklines: 00:07:00

•MapData: 00:07:00

•Determine Potential Outcomes Using Data Tables: 00:08:00

•Determine Potential Outcomes Using Scenarios: 00:09:00

•Use the Goal Seek Feature: 00:04:00

•Forecasting Data Trends: 00:05:00