LOGIN
No products in the basket.

Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.

Sign in to your One Education account

Data Analysis and Forecasting in Excel

For You
For Business

Data Analysis and Forecasting in Excel

Original price was: £425.Current price is: £29. ex Vat

Save 93.18 % - ENDS SOON

Days

Hours

Minutes

Seconds

Take This Course

Take All courses for £49

1 Year Access
Intermediate
99 Students
4 hours, 43 minutes

Share Link on

£25.00 /Unit Price

£250

Quantity:

Add to Cart

Looking for a more personalised package?

Get access to 5000+ courses including this for only £49.

Overview

The Data Analysis and Forecasting in Excel is the best way for you to gain deep insight and knowledge of this topic. You will learn from industry experts and obtain an accredited certificate after completing the course. Enrol now for a limited-time discounted price.

Like all the courses of One Education, this Data Analysis and Forecasting in Excel is designed with the utmost attention and thorough research. All the topics are broken down into easy to understand bite-sized modules that help our learners to understand each lesson very easily.

We don’t just provide courses at One Education; we provide a rich learning experience. After purchasing a course from One Education, you get complete 1-year access with tutor support.

Our expert instructors are always available to answer all your questions and make your learning experience exquisite.

After completing the Data Analysis and Forecasting in Excel, you will instantly get an e-certificate that will help you get jobs in the relevant field and will enrich your CV.

If you want to learn about this topic and achieve certifications, simply enrol this Data Analysis and Forecasting in Excel from One Education.

Why People Love and Enrol in The Data Analysis and Forecasting in Excel from One Education

Instantly accessible CPD-accredited certificate on successful completion of this Data Analysis and Forecasting in Excel
24/7 access to the course for 12 months
Study at your own pace
No hidden fees or exam charges
Full Tutor support on weekdays (Monday – Friday)
Efficient assessment and instant results

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hard Copy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The Data Analysis and Forecasting in Excel is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

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
Order Your Certificate
	Order Your Certificate Now	00:00:00

top

Skills

Certificate Code

Important Links

With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.