Unlock the power of data analysis with Microsoft Excel and gain valuable insights that drive decision-making. This course, Data Analysis in Excel, equips you with essential data analysis methods to transform raw numbers into meaningful patterns. Whether you’re a beginner or looking to enhance your Excel proficiency, this training offers practical tools to elevate your analytical abilities.
Master data analysis courses covering everything from modifying worksheets to forecasting trends. Learn what data analysis entails, explore essential functions like PivotTables, and visualise information using dynamic charts. By applying the right data analysis method, you can make data-driven decisions with confidence.
Boost your career prospects with Excel-based analytics. With data analyst pay increasing in demand, this course sets the foundation for roles requiring expertise in data analysis methods. Gain confidence in handling large datasets, optimising workflows, and delivering compelling insights.
After studying the course materials of the Data Analysis In Excel there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60.
This Data Analysis In Excel does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analysis 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.
| 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:05:00 | ||
| Visualizing Data with Charts | |||
| Create Charts | 00:13:00 | ||
| 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 | ||
| Consolidate Data | 00:05:00 | ||
| Using Lookup Functions and Formula Auditing | |||
| Use Lookup Functions | 00:13:00 | ||
| Trace Cells | 00:09: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 | |||
| Create Sparklines | 00:07:00 | ||
| MapData | 00:07:00 | ||
| Forecasting 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 | ||
| Recommended Materials | |||
| Workbook – Data Analysis in Excel | 00:00:00 | ||
Step into the world of cloud applications with confidence through the Salesforce Heroku Masterclass, a structured guide to understanding one …
2
Overview Learn about from industry experts and boost your professional skill. This course will enhance your skill and make you ready …
3
In the ever-evolving digital landscape, the ability to understand, identify, and secure vulnerabilities in a Web Application has never been …
1
$557.70 Original price was: $557.70.$26Current price is: $26. ex Vat
Level: Intermediate
Duration: 4 hours, 44 minutes
Students: 1



