Meetings
Requirements
- Users with basic Excel knowledge and those that have completed Starting My Excel Journey.
Description
Total Contact period: 13.5 hours
Module 1: Productivity Shortcuts and Week 1: 4.5 hours of Lecture time
Lesson 1.1: Navigation Shortcuts That Save Hours
- Ctrl+Home, Ctrl+End, Ctrl+Arrow keys
- F5 (Go To) for large spreadsheets
- Ctrl+G for named ranges
- Practice: Navigate 10,000-row employee database
Lesson 1.2: Selection Shortcuts for Power Users
- Ctrl+Shift combinations for range selection
- Shift+Click for extended selections
- Ctrl+A for all data selection
- Practice: Select data ranges in financial statements
Lesson 1.3: Formatting Shortcuts
- Ctrl+1 for Format Cells dialog
- F4 to repeat last action
- Format Painter shortcuts
- Practice: Format annual budget in under 2 minutes
Lesson 1.4: Formula & Function Shortcuts
- F2 to edit formulas
- Alt+= for AutoSum
- Ctrl+Shift+Enter for array formulas
- Practice: Build calculations efficiently
Lesson 1.5: Copy, Paste & Fill Shortcuts
- Ctrl+D (fill down), Ctrl+R (fill right)
- Paste Special shortcuts
- Ctrl+Enter to fill multiple cells
- Practice: Complete quarterly projections
Module 2: Advanced Functions and Week 2: 4.5 hours of Lecture time
Lesson 2.1: Logical Functions - IF, AND, OR
- IF function for conditional calculations
- Nested IF statements
- AND/OR for complex conditions
- Practice: Employee bonus calculator
Lesson 2.2: Text Functions - CONCATENATE, LEFT, RIGHT, MID
- Combining text from multiple cells
- Extracting parts of text strings
- UPPER, LOWER, PROPER functions
- Practice: Format customer names and addresses
Lesson 2.3: Date Functions - TODAY, NOW, DATEDIF
- Working with current dates
- Calculating differences between dates
- Age and tenure calculations
- Practice: Employee service record system
Lesson 2.4: Lookup Functions Introduction - VLOOKUP
- Basic VLOOKUP syntax and usage
- Exact match lookups
- Common VLOOKUP errors and fixes
- Practice: Product price lookup system
Module 3: Data Management Shortcuts and Week 3: 4.5 hours of Lecture time
Lesson 3.1: Advanced Filtering & Sorting
- Custom sort orders
- Multi-level sorting
- Advanced filter criteria
- Practice: Complex sales data analysis
Lesson 3.2: Quick Data Analysis Tools
- Quick Analysis tool overview
- Instant charts and formatting
- Conditional formatting shortcuts
- Practice: Sales performance dashboard
Lesson 3.3: Table Shortcuts & Features
- Converting ranges to tables (Ctrl+T)
- Table column shortcuts
- Structured references in formulas
- Practice: Dynamic expense tracking table
Lesson 3.4: Worksheet Management Shortcuts
- Adding, deleting, renaming sheets
- Moving between worksheets
- Grouping and ungrouping sheets
- Practice: Multi-sheet budget workbook
Course 2 Final Project and Week 4: Students to submit finished project
- Build a complete sales dashboard using only shortcuts
- Timed challenge: Complete in under 20 minutes
- Performance tracking and efficiency metrics
Frequently Asked Question
MasterOneSkill (masteroneskill.com) is a Nigerian digital skills e-learning platform that trains individuals across Africa to acquire in-demand skills so they can earn real income in the digital economy.
MasterOneSkill is built for anyone in Nigeria or Africa who wants to build a profitable digital skill, whether you're a fresh graduate, career switcher, stay-at-home parent, side hustler, or entrepreneur. No prior tech experience is required for most courses.
Most courses can be accessed on a smartphone. However, for practical courses that involve tools, software, or file creation, a laptop or desktop will give you the best learning experience.
MasterOneSkill offers both free introductory content and paid full courses. Paid courses are priced to be affordable for the Nigerian market, with no hidden fees.
About Instructor
About Instructor
Beloved is a seasoned professional with 22 years of work experience, 18 of which have been devoted to teaching both offline and online. In the past 7 years, I have focused on online teaching, using my extensive knowledge and skills to deliver high-quality lessons to students all around the world. I have developed a reputation for being a skilled and knowledgeable teacher with a unique ability to engage and motivate students of all ages and backgrounds.
