Data Analysis Training using MS Excel

• Educational Background: There are no prerequisites for this course; however, familiarity with basic Excel functions and a general understanding of data concepts will be beneficial. 

• Language Proficiency: A good command of English is essential, as all instructional materials, exercises, and assessments are in English. 

• Interest in Data Analysis: This course is ideal for professionals and individuals with a keen interest in harnessing MS Excel to enhance their data analysis capabilities. 

• Utilise Advanced Excel Features: Learn to work with functions such as PivotTables, advanced formulas, and data validation to manipulate and analyse data effectively. 

• Data Visualisation Skills: Develop the ability to create impactful charts, graphs, and dashboards that communicate data insights clearly and professionally. 

• Data Cleaning and Management: Acquire techniques for cleaning datasets, handling missing data, and ensuring data integrity for accurate analysis. 

• Interpret Data for Decision-Making: Master the skills to analyse trends, forecast outcomes, and draw actionable insights using MS Excel tools. 

• Optimise Workflow: Discover methods to automate repetitive tasks and streamline data analysis processes using macros and other advanced Excel features. 

The Data Analysis Training Using MS Excel is suitable for professionals and learners aiming to enhance their proficiency in data-driven decision-making. This includes: 

• Business Analyst 

• Data Analyst 

• Operations Manager 

• Financial Analyst 

• Project Manager 

• Administrative Professional 

• Marketing Analyst 

• HR Professional  

Module 1: Overview of Data Analysis 

• What is Data Analysis? 

• Why Data Analysis? 

• Types of Data Analysis 

• Data Analysis Process
   

Module 2: Introduction to Data Analysis with MS Excel 

• Introduction to Excel Data Analysis 

• Data Cleaning 

• Data Analysis 

• Data Visualisation
   

Module 3: Excel Ribbon and Importing Data into Excel 

• Excel Ribbons 

• Importing Data into Excel
   

Module 4: Work with Range Names 

• Steps to Create Range Name 

• How to Rename Range Name? 

• How to Delete Range Name? 

• Use Name Range in Workbook
   

Module 5: Introduction to Tables 

• What is a Table? 

• What is the Purpose of Creating a Table?
   

Module 6: Cleaning Data with Text Functions 

• Removing Unwanted Characters from the Text 

• Steps for Data Cleaning

•  

Module 7: Working with Date Formats and Time Formats 

• Steps to Change Data Format 

• Steps to Change Time Format
   

Module 8: Conditional Formatting in Excel 

• What is Conditional Formatting and How to Use It? 

• Apply Conditional Formatting on Text
   

Module 9: Sorting and Filtering Data Columns 

• What is Sorting and Filtering? 

• Sort a Particular Column 

• Applying Sorting on Two Columns 

• Steps to Sort Dates 

• Clear Filter 

• Apply Filter on Text 

• Apply Filter by Cell Icon
   

Module 10: Subtotals and Quick Analysis 

• Subtotals 

• Steps to Apply Subtotals 

• Quick Analysis 

• Steps to Use Quick Analysis
   

Module 11: Working with Multiple Sheets 

• Worksheet Tab 

• Viewing Multiple Worksheets at Once 

• Grouping Your Worksheets Together 

• Steps to Rename a Worksheet 

• Steps to Move/Copy a Worksheet 

• Steps to Delete a Worksheet
   

Module 12: Data Validation 

• What is Data Validation? 

• How to Use Data Validation? 

• Using Data Validation?
   

Module 13: Data Visualisation 

• What is Data Visualisation? 

• Using Charts in Excel 

• All Charts in Excel
   

Module 14: Exploring Lookup Functions 

• Lookup Function 

• VLOOKUP and HLOOKUP 

• INDEX Function 

• MATCH Function
   

Module 15: Pivot Tables 

• PivotTable Overview 

• Creating a PivotTable in MS Excel 

• Recommended PivotTables 

• PivotTable Fields 

• PivotTable Areas 

• Filters and Slicers 

• Summarising Values by Other Calculation 

• Using ANALYSE and DESIGN on the Ribbon
   

Module 16: What If Analysis 

• What If Analysis 

• What If Analysis with Data Tables 

• What If Analysis with Scenario Manager 

• What If Analysis with Goal Seek