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