Excel Beyond the Basics

You are comfortable with the basic in Excel. We will explore Data Validation and Drop-down lists. We will look at the ways of sorting and filtering your data. We will also look at how to effectively work with dates in Excel

Buy $25.00 Free Preview

Course curriculum

1

Introduction
- Introduction to Beyond the Basics
  FREE PREVIEW
- Copy of How to use this course
2

Data Validation
- Data Validation
- Drop-down lists
- Related Drop -Down lists
- Answers to Related Drop-down lists
- Remove Duplicates
3

Working With Dates
- Formatting options
- Answers for Date Formatting Exercise
- Dates relative to Today
- Answers for Dates Relative to Today Exercise
- Determining the Difference between dates
4

Sort and Filter
- Basic Sort and Filter
- Advanced Filter