Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
Learn new skills and develop your proficiency with data analysis and learn from home at a pace that suits you. This Data Analysis has been designed for you to complete through distance e-learning and achieve a proficient lesson all without leaving your own home!
Once you enrol on the Data Analysis, you will have full course access for one year, meaning you are free to complete the Data Analysis at a pace that suits you. Enrol on Data Analysis now and start studying using any internet-enabled device, including computers, tablets, and smartphones.
With 24/7 student support offered to you on data analysis, you can be sure of quick and comprehensive assistance whenever you need it.
Enrol now in Data Analysis and get access to top-quality training modules which will cover the essential topics you need to excel in your chosen field and help push you towards your dream job!
Who Is This Course For?
The data analysis has been efficiently designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with this data analysis.
Enrol in Data Analysis and learn a new skill from anywhere, at any time!
Enrol on the Data Analysis with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register for Data Analysis without any delay.
We only ask that all students have a passion for learning and literacy and be over the age of 16. Complete the data analysis online from your computer, tablet, or smartphone, and learn in a way that suits you.
We offer an integrated assessment framework to make the process of evaluating learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment.
You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams.
Endorsed Certificate of Achievement from the Quality Licence Scheme
After successfully completing the (Course Title) course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of —
Certificate Accredited by CPD
Upon finishing the (Course Title) course, you need to order to receive a Certificate Accredited by CPD that is recognised all over the UK and also internationally. The pricing schemes are —
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:06:00 | ||
Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features1 | 00:12: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 | 2 weeks, 1 day | ||
Certificate | |||
Order Your Certificate | 00:00:00 |
3672
4.3
£25