Microsoft Excel – Learn Advanced Excel Lookups & Functions

Amazing advance excel injection that makes you stand out of the crowd. If you are lazy in reporting, excel is for you.

Deal Score+4
Ad Blocked

What you’ll learn

  • 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.

Requirements

  • Be Able To Understand Simple English Language
  • This course was created with Excel 2013. But all features will work in Excel 2010, 2013, 2016 ,2007 and further new versions.

Description

Table of Contents

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

Quick Access Toolbar

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

Advanced 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

Author(s): Mukul Agrawal

Ad Blocked
Coupon Scorpion