Skip to content
Skip to content
Home
All Courses
CORPORATE & PROFESSIONAL COURSES
DIGITAL MARKETING COURSES
Computer & IT Courses
Enterprise development courses
TECH BEGINNER COURSES
Workshop
Register
My Profile
CERT
X
Home
All Courses
Computer & IT Courses
Spreadsheet Essentials
Spreadsheet Essentials
Curriculum
9 Sections
43 Lessons
6 Weeks
Expand all sections
Collapse all sections
MODULE 01: INTRODUCTION
5
1.0
Introduction to Spreadsheets
1.1
Overview of spreadsheet software
1.2
Understanding the user interface
1.3
Creating, opening, and saving spreadsheets
1.4
Navigating and selecting cells, rows, and columns
MODULE 02: WORKING WITH DATA
6
2.0
Introduction
2.1
Entering and editing data
2.2
Formatting cells (number formats, fonts, colors)
2.3
Applying cell borders and shading
2.4
Using data validation to maintain data integrity
2.5
Sorting and filtering data
MODULE 03: BASIC FORMULAS & FUNCTIONS
5
3.0
Introduction
3.1
Understanding formulas and cell references
3.2
Performing basic calculations (sum, average, count, etc.)
3.3
Using mathematical, statistical, and logical functions
3.4
Working with date and time functions
MODULE 04: FORMATTING
5
4.0
Introduction
4.1
Cell formatting (alignment, merging cells)
4.2
Applying conditional formatting rules
4.3
Creating custom formatting rules
4.4
Using data bars, color scales, and icon sets
MODULE 05: WORKSHEETS & WORKBOOK
5
5.0
Managing Worksheets and Workbooks
5.1
Inserting, deleting, and renaming worksheets
5.2
Moving and copying worksheets
5.3
Linking and referencing data across worksheets
5.4
Consolidating data from multiple workbooks
MODULE 06: ADVANCE FUNCTIONS & FORMULAS
5
6.0
Introduction
6.1
Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
6.2
Text functions (CONCATENATE, LEFT, RIGHT, MID, etc.)
6.3
Logical functions (IF, AND, OR)
6.4
Array formulas
MODULE 07: DATA ANALYSIS & VISUALIZATION
5
7.0
Introduction
7.1
Creating and modifying charts (column, bar, pie, line, etc.)
7.2
Applying chart elements and formatting options
7.3
Using sparklines and data bars for visual representation
7.4
Performing data analysis with pivot tables
MODULE 08: MACROS & AUTOMATION
5
8.0
Introduction
8.1
Recording and running macros
8.2
Editing and debugging macros
8.3
Assigning macros to buttons or keyboard shortcuts
8.4
Using automation features to streamline tasks
ASSESSMENT
3
9.0
Hands-On Exercise
9.1
Case Studies
9.2
Quiz
15 Minutes
30 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content
