MS Excel Basic Level (Demo)

Skill Sift — Boost Your Career

Professional Excel courses designed for students, working professionals, and corporate teams. Learn with live practice, projects.

Hands On Practice Live Duration : 1 Month

www.skillsift.in · support@skillsift.in · +91 9536-37-7940

Syllabus Overview

Levels, Chapters & Topics

Excel - Basic
- Excel Interface & Ribbon
  - What is Excel ?
  - Use cases of Excel in real life
  - Starting Excel and creating a new workbook
  - Headings & Gridlines
  - Excel file extensions
  - Saving and renaming workbooks
  - Title Bar & Quick Access Toolbar
  - Ribbon Tabs
  - Formula Bar & Name Box
  - Sheets Tab & Status Bar
- Workbook vs Worksheet
  - What is a Workbook ?
  - What is a Worksheet ?
  - Worksheet Operations
  - Workbook Operations
  - Workbook Properties
  - Switching Between Multiple Workbooks
  - Sharing Workbooks
  - Workbook Links
  - Grouping Worksheets for Simultaneous Editing
  - Protecting Worksheets (with/without password)
  - Excel’s Worksheet Row/Column Limits
- Rows, Columns, Cells, and Ranges
  - What is a Cell in Excel ?
  - Whats is Row & Column in excel ?
  - Select, Insert, Delete
  - Resize Rows and Columns
  - Merge & Unmerge Cells
  - Cell Addressing Types
  - Named Ranges
  - Name Manager
  - Create name range from selection
  - Hide / Unhide Rows and Columns
  - Group / Ungroup Rows & Columns
  - Row Height & Column Width
  - Wrap Text & Shrink to Fit
  - Text Alignment & Orientation
  - Cell Borders – Single Cell & Range
  - Cell Comments / Notes
- Data Entry, Edit, Undo/Redo
  - Types of Data Entry
  - Entering Data in Cells
  - Edit Cell Content
  - Copy / Cut / Paste
  - Paste Special
  - Range copy as picture
  - AutoCorrect & AutoComplete
  - Fill Handle (AutoFill)
  - Undo and Redo
  - Delete, Clear, and Backspace
  - Insert Data from Clipboard History
- Excel Illustrations
  - Pictures
  - Shapes
  - Icons
  - 3D Models
  - Smart Art
  - Screenshot
- Save, Save As, Export to PDF
  - Save vs. Save As
  - Supported File Formats in Save As
  - AutoSave
  - Set Default Save Location
  - Save As Template
  - Version History
  - Save to PDF
  - PDF Save Options
  - Add save button in quick access toolbar
  - AutoRecover and AutoBackup
  - Save in Cloud
  - Save Specific Range as PDF
- Page Layout & Print Setup
  - Page Orientation
  - Paper Size
  - Margins
  - Insert/Remove Page Breaks
  - Print Area Setting
  - Scaling Options
  - Print Titles
  - Gridlines & Headings in Print
  - Header and Footer
  - Print Preview & Page Break Preview
  - Print Options Summary
  - Print Comments and Notes
  - Insert Background
  - Insert Page Numbers
  - Layer Backward / Forward
- Find, Replace, Go To
  - Basic Text Find
  - Find Entire Workbook vs Single Sheet
  - Find with Match Case
  - Find with Match Entire Cell Contents
  - Basic Replace
  - Replace All vs Replace One by One
  - Replace with Formatting
  - Replace Within a Selection Only
  - Special Characters Replace
  - Replace Formulas/Functions with Values
  - Go To a Specific Cell/Range
  - Go To Named Range
  - Go To a Defined Table or Object
  - Go To Special
  - Wildcard Characters in Find
  - Finding Duplicate Values
  - Using Find for Formula References
  - Replace Specific Text in Formulas
  - Replace with Nothing
  - Jump to Last Row/Column
- Formatting : Font, Color, Border
  - Font Style & Size
  - Font Color & Fill Color
  - Borders & Border Style
  - Clear Formatting
  - Format Painter
  - Custom Number Formatting
  - Cell Styles
  - Theme Colors & Fonts
  - Indenting Text in Cells
- Number Formatting
  - General Format
  - Number Format
  - Currency Format
  - Accounting Format
  - Percentage Format
  - Date Format
  - Custom Date Format
  - Time Format
  - Custom Time Format
  - Text Format for Numbers
  - Negative Number Formatting
  - Fraction Format
  - Scientific Format
  - Currency vs Accounting Difference
  - Custom Number Format Codes
  - Show Units in Format
  - Hide Zero Values
  - Phone Number Formatting
  - Time Duration Formatting
  - Dynamic Date Format Using TEXT() Function
  - Accounting Format with Indian Rupee Symbol
  - Combine Date & Time in One Cell
- Short & Filter
  - Sort Ascending & Descending
  - Sort Smallest to Largest
  - Sort Oldest to Newest
  - Sort by One Column
  - Sort by Multiple Columns
  - Filter by Text
  - Filter by Number
  - Filter by Date
  - Clear Sort and Filters
  - Use of Filter Drop-down Options
  - Search within Filter
  - Copy Filtered Data Only
  - Sort & Filter on Table Format
  - Color-based Sorting
  - Custom Sort Order
  - Sort by Cell or Font Color
  - Using Filter with Wildcards
  - Sort or Filter Merged Cells
  - Sort Using Helper Column
- Basic Functions
  - What is function in excel ?
  - Sum
  - Average
  - Min
  - Max
  - Count
  - Counta
  - Round()
  - Roundup()
  - Rounddown
  - Sumproduct
  - Date
  - Now
  - Today
  - Mod
  - Int
  - Rand
  - Randbetween
  - Day
  - Month
  - Year
  - Clean
  - Trim
  - Len
  - Upper
  - Lower
  - Proper
  - Concat
- AutoFill, Flash Fill
  - What is Auto Fill ?
  - AutoFill with Ctrl key
  - Double-click AutoFill
  - Fill Series from Ribbon
  - Custom Number Pattern Fill
  - Fill Up, Down, Left, Right
  - What is Flash Fill ?
- Freeze Panes & Split View
  - What is Freeze Panes ?
  - Freeze Panes (Custom Row & Column)
  - What is Split View ?
- Charts
  - Introduction to Charts
  - Column Chart
  - Line Chart
  - Bar Chart
  - Pie Chart
  - Chart Design Tools
  - Formatting Charts
- Keyboard Shortcuts
  - File & Workbook
  - Navigation & Selection
  - Editing Cells & Content
  - Formatting Cells
  - Worksheets
  - Formula Related
  - Charts & Tables
  - Data Handling & Cleanup
  - Filtering & Sorting
  - Window & View Control
  - Cell Referencing & Formula Entry
  - Ribbon Navigation
  - Other Useful Shortcuts
- Others
  - Workbook Statistics

Total : Levels : 1 · Chapters : 17 · Topics : 210

Outcomes

What You’ll Gain

Real-World Skills

Build dashboards, automate tasks, and analyze data to make better decisions at work.

Career Advantage

Upgrade your resume and stand out with practical Excel expertise and certification.

Project Portfolio

Create and showcase portfolio-ready Excel projects to employers or clients.

Enroll Now

Start Your Excel Journey Today!

Limited seats available for the next cohort. Join live sessions or learn at your own pace with recordings.

Register Now Book a Demo