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
Expanding Beyond the Basics
Expanding Beyond the Basics
Curriculum
4 Sections
32 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 11: Navigating Through Worksheets and Workbooks
22
1.1
Finding and Replacing Data within Cells
1.2
Quiz for Finding and Replacing Data within Cells
6 Questions
1.3
Exploring with the Navigation Task Pane
1.4
Quiz for Exploring with the Navigation Task Pane
5 Questions
1.5
Jumping to Locations with Go To
1.6
Quiz for Jumping to Locations with Go To
5 Questions
1.7
Targeting Specific Cells with Go To Special
1.8
Quiz for Targeting Specific Cells with Go To Special
5 Questions
1.9
Navigating with the Name Box
1.10
Quiz for Navigating with the Name Box
6 Questions
1.11
Activating Worksheets
1.12
Quiz for Activating Worksheets
5 Questions
1.13
Reordering Worksheets
1.14
Quiz for Reordering Worksheets
6 Questions
1.15
Splitting Worksheet Windows
1.16
Quiz for Splitting Worksheet Windows
5 Questions
1.17
Viewing Two or More Worksheets at Once
1.18
Quiz for Viewing Two or More Worksheets at Once
5 Questions
1.19
Applying Custom Views
1.20
Quiz for Applying Custom Views
6 Questions
1.21
Zooming In and Out
1.22
Quiz for Zooming In and Out
5 Questions
Chapter 12: Visualizing and Summarizing Data
8
2.1
Introducing Excel charts
2.2
Quiz for Introducing Excel charts
7 Questions
2.3
Deconstructing and Customizing Charts
2.4
Quiz for Deconstructing and Customizing Charts
7 Questions
2.5
Spotlighting Trends with Sparklines
2.6
Quiz for Spotlighting Trends with Sparklines
6 Questions
2.7
Unleashing the Magic of PivotTables
2.8
Quiz for Unleashing the Magic of PivotTables
5 Questions
Chapter 13: Contemplating Conditional Formatting
20
3.1
Formatting with Quick Analysis
3.2
Quiz for Formatting with Quick Analysis
5 Questions
3.3
Decoding Conditional Formatting Options
3.4
Quiz for Decoding Conditional Formatting Options
5 Questions
3.5
Highlighting Cells Based on Value
3.6
Quiz for Highlighting Cells Based on Value
6 Questions
3.7
Applying Top or Bottom Rules
3.8
Quiz for Applying Top or Bottom Rules
5 Questions
3.9
Displaying Data Bars
3.10
Quiz for Displaying Data Bars
7 Questions
3.11
Grading with Color Scales
3.12
Quiz for Grading with Color Scales
5 Questions
3.13
Symbolizing with Icon Sets
3.14
Quiz for Symbolizing with Icon Sets
6 Questions
3.15
Crafting Custom Rules
3.16
Quiz for Crafting Custom Rules
6 Questions
3.17
Removing Conditional Formatting
3.18
Quiz for Removing Conditional Formatting
5 Questions
3.19
Managing Conditional Formatting Rules
3.20
Quiz for Managing Conditional Formatting Rules
7 Questions
Chapter 14: User-Proofing Excel Spreadsheets
14
4.1
Unlocking and Protecting Worksheet Cells
4.2
Quiz for Unlocking and Protecting Worksheet Cells
7 Questions
4.3
Safeguarding Workbook Structure
4.4
Quiz for Safeguarding Workbook Structure
6 Questions
4.5
Ensuring Accuracy with Data Validation
4.6
Quiz for Ensuring Accuracy with Data Validation
7 Questions
4.7
Putting Data Entry Rules into Action
4.8
Quiz for Putting Data Entry Rules into Action
7 Questions
4.9
Protecting Data Validation Cells
4.10
Quiz for Protecting Data Validation Cells
6 Questions
4.11
Identifying Invalid Inputs
4.12
Quiz for Identifying Invalid Inputs
6 Questions
4.13
Removing Data Validation
4.14
Quiz for Removing Data Validation
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
