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
Explaining Excel Fundamentals
Explaining Excel Fundamentals
Curriculum
5 Sections
38 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 1: Getting Started with Spreadsheets
10
1.1
Exploring Excel’s User Interface
1.1
Quiz for Exploring Excel’s User Interface
7 Questions
1.2
Entering and Editing Data
1.2
Quiz for Entering and Editing Data
7 Questions
1.3
Handling Workbook Operations
1.3
Quiz for Handling Workbook Operations
6 Questions
1.4
Managing Worksheet Tasks
1.4
Quiz for Managing Worksheet Tasks
7 Questions
1.5
Collaborating with Others
1.5
Quiz for Collaborating with Others
6 Questions
Chapter 2: Carrying Out Basic Calculations
12
2.1
Understanding Operators
2.1
Quiz for Understanding Operators
7 Questions
2.2
Exploring the Order of Operations
2.2
Quiz for Exploring the Order of Operations
7 Questions
2.3
Contrasting Cell References
2.3
Quiz for Contrasting Cell References
6 Questions
2.4
Replicating Formulas
2.4
Quiz for Replicating Formulas
6 Questions
2.5
Calculating Sums
2.5
Quiz for Calculating Sums
6 Questions
2.6
Analyzing Data with Statistical Functions
2.6
Quiz for Analyzing Data with Statistical Functions
7 Questions
Chapter 3: Formatting Cells and Worksheets
26
3.1
Applying Basic Formatting Commands
3.1
Quiz for Applying Basic Formatting Commands
8 Questions
3.2
Exploring the Format Cells Dialog Box
3.2
Quiz for Exploring the Format Cells Dialog Box
7 Questions
3.3
Applying Cell Styles
3.3
Quiz for Applying Cell Styles
6 Questions
3.4
Merging Cells
3.4
Quiz for Merging Cells
5 Questions
3.5
Wrapping Text
3.5
Quiz for Wrapping Text
5 Questions
3.6
Tapping into Text Boxes
3.6
Quiz for Tapping into Text Boxes
5 Questions
3.7
Inserting Images
3.7
Quiz for Inserting Images
5 Questions
3.8
Enhancing Accessibility
3.8
Quiz for Enhancing Accessibility
7 Questions
3.9
Adjusting Row Heights and Column Widths
3.9
Quiz for Adjusting Row Heights and Column Widths
7 Questions
3.10
Hiding and Unhiding Rows and Columns
3.10
Quiz for Hiding and Unhiding Rows and Columns
7 Questions
3.11
Hiding and Unhiding Worksheets
3.11
Quiz for Hiding and Unhiding Worksheets
6 Questions
3.12
Hiding and Unhiding Workbooks
3.12
Quiz for Hiding and Unhiding Workbooks
6 Questions
3.13
Modifying Page Setup
3.13
Quiz for Modifying Page Setup
5 Questions
Chapter 4: Sifting Through Data
16
4.1
Freezing Panes
4.1
Quiz for Freezing Panes
7 Questions
4.2
Utilizing the Sort Feature
4.2
Quiz for Utilizing the Sort Feature
6 Questions
4.3
Removing Duplicates
4.3
Quiz for Removing Duplicates
6 Questions
4.4
Finessing the Filter Feature
4.4
Quiz for Finessing the Filter Feature
6 Questions
4.5
Calculating with SUBTOTAL
4.5
Quiz for Calculating with SUBTOTAL
5 Questions
4.6
Using the AGGREGATE Function
4.6
Quiz for Using the AGGREGATE Function
8 Questions
4.7
Summarizing Lists with the Subtotal Feature
4.7
Quiz for Summarizing Lists with the Subtotal Feature
6 Questions
4.8
Jumpstarting Insights with Quick Analysis
4.8
Quiz for Jumpstarting Insights with Quick Analysis
5 Questions
Chapter 5: Tackling Tables
12
5.1
Comparing Data Ranges to Excel Tables
5.1
Quiz for Comparing Data Ranges to Excel Tables
5 Questions
5.2
Creating Excel Tables
5.2
Quiz for Creating Excel Tables
7 Questions
5.3
Automating Formulas and Features
5.3
Quiz for Automating Formulas and Features
5 Questions
5.4
Unpacking Table Quirks
5.4
Quiz for Unpacking Table Quirks
5 Questions
5.5
Troubleshooting Tables
5.5
Quiz for Troubleshooting Tables
5 Questions
5.6
Converting a Table to a Data Range
5.6
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!
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
