Microsoft Excel Beginners & Intermediate Excel Training

Excel for the office: Excel Formatting, Excel functions, Excel charts, Excel pivot tables made easy for you

What you'll learn

Work comfortably with Microsoft Excel 2016 and many of its advanced features

Learn what is new in Excel 2016

Be much quicker at carrying out regular tasks

Become your team's go-to-guy when it comes to Excel

Use sophisticated functions that will improve the quality of your work

Requirements

Install Microsoft 2016, 2013 or 2010

No previous knowledge is required!

Great for students who want to learn at their own pace

Description

Do you want to learn how to work with Excel?Even if you don’t have any prior experience?You want to become very good at Excel?If so, then this is the right course for you!*A verifiable certificate of completion is presented to all students who complete this course.*Microsoft Excel is the greatest productivity software the world has seen so far.However, it’s essential that you learn how to work with it effectively.But how can you do that if you have very limited time and no prior training? And how can you be certain that you are not missing an important piece of the puzzle?Microsoft Excel Beginners & Intermediate Excel Training is here for you. One of the best Excel courses online, this training includes everything you’ll need. We will start from the very basics and then gradually build a solid foundation that will help you grow as a professional.What makes this course different from the rest of the Excel courses out there?High quality of production – HD video and animated slides (this isn’t a collection of boring lectures!)Knowledgeable instructor (1.5 million Udemy students, working experience in Big 4 Consulting and Coca-Cola)Downloadable materials: The course comes with a complete set of downloadable materials (handouts, Excel files, etc.)Extensive case studies that will help you reinforce everything that you’ve learnedExcellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answerDynamic: We don’t want to waste your time! The instructor maintains a very good pace throughout the whole courseHow come Microsoft Excel is so important?Every company on the planet uses this software, right? So if you want to learn a new skill that is highly valued by all employers, you should start here.Here are 5 more reasons why you should take this course and learn Excel:Jobs. A solid understanding of Excel opens the door for a number of career pathsPromotions. Top Excel users are promoted very easily inside large corporationsSecure Future. Excel skills remain with you and provide extra security. You won’t ever have to fear unemploymentThis course is suitable for people without any previous experience in Excel. We will start from the very basics and will gradually move on to some of the more advanced features, such as lookup functions, functions with conditions, goal seek, pivot tables, custom formatting, Excel charts, and other tools that are often used for the purposes of financial modeling.Additionally, the course includes practical case studies that will reinforce everything you learn. One of the exercises we will see in the course consists of building a complete Profit & Loss statement from scratch. This training is highly recommended for university students, entry-level finance, business and marketing professionals who would like to grow faster than their peers.Please don’t forget that the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced that it will provide a ton of value for you?Buy the course today and let's start this journey together!

Overview

Section 1: Welcome! Course Introduction

Lecture 1 What Does the Course Cover?

Lecture 2 Bonus Gift Number 1

Lecture 3 Bonus Gift Number 2

Section 2: A Quick Introduction to the Basics of Excel

Lecture 4 Overview of Excel

Lecture 5 The Excel Ribbon

Lecture 6 Working with Rows & Columns

Lecture 7 Data Entry in Excel

Lecture 8 Introduction to Formatting

Lecture 9 Creating Formulas in Excel

Lecture 10 Microsoft Excel at Its Best - Functions

Lecture 11 Work Efficiently By Using Cut, Copy & Paste

Lecture 12 Format Cells

Lecture 13 Pasting Values, Formulas and Formats with Paste Special

Section 3: Assignment 1

Section 4: Excel Best Practices: Useful Tips & Tools

Lecture 14 This Is How You Can Start Formatting Your Sheets in a Professional Way

Lecture 15 Fast Scrolling That Would Allow You to Be 3x Faster

Lecture 16 Fixing Cell References Properly

Lecture 17 Using the Alt plus Enter combination

Lecture 18 Learn How to Organize Your Excel Data with Text to Columns

Lecture 19 Wrapping Text in Excel

Lecture 20 Create Easily Printable Documents by Using Set Print Area

Lecture 21 Find and Select Special Types of Cells with Select Special (F5)

Lecture 22 Learn How to Assign Dynamic Names within a Model

Lecture 23 Excel Formulas that Make Sense - Named Ranges

Lecture 24 Completing 33% of the course

Lecture 25 Introduction to Custom Formatting

Lecture 26 Assigning Custom Formats to Specific Cells (Ex. Multiples)

Lecture 27 Execute 50 Commands with a Single Click - Excel Macros

Lecture 28 Create a Drop-Down List by Using Data Validation

Lecture 29 Using Custom Sort in Order to Sort Multiple Columns within a Table

Lecture 30 Create a Great Index Page at the Beginning of Your Financial Models

Lecture 31 Freeze the Title Row of Your Table - Freeze Panes

Lecture 32 Excel's "Tell Me" Search Bar

Section 5: Keyboard Shortcuts in Excel

Lecture 33 Keyboard Shortcuts Save LOTS of time in Excel

Section 6: Excel Functions

Lecture 34 A helpful consideration

Lecture 35 Key Functions in Excel: COUNT, COUNTA, COUNTIF, COUNTIFS

Lecture 36 Key Functions in Excel: SUM, SUMIF, SUMIFS

Lecture 37 Key Excel Functions: AVERAGE & AVERAGEIF

Lecture 38 Completing 50% of the course

Lecture 39 Working with Text in Excel: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE

Lecture 40 Find the Highest and the Lowest Values in a Range: MAX & MIN

Lecture 41 Include ROUND in Your Financial Models

Lecture 42 Transferring Data Efficiently: VLOOKUP & HLOOKUP

Lecture 43 Use INDEX & MATCH as a Substitute of VLOOKUP

Lecture 44 The Perfect VLOOKUP Substitute: XLOOKUP (Office 365 Only)

Lecture 45 IFERROR Allows You to Deal Easily with Error Mesages

Lecture 46 Excel's Dynamic & Interactive Tables: Pivot Tables

Lecture 47 Create Flexible Financial Models with the CHOOSE Function

Lecture 48 Find the Result that You Are Looking For with Goal Seek

Lecture 49 Include Sensitivity Analysis In Your Model Through Data Tables

Section 7: Create Professional Charts in Microsoft Excel 2016

Lecture 50 Introduction to Charts in Excel 2016

Lecture 51 Inserting Charts in Excel & Learning About the Various Chart Types

Lecture 52 Formatting of Excel Charts (1/2)

Lecture 53 Formatting of Excel Charts (2/2)

Lecture 54 Creating a Bridge Chart in Excel 2016 - As Easy As It Gets

Lecture 55 An Easy Way to Create a Treemap

Lecture 56 Use Sparklines to Show Data Trends

Section 8: Build a Complete P&L from Scratch

Lecture 57 Introduction to the Case Study

Lecture 58 This Is the data that we will use for our Exercise

Lecture 59 Let's Reorder our Excel sheet and create a clear structure

Lecture 60 Introducing a Code: The best way to work with large amounts of data

Lecture 61 Finishing Touches of our Database

Lecture 62 Using Vlookup in Order to Transfer Data

Lecture 63 Applying Sumif in Order to Populate the Database with Numbers

Lecture 64 Demonstrating How Index & Match Can Successfully Replace Vlookup

Lecture 65 Substituting VLOOKUP with XLOOKUP (Office 365 Only)

Lecture 66 Mapping the Items Within Our Database - A Key Exercise For Financial Analysts

Lecture 67 Creating the Structure of the P&L Statement

Lecture 68 Time for Some Formatting! The Secret of Creating Awesome Looking Excel Sheets

Lecture 69 Populating the P&L sheet with figures

Lecture 70 How do We Find Mistakes in the easiest way possible?

Lecture 71 Finishing Touches: Calculating Year-on-Year Growth and Percentage Incidence

Lecture 72 Course Challenge - Apply Your Skills in Practice

Section 9: Practical Exercise - SUMIFS

Lecture 73 Practical Exercise - SUMIFS

Lecture 74 Completing 100% of the course

Beginner, Intermediate and Advanced users who want to be proficient in Excel