# Microsoft Excel – Learn Advanced Excel Lookups & Functions | 100%OFF

## Get Udemy Coupon Free For Microsoft Excel – Learn Advanced Excel Lookups & Functions Course

1. Getting Started: Get familiar with Excel Learn the basic operations and formulas of excel.

• Introduction to Excel

• Why should we learn Excel?

• Orientation / Tour

• Interface & Terminology

• Excel worksheets

• Excel Ribbon

• Backstage View

• Keyboard shortcuts

2. Excel Basics: You will learn basic concepts in this module which will give you a chance to build a solid foundation.

• Cell Basics

• Modifying cells/rows/columns

• Basic Cell Formatting

• Cell Number Formats

• Cut, Copy & Paste

• Format Painter

• Personalizing Worksheets

• Multiple worksheets

• Find & Replace

• Sheet Protection

• Printing & Page Layout

• Assignment

3. FORMULAS & FUNCTIONS: In-depth lessons on formulas, functions, lookup functions and data validation with Excel.

• Intro

• Basic Formulas

• Cell References

• Excel Functions

• Date/Time Functions

• Text Functions

• Financial Functions

• Logical Functions

• Lookup Functions

• Data Validation

• Troubleshooting

• Assignment

4. WORKING WITH DATA: You will learn all about data organization and data visualization.

• Basic tips for working with data

• Freezing panes and view options

• Data sorting

• Data filtering

• Tables

• Charts

• Assignment

5. ADVANCED CONCEPTS: You will learn the skills needed to automate, analyze & present Excel data in the most effective manner.

• Conditional Formatting

• What-If Analysis

• Pivot Tables 1

• Pivot Tables 2

• Pivot Tables 3

• Assignment

### WHAT WILL YOU LEARN IN THIS COURSE:

1. Getting Started: Get familiar with Excel Learn the basic operations and formulas of excel. 2. Excel Basics: You will learn basic concepts in this module which will give you a chance to build a solid foundation. 3. FORMULAS & FUNCTIONS: In-depth lessons on formulas, functions, lookup functions and data validation with Excel 4. WORKING WITH DATA: You will learn all about data organization and data visualization 5. ADVANCED CONCEPTS: You will learn the skills needed to automate, analyze & present Excel data in the most effective manner While I can’t make promises, my goal is to help you get the raise, promotion, or new job that you deserve.

IF YOU FIND THIS COURSE USEFUL AND HELPFUL PLEASE GO AHEAD SHARE THE KNOWLEDGE WITH YOUR FRIENDS WHILE THE COURSE IS STILL AVAILABLE