Data Analysis and Forecasting in Excel

4.8( 10 REVIEWS )

351 STUDENTS

Course Overview

You’ll have an arsenal of skills to lock down your desired career after completing this Data Analysis and Forecasting in Excel course. Moreover, you will have access to all of the materials in this course for free for a whole year and learn a multitude of highly coveted skills to move up the corporate ladder.

With this comprehensive Data Analysis and Forecasting in Excel course, you’ll have all of your questions answered and all of the necessary expertise under your belt. Apart from setting you up for success, this course offers numerous advantages to make your learning experience more pleasurable and less stressful. So, add this Data Analysis and Forecasting in Excel course to the basket and take your expertise up a notch!

Please Note: Thames College is a One Education approved resale partner for Quality Licence Scheme Endorsed courses.

Why Choose Thames College?

Thames College offers you the benefit of —

Who Is This Course For?

Those who want to strengthen their professional skills while training for the desired job should take advantage of the Data Analysis and Forecasting in Excel training! This course will keep you up-to-date with all the latest developments and coach you accordingly. So invest in this Data Analysis and Forecasting in Excel course if you want the best training available.

Certificate of Achievement

CPD Certification

After successfully completing the assessment of this Data Analysis and Forecasting in Excel course, you can apply for the CPD accredited certificates. The PDF version is only £2.99 and the Hardcopy version will cost you £8.99.

Requirements

No formal entry requirements! No prerequisites or relevant experience is required!

This course is accessible to anyone with an eagerness to learn. All you require is—

Career Path

Utilise this all-inclusive course to acquire the skills and expertise you’ll need to thrive in the workplace.

Course Curriculum

Data Analysis and Forecasting in Excel
Modifying a Worksheet
	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
Working with Lists
	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
Analyzing Data
	Apply Intermediate Conditional Formatting	00:07:00
	Apply Advanced Conditional Formatting	00:05:00
Visualizing Data with Charts
	Create Charts	00:13:00
	Modify and Format Charts	00:12:00
	Use Advanced Chart Features	00:12:00
Using PivotTables and PivotCharts
	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
Working with Multiple Worksheets and Workbooks
	Use Links and External References	00:12:00
	Use 3-D References	00:06:00
	Consolidate Data	00:05:00
Using Lookup Functions and Formula Auditing
	Use Lookup Functions	00:12:00
	Trace Cells	00:09:00
	Watch and Evaluate Formulas	00:08:00
Automating Workbook Functionality
	Apply Data Validation	00:13:00
	Search for Invalid Data and Formulas with Errors	00:04:00
	Work with Macros	00:18:00
Creating Sparklines and Mapping Data
	Create Sparklines	00:07:00
	MapData	00:07:00
Forecasting Data
	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