No products in the cart.
EXTENDED OFFER ENDS IN
Master the skill of Microsoft Excel, manage your data, and boost your productivity. This Data Analysis in Excel course will take your Microsoft Excel skill to the next level.
This Data Analysis in Excel course teaches you from basic to advanced skills of Microsoft excel. You’ll learn to insert, delete, manipulate and analyse data, working with lists, data visualisation, pivot table, pivot charge, multiple worksheets, workbook maintenance, forecasting data. This course will make you work-ready from zero.
This course is ideal for anyone working as data analysts, data entry technicians, quality occurrence testers, bookkeepers, marketing strategists, workplace coordinators, cloud account specialists, HSE officials, or anyone working in the corporate sector.
Why Choose Teachers Training
Some of our features are:
- This is a dedicated website for teaching
- 24/7 tutor support
- Interactive Content
- Affordable price
- Courses accredited by the UK’s top awarding bodies
- 100% online
- Flexible deadline
Entry Requirements
No formal entry requirements. You need to have:
- Passion for learning
- A good understanding of the English language
- numeracy and IT
- Desire for entrepreneurship
- over the age of 16.
Assessment
The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.
After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate.
Certification
CPD Certification from The Teachers Training
Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish.
- You can get your digital certificate (PDF) for £4.99 only
- Hard copy certificates are also available, and you can get one for only £10.99
- You can get both PDF and Hard copy certificates for just £12.99!
The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs.
Course Curriculum
| 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 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 | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Review
COURSE REVIEWS
Course Reviews
No Reviews found for this course.
Related Courses
Construction Cost Estimation
£24.99
Recruitment Consultant
£24.99
