Solutions to Practice Exercises

Microsoft Excel: Intermediate & Advanced Class

Video Tutorials & Completed Files


Lesson 1: Refresher

View video tutorial and completed file for Practice Exercises 11-18.

Lesson 2: Working with Dates

View video tutorial and completed file for Practice Exercises 9-10.

Lesson 3: Conditional Formatting & Data Validation  

View video tutorial and completed file for Practice Exercises 19-24.

Lesson 4: Text to Columns, Text Formulas & Special Values  

View video tutorial and completed file for Practice Exercises 25-33.

Lesson 5: Shortcuts to Use with Tables  

View video tutorial and completed file for Practice Exercises 34-36.

Lesson 6: Intro to Logical Formulas  

View video tutorial and completed file for Practice Exercises 37-41.

Lesson 7: Advanced Logical Formulas  

View video tutorial and completed file for Practice Exercises 42-44.

Lesson 8: Lookup Formulas  

View video tutorial and completed file for Practice Exercises 45-48.

Lesson 9: Pivot Tables  

View video tutorial and completed file for Practice Exercises 49-53.

Lesson 10: Pivot Charts  

View video tutorial and completed file for Practice Exercises 54-57.

Leave A Comment or Question

Subscribe
Notify of
guest

16 Comments
Newest
Oldest
Inline Feedbacks
View all comments

Copyright © Leadership Build 2021. All Rights Reserved.