VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Expanding Beyond the Basics
Curriculum
4 Sections
32 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 11: Navigating Through Worksheets and Workbooks
11
1.1
Finding and Replacing Data within Cells
10 mins
1.2
Exploring with the Navigation Task Pane
10 mins
1.3
Jumping to Locations with Go To
10 mins
1.4
Targeting Specific Cells with Go To Special
10 mins
1.5
Navigating with the Name Box
10 mins
1.6
Activating Worksheets
10 mins
1.7
Reordering Worksheets
10 mins
1.8
Splitting Worksheet Windows
10 mins
1.9
Viewing Two or More Worksheets at Once
10 mins
1.10
Applying Custom Views
10 mins
1.11
Zooming In and Out
10 mins
Chapter 12: Visualizing and Summarizing Data
4
2.1
Introducing Excel charts
10 mins
2.2
Deconstructing and Customizing Charts
10 mins
2.3
Spotlighting Trends with Sparklines
10 mins
2.4
Unleashing the Magic of PivotTables
10 mins
Chapter 13: Contemplating Conditional Formatting
10
3.1
Formatting with Quick Analysis
10 mins
3.2
Decoding Conditional Formatting Options
10 mins
3.3
Highlighting Cells Based on Value
10 mins
3.4
Applying Top or Bottom Rules
10 mins
3.5
Displaying Data Bars
10 mins
3.6
Grading with Color Scales
10 mins
3.7
Symbolizing with Icon Sets
10 mins
3.8
Crafting Custom Rules
10 mins
3.9
Removing Conditional Formatting
10 mins
3.10
Managing Conditional Formatting Rules
10 mins
Chapter 14: User-Proofing Excel Spreadsheets
7
4.1
Unlocking and Protecting Worksheet Cells
10 mins
4.2
Safeguarding Workbook Structure
10 mins
4.3
Ensuring Accuracy with Data Validation
10 mins
4.4
Putting Data Entry Rules into Action
10 mins
4.5
Protecting Data Validation Cells
10 mins
4.6
Identifying Invalid Inputs
10 mins
4.7
Removing Data Validation
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content