Introduction:
Basics of Excel and Google Sheets, Interface Overview, Differences and Similarities, Use Cases and Applications
Basic Operations:
Data Entry and Formatting, Rows, Columns, Cells, Copy, Paste, Cut, Fill Handle, Basic Navigation and Shortcuts
Formatting:
Number, Date, Time Formatting, Cell Styles and Themes, Conditional Formatting, Custom Formatting
Formulas and Functions:
Arithmetic Operators and Order of Operations, Basic Functions: SUM, AVERAGE, MIN, MAX, COUNT, Cell Referencing (Relative, Absolute, Mixed), AutoSum and Quick Calculations
Intermediate Formulas:
IF, IFS, AND, OR, NOT
TEXT Functions (LEFT, RIGHT, MID, LEN, CONCATENATE)
DATE Functions (TODAY, NOW, DATEDIF, EOMONTH)
ROUND, ROUNDUP, ROUNDDOWN, INT, MOD
Advanced Formulas:
VLOOKUP, HLOOKUP, XLOOKUP
INDEX and MATCH
ARRAYFORMULA (Google Sheets)
INDIRECT, OFFSET
IFERROR, ISERROR, ISBLANK
Data Handling & Validation:
Data Validation and Drop-down Lists,
Remove Duplicates,
Find & Replace, Go To Special,
Flash Fill and Smart Fill (Google Sheets)
Sorting and Filtering:
Basic Sorting and Filtering, Custom Sort and Filter, Advanced Filters and Slicers (Excel)
Filter Views (Google Sheets)
Charts and Graphs:
Creating Bar, Column, Pie, Line Charts,
Chart Customization
Sparklines (Excel)
Chart Editor (Google Sheets)
Pivot Tables and Dashboards:
Creating Pivot Tables,
Group, Summarize, Filter in Pivots,
Pivot Charts,
Simple Dashboards with Slicers and Charts.
Collaboration & Sharing:
Sharing and Permissions (Excel Online, Google Sheets)
Comments, Notes, Version History,
Protected Ranges and Sheets,
Real-Time Collaboration
Pivot Tables and Dashboards:
Basic Macros (Excel),
Google Apps Script (Google Sheets),
Import/Export Data,
Linked Data Types and Power Query
