Review.io
  • user_iconLOGIN
  • cart_icon

    No products in the basket.

 bg side img
Data Analysis In Excel

Data Analysis In Excel

£25 SALE ENDS SOON TAKE THIS COURSE

OR

All Courses for £49
  • premium course icon3000+ Premium Courses
  • 500+500K+ Learners
  • cpd uk
  • qls
  • fully online

    Fully Online

BLACK FRIDAY DEAL! UNLIMITED ACCESS To 3000+ COURSES For Only £99. Claim Offer

The Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement.

Learning Outcomes

Description

From business to research, having a solid grasp of Excel Data analysis can open doors of opportunity in various industries. Learn this valuable skill set from the comfort of your home with the Data Analysis In Excel course. This course will introduce you to the ins and outs of Excel data analysis.

This Data Analysis In Excel course will help you establish a solid foundation in Excel data analysis. This course will help you pick up the skills to visualise data with charts in Excel. Here, you will also learn about Pivot Tables and Charts. Furthermore, the course will teach you how to work with multiple Workbooks. In addition, you will learn about Lookup factions and how to use them. By the end of this course, you will know the essentials of automating Workbook functionality.

This course will assist you in securing effective data analysis skills. In addition, you will receive a QLS-endorsed certificate of achievement. This certificate will enhance your employability in the relevant job market. Join now! 

Certificate of Achievement

Endorsed Certificate of Achievement from the Quality Licence Scheme

Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £99. An extra £10 postage charge will be required for students leaving overseas. 

CPD Accredited Certificate

After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. 

Method of Assessment

At the end of the course, there will be an MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, it will be examined, and the results will be given to you immediately.

Career path

This course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as

Course Curriculum

Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:08: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:06:00
Visualizing Data with Charts
Create Charts 00:13:00
Modify and Format Charts 00:12:00
Use Advanced Chart Features 00:13:00
Using PivotTables and PivotCharts
Create a PivotTable 00:13:00
Analyze PivotTable Data 00:12:00
Present Data with PivotCharts 00:08: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:06:00
Using Lookup Functions and Formula Auditing
Use Lookup Functions 00:13:00
Trace Cells 00:09:00
Watch and Evaluate Formulas 00:09: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:09:00
Determine Potential Outcomes Using Scenarios 00:09:00
Use the Goal Seek Feature 00:04:00
Forecasting Data Trends 00:06:00
Assignment
Assignment – Data Analysis In Excel 2 weeks, 1 day
Order your Certificates & Transcripts
Order your Certificates & Transcripts 00:00:00

Course Reviews

4.6

4.6
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

1818 STUDENTS ENROLLED

Certifications

Get accredited certificates

New skills

Add skills to your CV

Exams

Test your skills

Dedicated support

For any questions

Set your own speed

No time limitations

Money back guarantee

Refund upon learner's dissatisfaction

Home Search Cart Your Offers