Basic Microsoft Excel Course (30-Day Blueprint)
A comprehensive, structured 4-week daily learning roadmap. Master spreadsheet navigation, arithmetic formulas, cell references ($A$1), logical operators, charts, VLOOKUP basics, and capstone office projects with downloadable .xlsx practice files for each week.
Excel Fundamentals
1. Introduction to Microsoft Excel
Understanding the Excel workspace, Quick Access Toolbar, Ribbon tabs, workbook (.xlsx) vs. worksheet, grid structure (1,048,576 rows × 16,384 columns), Name Box, and the Formula Bar.
2. Data Entry and Editing
Entering text, numbers, dates, and times. Cell editing techniques (F2 shortcut), AutoFill handle, Flash Fill (Ctrl + E), Undo/Redo, and clearing cell contents vs formats.
3. Cell Formatting and Alignment
Font styles, font sizes, fill colors, borders (thin, double bottom), text alignment (Left, Center, Right, Top, Middle, Bottom), Wrap Text, and Center Across Selection.
4. Number, Date and Currency Formatting
Formatting numbers as Indian Rupees (₹#,##0.00), percentages (0.0%), decimal places (increase/decrease), and regional date conventions (DD-MMM-YYYY).
5. Rows, Columns and Cell Management
Inserting and deleting rows/columns, adjusting row heights and column widths, AutoFit column width shortcut (Alt + H + O + I), hiding and unhiding rows, and Freezing Header Panes.
6. Working with Worksheets
Adding new sheets, renaming, tab coloring, moving/copying sheets between workbooks, protecting worksheets, and keyboard shortcuts to navigate tabs (Ctrl + PgUp / PgDn).
7. Weekly Revision and Practical Test
Hands-on lab evaluation creating a complete, polished Office Inventory & Stock Register from scratch with proper formatting, frozen headers, and column autofit.
Practicing cell coordinates, rupee currency formats, text alignment, and freeze panes on row 4.
| Item Code | Product Description | Category | Stock Qty | Unit Price (₹) | Reorder Level |
|---|---|---|---|---|---|
| ITM-101 | A4 Copier Paper (500 sheets) | Stationery | 85 | ₹260.00 | 20 |
| ITM-103 | Wireless Optical Mouse | Electronics | 18 | ₹450.00 | 10 |
| ITM-107 | Spike Surge Protector 4-Way | Electrical | 5 | ₹420.00 | 6 |
Formulas and Calculations
8. Basic Excel Formulas
Writing formulas starting with =. Arithmetic operators: Addition (+), Subtraction (-), Multiplication (*), Division (/), and BODMAS operator precedence.
9. SUM and AVERAGE Functions
Mastering =SUM(range), AutoSum shortcut (Alt + =), non-contiguous summing (=SUM(A1, C1, E1)), and computing mathematical mean with =AVERAGE(range).
10. MIN, MAX, COUNT and COUNTA
Identifying highest values (=MAX()) and lowest values (=MIN()). Counting numbers with =COUNT(), non-empty cells with =COUNTA(), and blank cells with =COUNTBLANK().
11. Relative Cell References
Understanding relative cell behavior: how dragging a formula from row 5 (=C5*D5) automatically transforms to row 6 (=C6*D6), and when to utilize relative addressing.
12. Absolute and Mixed References ($A$1)
Mastering the dollar sign ($) anchor. Converting relative references to absolute ($A$1) using the F4 key. Locking tax rates, commission cells, and mixed references ($A1 vs A$1).
13. Percentage Calculations
Computing percentage of total (=Part / Total), percentage change (growth or decline: =(New - Old) / Old), discount deductions, and GST tax additions.
14. Formula Practice and Review
Comprehensive practical test: Building a multi-item Student Marksheet with rank metrics, and a Commercial Sales Billing Invoice with locked 18% GST tax rate.
| Item Description | Qty | Price (₹) | Subtotal | GST (18%) | Total Bill |
|---|---|---|---|---|---|
| Dell 24" IPS Monitor | 4 | ₹11,500.00 | ₹46,000.00 | =E5*$B$4 | ₹54,280.00 |
| Logitech Wireless Combo | 12 | ₹1,250.00 | ₹15,000.00 | =E6*$B$4 | ₹17,700.00 |
Logical Functions and Data Management
15. IF Function — Introduction
Syntax: =IF(logical_test, value_if_true, value_if_false). Logical operators (>, <, >=, <=, <>, =). Evaluating Pass/Fail or High/Low sales flags.
16. AND, OR and Multiple Conditions
Combining logical tests with =AND(cond1, cond2) (both must be TRUE) and =OR(cond1, cond2) (either can be TRUE). Building bonus eligibility rules.
17. Sorting Data
Single-column sorting (A to Z, Largest to Smallest), multi-level sorting (e.g. Sort by Branch first, then by Sales Descending), and avoiding disconnected sorting bugs.
18. Filtering Data
Activating AutoFilter (Ctrl + Shift + L). Text filters (Contains, Begins With), number filters (Greater Than, Top 10), and date filters (This Month, Last Quarter).
19. Find, Replace and Data Cleaning
Quick Find (Ctrl + F), Bulk Replace (Ctrl + H), removing trailing extra spaces with =TRIM(), and standardizing casing with =PROPER().
20. Excel Tables
Converting raw ranges into official Excel Tables (Ctrl + T). Benefits: dynamic auto-expanding ranges, structured formula references, banded rows, and automatic Total Row.
21. Conditional Formatting
Highlight Cells Rules (Greater Than, Equal To), Duplicate Values highlight, Data Bars, Color Scales, and custom formula-driven conditional formatting rules.
Conditional aggregation calculating total expense by category: =SUMIF(C5:C14, "Rent", E5:E14) and counting pending bills: =COUNTIF(G5:G14, "Pending").
Data Validation, Reporting and Projects
22. Data Validation and Drop-down Lists
Restricting inputs to Whole Numbers, Date Ranges, and creating in-cell Drop-down Lists (Data > Data Validation > List). Configuring friendly Input Messages and Error Alerts.
23. Text Functions — Part 1
Cleaning and standardizing customer names and addresses: =UPPER(), =LOWER(), =PROPER(), and measuring string length with =LEN().
24. Text Functions — Part 2
Splitting and joining strings: =CONCAT() / & operator, extracting characters from left (=LEFT()), right (=RIGHT()), and middle (=MID()).
25. Date and Time Functions
Working with dynamic dates: =TODAY() (current date), =NOW() (date & time), extracting parts with =YEAR(), =MONTH(), and computing age/tenure with =DATEDIF().
26. Creating Charts in Excel
Visualizing data trends: 2D Clustered Column Charts, Bar Charts, Pie Charts, adding Chart Titles, customizing Data Labels, legend placement, and chart color themes.
27. Printing and Page Setup
Configuring Page Break Preview, Print Area, Paper Size (A4), Orientation (Portrait vs. Landscape), Page Scaling (Fit All Columns on One Page), and Exporting to PDF.
28. VLOOKUP Basics
Understanding vertical lookups: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). Finding employee details, product prices, and matching records with exact match (FALSE / 0).
29. Practical Project — Sales Report
Capstone Lab Assignment: Constructing an end-to-end commercial Monthly Branch Sales & Performance Report incorporating tables, formulas, conditional highlights, and summary charts.
30. Final Project and Assessment
Independent lab practical examination covering all 30 days of coursework, instructor review, grading, and course completion certificate eligibility.
Searching employee name by ID: =VLOOKUP(H5, A6:E12, 2, FALSE) and retrieving Base Salary: =VLOOKUP(H5, A6:E12, 5, FALSE).
Download Complete 30-Day Practice Workbook
Get all 30 days of classroom assignments consolidated into one comprehensive multi-tab Excel workbook (.xlsx). Pre-loaded with working formulas, real-world mock data, and step-by-step instructions.
Download Master 30-Day Workbook (.xlsx)Career Scope & Job Profiles in Haldwani
Excel proficiency is the foundational requirement for almost every administrative, marketing, banking, logistics, and retail position. Local employers in Haldwani, Rudrapur Industrial Area, and Dehradun specifically recruit individuals with practical Excel formula capabilities.
Managing organizational databases, extracting daily reports, and updating tracking sheets.
Generating GST customer invoices, calculating discounts, and tracking vendor payments.
Clean recording of attendance, inventory stock, patient records, or school enrollments.
Start Your Practical Excel Training in Haldwani
Flexible morning and evening batches. Each student gets their own computer lab system with guided assignment evaluations.
Book Free Demo Session at Haldwani Center