LOGIN/Sign up
3000+ Premium Courses 
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
- Understand the basic principles of data analysis with Excel
- Learn how to visualise data with Excel charts
- Build your expertise in using Pivot Tables and Charts
- Grasp the techniques of working with multiple Worksheets and Workbooks
- Know the process of automating Workbook functionality
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
- Data Analyst
- Research Assistant
- Researcher
- Business Analyst
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
No Reviews found for this course.
Related Courses
