Become an expert in data analysis and master Excel to stand out to prospective employers, with this step-by-step training course.
Split in 10 in-depth modules, the Data Analysis, Automating and Visualisation in Excel course is designed for learners of all levels, covering the very basics to more complex areas of data analysis. It will guide you key topics such as through how to automate workbook functionality, forecast data and work with multiple worksheets and workbooks, as well as how to visualise data with charts.
Master data analysis in Excel online and add a new qualification to your CV to fast track your career!
Why buy this Data Analysis, Automating and Visualisation in Excel?
- Unlimited access to the course for forever
- Digital Certificate, Transcript, student ID all included in the price
- Absolutely no hidden fees
- Directly receive CPD accredited qualifications after course completion
- Receive one to one assistance on every weekday from professionals
- Immediately receive the PDF certificate after passing
- Receive the original copies of your certificate and transcript on the next working day
- Easily learn the skills and knowledge from the comfort of your home
After studying the course materials of the Data Analysis, Automating and Visualisation in Excel you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8.
Who is this course for?
This Data Analysis, Automating and Visualisation in Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.
This Data Analysis, Automating and Visualisation in Excel was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.
As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Data Analysis, Automating and Visualisation in Excel is a great way for you to gain multiple skills from the comfort of your home.
|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:05:00|
|Visualizing Data with Charts|
|Modify and Format Charts||00:12:00|
|Use Advanced Chart Features||00:12:00|
|Using PivotTables and PivotCharts|
|Create a PivotTable||00:13:00|
|Analyze PivotTable Data||00:12:00|
|Present Data with PivotCharts||00:07: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:12:00|
|Watch and Evaluate Formulas||00:08: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:08:00|
|Determine Potential Outcomes Using Scenarios||00:09:00|
|Use the Goal Seek Feature||00:04:00|
|Forecasting Data Trends||00:05:00|
|Assignment – Data Analysis, Automating and Visualisation in Excel||00:00:00|