Microsoft Excel – Learn Advanced Excel Lookups & Functions

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.

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

Who this course is for:
  • Students Who All Are Going To Get Enter In Corporate World
  • A Person Who Want To Learn Advance Concepts Of Excel With Data Analytics At Reasonable Price
  • Well Established Person In The Job Industry & Want To Make His/Her work More Easy With Advance Concept
  • Management & Engineering College Students

Tags:

Tutorial Bar
Logo