Microsoft Excel - Learn Advanced Excel Lookups & Functions
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.84 GB
Genre: eLearning Video | Duration: 50 lectures (4 hour, 54 mins) | Language: English
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
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction
Cantinho Satkeys
