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:
No formal entry requirements. You need to have:
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.
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.
|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|
|Query Data with Database Functions||00:09:00|
|Outline and Subtotal Data||00:09:00|
|Apply Intermediate Conditional Formatting||00:07:00|
|Apply Advanced Conditional Formatting||00:06:00|
|Visualizing Data with Charts|
|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|
|Using Lookup Functions and Formula Auditing|
|Use Lookup Functions||00:13: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|
|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|
No Reviews found for this course.