Session 1 "Offline"

"(Module One) You will learn about the basics of spreadsheets, including spreadsheet terminology,






the interface and navigating around worksheets and workbooks.













(Module Two) You will learn about selecting data, entering an editing data, copying and






auto filling data, formatting data, and using functions and formulas."

Session 2 "Online"

"(Module Three) You will learn about cleaning and wrangling data using a spreadsheet, including






the fundamentals of data quality and data privacy, removing duplicated and inaccurate






data, removing empty rows, removing data inconsistencies and white spaces, and using the flash fill






and text to columns features.













(Module Four) You will study data structures and relationships"

Session 3 "Online"

"(Module Five) You will learn about analyzing data using spreadsheets, including filtering



data, sorting data, using common data analysis functions, creating and using pivot tables,



and creating and using slicers and timelines.







Data Analyst as a career"

Session 4 "Online"

"Module1: Connect and organize your data


Module2: Create data cleansing processes in Power BI


Module3: Organize your data model"

Session 5 "Offline"

"Module4: DAX Basics


Module5: Build Interactive Reports


Module6: Deploy and share your solution


Module7: Kaggle & final project requirements"

Session 6 "Offline"

"Recapping


Project presentation"