Advanced Spreadsheet Using MS Excel 2016
Back to Dashboard
Hey there, great course, right? Do you like this course?
All of the most interesting lessons further. In order to continue you just need to purchase it
Enroll course
Course sections
Section 1
LESSON 1 - USING CONDITIONAL AND CUSTOM FORMATS
1
1.1 Applying An AutoFormat/Table Style To A Cell Range
2
1.2 Applying Conditional Formats
3
1.3 Editing a Conditional Format
4
1.4 Changing a Conditional Format
5
1.5 Creating a Custom Conditional Format
6
1.6 Using Data Bars
7
1.7 Deleting a Conditional Format
8
1.8 Creating a Custom Number Format
9
1.9 Review Exercise
Section 2
LESSON 2 - USING TEMPLATES
1
Deep Learning
2
2.1 Copying Worksheets
3
2.2 Hiding Columns and Rows
4
2.3 Unhiding Columns and Rows
5
2.4 Split Text to Columns
6
2.5 Split a Window. Move, Remove Split Bars
7
2.6 Saving a Workbook as a Template
8
2.7 Using a Template
9
2.8 Editing a Template
10
2.9 Inserting a New Worksheet
11
2.10 Hiding/Unhiding a Worksheet
12
2.11 Deleting a Template
13
2.12 Finding Online Templates
14
2.13 Review Exercise
Section 3
LESSON 3 - SORTING AND VALIDATING DATA
1
3.1 Grouping in a Worksheet
2
3.2 Creating Subtotals in a List
3
3.3 Removing Subtotals from a List
4
3.4 Sorting Data by Multiple Levels
5
3.5 Using Custom Sort
6
3.6 Using Data Validation
7
3.7 Validating Data using a List
8
3.8 Creating a Custom Error Message
9
3.9 Removing Data Validation
10
3.10 Review Exercise
Section 4
LESSON 4 - WORKING WITH ADVANCED FILTERS
Questions
{{ comment.replies_count }}
Send
Load More
My Question
Ask A Question
Add Comment
{{ message }}
Send
Back to all questions
LESSON 1 - USING CONDITIONAL AND CUSTOM FORMATS
ICDL AFRICA SIGNED AN MOU WITH TERTIARY EDUCATION TRUST FUND (NIGERIA)
Lesson is locked. Please Buy course to proceed.
Complete
Ask A Question