
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 |
Take control of your email management and organization like never before with The Complete Microsoft Outlook Masterclass. This comprehensive course …
1
Streamline your email management with powerful strategies that make Outlook work for you! In the Outlook Tips and Tricks course, …
1
Unlock the essentials of Microsoft Access for Beginners and discover how to efficiently manage data in a structured database environment. …
1
$427.70 Original price was: $427.70.$27.30Current price is: $27.30. ex Vat