Microsoft Excel Essentials For The Real Time World

Microsoft Excel Beginner to Professional. Includes New Formulas
What you'll learn
Excel Terminology
Data Navigation
Data Selection
Formula
Functions
VLOOKUP
Data Ranking
Fixing Text Cases
Requirements
No Experience Needed
Description
Looking to learn Microsoft Excel and improve your data analysis skills but don't know where to start?OR, you've been using Microsoft Excel for a while but don't feel 100% confident?There is so much information out there. What do you need to succeed at work?I've picked out the Excel Essential skills a Data Analyst needs and packaged them in a structured course.In fact, I collected the most common Excel problems faced by my clients. I added in my 15+ years' experience in finance and project management. I included all the hidden tips and tricks I came to learn as an Excel MVP and put it ALL in THIS course. I also made sure it covers the absolute Excel beginners.These practical, real-world examples help you understand the full potential of each feature. You'll learn how to use Excel for quick and painless data analysis.There are many helpful and time-saving Excel formulas and features. We tend to forget what these are if we don't use them. This Microsoft Excel Essentials Course will give you the practice you need to be able to apply the best solution for the task at hand. This way you can do more in less time.
Overview
Section 1: Introduction
Lecture 1 Introduction
Section 2: Fundaments
Lecture 2 Excel Terminology (Part .1)
Lecture 3 Excel Terminology (Part .2)
Lecture 4 Data Navigation
Lecture 5 Data Selection
Lecture 6 Data Entry _ Editing
Lecture 7 Formula vs Functions
Lecture 8 Formula Application (Part .1)
Lecture 9 Formula Application (Part .2)
Lecture 10 Sum _ Auto Sum
Lecture 11 Average Min _ Max
Lecture 12 Absolute vs Relative
Lecture 13 Allignment
Lecture 14 Fonts _ Borders
Lecture 15 Format Painter
Lecture 16 Number Formats
Lecture 17 Styles _ Themes
Lecture 18 Rows _ Columns
Lecture 19 Find _ Select
Lecture 20 Data Filtering
Lecture 21 Data Sorting
Lecture 22 Conditional Formatting
Lecture 23 Basic Charts
Lecture 24 Editing Charts (Part .1)
Lecture 25 Editing Charts (Part .2)
Lecture 26 Move _ Resize Charts
Lecture 27 Count Functions
Lecture 28 Data Ranking
Lecture 29 Combining Texts
Lecture 30 Fixing Text Cases
Lecture 31 Extracting Texts
Lecture 32 Find Function
Lecture 33 Introduction to IF
Lecture 34 Nested IF
Lecture 35 COUNTIFS
Lecture 36 VLOOKUP
Lecture 37 VLOOKUP (Approximate Match)
Lecture 38 Naming Ranges
Beginner who want to learn Excel
Screenshots


#