Course Overview
- Course Title: Microsoft Excel and Google Sheets for Data Analysis
- Instructor: Start-Tech Trainings
- Target Audience:
- Individuals looking to enhance data analysis skills
- Professionals needing to streamline work with spreadsheets
- Beginners to advanced users of Microsoft Excel and Google Sheets
- Prerequisites:
- PC with a working internet connection
Curriculum Highlights
- Key Topics Covered:
- Setting up MS Excel and Google Sheets
- Essential functions (mathematical, textual, logical, Lookup)
- Data visualization using charts and graphs
- Data analysis tools (Pivot tables, Filtering and sorting, Data formatting)
- Advanced topics (Indirect functions and Macros)
- Dynamically importing data from PDFs and websites
- Key Skills Learned:
- Knowledge of essential Microsoft Excel and Google Sheets functions
- Mastery of lookup functions (Vlookup, Hlookup, Index and Match)
- Proficiency in data tools (Sorting, Filtering, Data validations, Data importing)
- Creating Pivot tables with slicers
- Visual data representation using Bar charts, Scatter Plots, Histograms
- Conditional and Table formatting options
Course Format
- Duration: 11 hours on-demand video
- Format: Self-paced online course
- Resources:
- 18 articles
- 34 downloadable resources
- Access on mobile and TV
- Certificate of completion