Skip to content
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
Course Catalog
About
Contact Us
Home
All Programs
Computers
Certification Guides
Microsoft
Explaining Excel Fundamentals
Explaining Excel Fundamentals
Curriculum
5 Sections
38 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 1: Getting Started with Spreadsheets
10
1.1
Exploring Excel’s User Interface
1.2
Quiz for Exploring Excel’s User Interface
7 Questions
1.3
Entering and Editing Data
1.4
Quiz for Entering and Editing Data
7 Questions
1.5
Handling Workbook Operations
1.6
Quiz for Handling Workbook Operations
6 Questions
1.7
Managing Worksheet Tasks
1.8
Quiz for Managing Worksheet Tasks
7 Questions
1.9
Collaborating with Others
1.10
Quiz for Collaborating with Others
6 Questions
Chapter 2: Carrying Out Basic Calculations
12
2.1
Understanding Operators
2.2
Quiz for Understanding Operators
7 Questions
2.3
Exploring the Order of Operations
2.4
Quiz for Exploring the Order of Operations
7 Questions
2.5
Contrasting Cell References
2.6
Quiz for Contrasting Cell References
6 Questions
2.7
Replicating Formulas
2.8
Quiz for Replicating Formulas
6 Questions
2.9
Calculating Sums
2.10
Quiz for Calculating Sums
6 Questions
2.11
Analyzing Data with Statistical Functions
2.12
Quiz for Analyzing Data with Statistical Functions
7 Questions
Chapter 3: Formatting Cells and Worksheets
26
3.1
Applying Basic Formatting Commands
3.2
Quiz for Applying Basic Formatting Commands
8 Questions
3.3
Exploring the Format Cells Dialog Box
3.4
Quiz for Exploring the Format Cells Dialog Box
7 Questions
3.5
Applying Cell Styles
3.6
Quiz for Applying Cell Styles
6 Questions
3.7
Merging Cells
3.8
Quiz for Merging Cells
5 Questions
3.9
Wrapping Text
3.10
Quiz for Wrapping Text
5 Questions
3.11
Tapping into Text Boxes
3.12
Quiz for Tapping into Text Boxes
5 Questions
3.13
Inserting Images
3.14
Quiz for Inserting Images
5 Questions
3.15
Enhancing Accessibility
3.16
Quiz for Enhancing Accessibility
7 Questions
3.17
Adjusting Row Heights and Column Widths
3.18
Quiz for Adjusting Row Heights and Column Widths
7 Questions
3.19
Hiding and Unhiding Rows and Columns
3.20
Quiz for Hiding and Unhiding Rows and Columns
7 Questions
3.21
Hiding and Unhiding Worksheets
3.22
Quiz for Hiding and Unhiding Worksheets
6 Questions
3.23
Hiding and Unhiding Workbooks
3.24
Quiz for Hiding and Unhiding Workbooks
6 Questions
3.25
Modifying Page Setup
3.26
Quiz for Modifying Page Setup
5 Questions
Chapter 4: Sifting Through Data
16
4.1
Freezing Panes
4.2
Quiz for Freezing Panes
7 Questions
4.3
Utilizing the Sort Feature
4.4
Quiz for Utilizing the Sort Feature
6 Questions
4.5
Removing Duplicates
4.6
Quiz for Removing Duplicates
6 Questions
4.7
Finessing the Filter Feature
4.8
Quiz for Finessing the Filter Feature
6 Questions
4.9
Calculating with SUBTOTAL
4.10
Quiz for Calculating with SUBTOTAL
5 Questions
4.11
Using the AGGREGATE Function
4.12
Quiz for Using the AGGREGATE Function
8 Questions
4.13
Summarizing Lists with the Subtotal Feature
4.14
Quiz for Summarizing Lists with the Subtotal Feature
6 Questions
4.15
Jumpstarting Insights with Quick Analysis
4.16
Quiz for Jumpstarting Insights with Quick Analysis
5 Questions
Chapter 5: Tackling Tables
12
5.1
Comparing Data Ranges to Excel Tables
5.2
Quiz for Comparing Data Ranges to Excel Tables
5 Questions
5.3
Creating Excel Tables
5.4
Quiz for Creating Excel Tables
7 Questions
5.5
Automating Formulas and Features
5.6
Quiz for Automating Formulas and Features
5 Questions
5.7
Unpacking Table Quirks
5.8
Quiz for Unpacking Table Quirks
5 Questions
5.9
Troubleshooting Tables
5.10
Quiz for Troubleshooting Tables
5 Questions
5.11
Converting a Table to a Data Range
5.12
Quiz for Converting a Table to a Data Range
5 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Your Journey Starts Here
Course Catalog
About
Contact Us
Login/Sign Up
Modal title
Main Content
