Master Microsoft Excel from absolute zero! This is your full beginner tutorial to master spreadsheets. Forget the overwhelm, we'll get you confident and proficient in just a couple of hours.
Important Links
- Lecture Notes: https://github.com/JovianHQ/notebooks/blob/main/sql-and-business-intelligence/lesson-5-data-analysis-visualization-excel/lesson-5-data-analysis-visualization-excel.ipynb
- Excel Workbook: https://raw.githubusercontent.com/JovianHQ/notebooks/refs/heads/main/sql-and-business-intelligence/lesson-5-data-analysis-visualization-excel/ExcelDataAnalysisWorkbook.xlsx
- Italy Covid Dataset CSV: https://raw.githubusercontent.com/JovianHQ/notebooks/refs/heads/main/sql-and-business-intelligence/lesson-5-data-analysis-visualization-excel/italy-covid-daywise.csv
- Locations CSV: https://raw.githubusercontent.com/JovianHQ/notebooks/refs/heads/main/sql-and-business-intelligence/lesson-5-data-analysis-visualization-excel/locations.csv
Topics Covered:
00:00:00 Introduction and User Interface
00:14:38 Data Entry and Formatting
00:30:06 Using Excel for Calculations
00:41:30 Autocompleting a Series
00:46:08 Built-In Mathematical Functions
00:57:07 String Manipulation
01:02:57 Date and Time Functions
01:10:59 VLOOKUP for Searching Tables
01:17:21 CSV Imports and Data Analysis
01:39:37 Pivot Tables
01:50:34 Graphs and Data Visualization
02:07:01 Data Validation and Dropdowns
02:14:01 Conditional Formatting
02:18:07 Merging Data from Cells
02:22:49 Merging Multiple Cells
02:25:03 Cloud Spreadsheets for Collaboration
02:28:09 Summary
Learn more topics and earn a certificate for this course: https://jovian.com/learn/sql-and-business-intelligence
