Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Certification Guides
Microsoft
Expanding Beyond the Basics
Expanding Beyond the Basics
Curriculum
4 Sections
32 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 11: Navigating Through Worksheets and Workbooks
22
1.1
Finding and Replacing Data within Cells
1.1
Quiz for Finding and Replacing Data within Cells
6 Questions
1.2
Exploring with the Navigation Task Pane
1.2
Quiz for Exploring with the Navigation Task Pane
5 Questions
1.3
Jumping to Locations with Go To
1.3
Quiz for Jumping to Locations with Go To
5 Questions
1.4
Targeting Specific Cells with Go To Special
1.4
Quiz for Targeting Specific Cells with Go To Special
5 Questions
1.5
Navigating with the Name Box
1.5
Quiz for Navigating with the Name Box
6 Questions
1.6
Activating Worksheets
1.6
Quiz for Activating Worksheets
5 Questions
1.7
Reordering Worksheets
1.7
Quiz for Reordering Worksheets
6 Questions
1.8
Splitting Worksheet Windows
1.8
Quiz for Splitting Worksheet Windows
5 Questions
1.9
Viewing Two or More Worksheets at Once
1.9
Quiz for Viewing Two or More Worksheets at Once
5 Questions
1.10
Applying Custom Views
1.10
Quiz for Applying Custom Views
6 Questions
1.11
Zooming In and Out
1.11
Quiz for Zooming In and Out
5 Questions
Chapter 12: Visualizing and Summarizing Data
8
2.1
Introducing Excel charts
2.1
Quiz for Introducing Excel charts
7 Questions
2.2
Deconstructing and Customizing Charts
2.2
Quiz for Deconstructing and Customizing Charts
7 Questions
2.3
Spotlighting Trends with Sparklines
2.3
Quiz for Spotlighting Trends with Sparklines
6 Questions
2.4
Unleashing the Magic of PivotTables
2.4
Quiz for Unleashing the Magic of PivotTables
5 Questions
Chapter 13: Contemplating Conditional Formatting
20
3.1
Formatting with Quick Analysis
3.1
Quiz for Formatting with Quick Analysis
5 Questions
3.2
Decoding Conditional Formatting Options
3.2
Quiz for Decoding Conditional Formatting Options
5 Questions
3.3
Highlighting Cells Based on Value
3.3
Quiz for Highlighting Cells Based on Value
6 Questions
3.4
Applying Top or Bottom Rules
3.4
Quiz for Applying Top or Bottom Rules
5 Questions
3.5
Displaying Data Bars
3.5
Quiz for Displaying Data Bars
7 Questions
3.6
Grading with Color Scales
3.6
Quiz for Grading with Color Scales
5 Questions
3.7
Symbolizing with Icon Sets
3.7
Quiz for Symbolizing with Icon Sets
6 Questions
3.8
Crafting Custom Rules
3.8
Quiz for Crafting Custom Rules
6 Questions
3.9
Removing Conditional Formatting
3.9
Quiz for Removing Conditional Formatting
5 Questions
3.10
Managing Conditional Formatting Rules
3.10
Quiz for Managing Conditional Formatting Rules
7 Questions
Chapter 14: User-Proofing Excel Spreadsheets
14
4.1
Unlocking and Protecting Worksheet Cells
4.1
Quiz for Unlocking and Protecting Worksheet Cells
7 Questions
4.2
Safeguarding Workbook Structure
4.2
Quiz for Safeguarding Workbook Structure
6 Questions
4.3
Ensuring Accuracy with Data Validation
4.3
Quiz for Ensuring Accuracy with Data Validation
7 Questions
4.4
Putting Data Entry Rules into Action
4.4
Quiz for Putting Data Entry Rules into Action
7 Questions
4.5
Protecting Data Validation Cells
4.5
Quiz for Protecting Data Validation Cells
6 Questions
4.6
Identifying Invalid Inputs
4.6
Quiz for Identifying Invalid Inputs
6 Questions
4.7
Removing Data Validation
4.7
Quiz for Removing Data Validation
5 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content
