Course Content
Module 1: Introduction & Interface
0/2
Video 1: Course Overview & Key Differences (Benefits of each platform)
02:00
Video 2: Interface Navigation, Basic Operations, & Keyboard Shortcuts (Creating spreadsheets, cell manipulation)
00:00
Module 2: Data Entry & Formatting
0/4
Video 3: Data Types, Number Formats, Text Handling
05:00
Video 4: AutoFill, Copying/Pasting, Cell Formatting, & Cell Reference (Alignment, fonts, borders, Linking, )
08:00
Video 5: Conditional Formatting for Visual Rules & Data Highlighting
13:00
Video 6: Data Validation for Input Accuracy & Integrity
11:00
Module 3: Formulas & Functions
0/9
Video 7: Essential Formulas (SUM, AVERAGE, COUNT)
10:00
Video 8: Lookup Functions (HLOOKUP, VLOOKUP, INDEX MATCH) for Data Retrieval
08:00
Video 9: Date & Time Functions for Calculations & Date Manipulation
11:00
Video 10: Logical Functions (AND, OR, NOT) for Conditional Decision-Making
12:00
Video 11: IF Statements & Nested IFs (Basic & Advanced Scenarios)
09:00
Video 12: Financial Functions (PV, PMT, FV) for Loan & Investment Calculations
10:00
Video 13: Text Functions (LEFT, RIGHT, CONCATENATE) for String Manipulation
07:00
Video 14: Statistical Functions (AVERAGEIF, COUNTIF) for Filtering & Conditional Calculations
11:00
Video 15: Advanced Functions (SUMIFS, COUNTIFS) for Complex Data Analysis
10:00
Module 4: Charting & Data Visualization
0/4
Video 16: Chart Types & Selection Based on Data & Goals
10:00
Video 17: Chart Customization (Legends, Labels, Data Series Formatting)
08:00
Video 18: Charting Best Practices for Clear & Effective Communication
08:00
Video 19: Interactive Charts with Filters & Slicers (Excel)
09:00
Module 5: Working with Large Datasets & PivotTables
0/3
Video 20: Sorting & Filtering Data for Focused Analysis
11:00
Video 21: Advanced Filtering Techniques (Advanced Filters, PivotTable Filters)
10:00
Video 22: Introduction to basic and advanced PivotTables (Creating Layouts, Summarizing Data, calculating fields, Filtering, Slicers)
09:00
Module 6: Collaboration & Google Sheets
0/4
Video 23: Transitioning from Excel to Google Sheets (Interface Similarities & Differences)
05:00
Video 24: Collaborative Editing in Google Sheets (Sharing, Permissions, Version History)
11:00
Video 25: Real-Time Collaboration & Chat Features in Google Sheets
13:00
Video 26: Usage of Add-ons & Extensions for Google Sheets
08:00
Module 7: Data Import & Export
0/3
Video 27: Exporting and Importing Data from Various Sources (Text Files, CSV, PDF, Excel)
13:00
Video 28: Working with Google Sheets Offline & Syncing Changes
13:00
Video 29: Connecting Google Sheets to External Data Sources (Databases, Web Services)
05:00
Module 8: Macros & Automation
0/3
Video 30: Introduction to Macros (Recording Simple Macros, VBA Basics)
10:00
Video 31: Automating Repetitive Tasks with Macros (Excel)
11:00
Video 32: Google Apps Script Basics for Automating Tasks in Google Sheets
12:00
Module 9: Printing Layouts & Best Practices
0/3
Video 33: Overview of Printing Layouts (Margins, Page Orientation, Page Breaks)
10:00
Video 34: Adjusting Page Setup & Scaling for Optimal Printing
12:00
Video 35: Headers, Footers, & Watermarks for Professional Printouts
05:00
Module 10: Get Hands on Some Useful & Real Life Projects
0/1
Video 36: [Project] and useful tips and tricks
12:00
Excel & Google Sheets Course for Corporate Jobs in Bangladesh
Previous
Next
0% Complete