EXCEL at Work Complete MS Excel Mastery Beginner to Pro

Boost your Excel skills – Boost your career. Master Microsoft Excel worksheets, functions, & more. Excel 2016-2019 & 365
EXCEL at Work Complete MS Excel Mastery Beginner to Pro
File Size :
3.74 GB
Total length :
6h 53m

Instructor

Steve McDonald

Language

Last update

10/2021

Ratings

4.6/5

EXCEL at Work Complete MS Excel Mastery Beginner to Pro

What you’ll learn

In this course, you’ll quickly become comfortable using the entire Excel dashboard including its tabs, ribbon and tools.
You’ll learn all the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas and saving your document to your computer.
I’ll also walk you through how to create professional charts and graphs to visualize your data, and you’ll create pivot tables for lightening fast calculations.
Use the most commonly used Excel functions to make powerful calculations.
Learn to use several of the new Excel features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016 and beyond.
Great for beginners to intermediate Excel users.

EXCEL at Work Complete MS Excel Mastery Beginner to Pro

Requirements

All you need is a copy of Excel on your computer. The course teaches you how to use Excel starting at the very beginning.

Description

“Your Excel skills could land your next job.”    – Fortune MagazineA study reported in the Wall Street Journal found that 78% of middle-skill jobs require digital skills like Excel and Word. And jobs that require digital skills also pay 13% more than those that don’t.Are you ready to land your next job and increase your pay by 13%?This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It’s perfect for you if you are a beginner or intermediate Excel user who needs to drastically increase your Excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way.Note: This course is specifically designed for learning on  a PC. If you are learning on a Mac, the shortcut keystrokes may be different on your machine.You’ll start at the very beginning by opening and saving your first Excel document. Then you’ll move on to:Create a basic Kitchen Remodel Costs worksheet.Learn to use the 7 most popular functions in Excel, including IF functions and VLOOKUP.Create professional looking pie charts, bar charts, column charts and more.Create a table and a range and sort your data.Create pivot charts and tables to do lightening fast analysis of your data.Learn to use new features of Excel including 1-click forecasting and 3D maps.Take your Excel skills to a whole new level to impress your boss and (although it’s ultimately up to you) position yourself for the raise or promotion you deserve.Excel can be challenging to learn. The hardest part is knowing what to learn. This course is designed to teach you the most popular functions and features of Excel that most people wish they knew how to do. This includes the 7 most popular functions, which you’ll learn in this course:VLOOKUPCOUNT & COUNTACOUNTIF & COUNTIFSAVERAGE & AVERAGEASUM, SUMIF & SUMIFSIFLEFT, RIGHT & MIDHere are more of the most sought after skills in Excel that are included in this course:SpreadsheetsTablesRangesPie, Column, Bar and Line chartsPivot tablesPivot chartsTons of tips and tricks to make using Excel easier every day.So if you’re ready to take your Excel skills to the next level and want to learn in an easy-to-follow way, click the Buy now button or check out one of the free preview lectures and I’ll see you in the course.100% Satisfaction GuaranteedDid you know that Udemy has a 100% 30-day money back guarantee on all courses? I know that you’ll love this course, but Udemy’s guarantee means that you can watch this entire course and if it doesn’t meet your expectations for mastering Excel, we’ll refund your money and all your new Excel knowledge is free. So if you’re even considering learning more about Excel for that new job, raise or promotion, sign up for the course and see what is possible with the right knowledge.

Overview

Section 1: Introduction to Microsoft Excel

Lecture 1 Introduction

Lecture 2 How to Get the Most Out of This Course

Lecture 3 Take a Tour of the Excel Dashboard – How to Use the Tabs and Ribbon

Lecture 4 Using Excel Templates to Save Time and Effort

Section 2: Creating Your First Excel Document

Lecture 5 Saving Your Document Where You Can Find It

Lecture 6 Entering Data and Navagating Around the Cells

Lecture 7 Creating Simple Formulas to Do Powerful Calculations

Lecture 8 Working with Workbooks and Worksheets

Lecture 9 Put Your Knowledge to Work – Create Your First Excel Document

Section 3: Create a Kitchen Remodel Cost Worksheet

Lecture 10 Introduction – Creating and Formatting Your Heading

Lecture 11 Formatting Subheadings and Columns and Alphabetizings Lists

Lecture 12 Entering and Formatting Numbers

Lecture 13 Create Formulas to Quickly Calculate Your Costs

Lecture 14 Formatting – Grids and Spacing

Section 4: Introduction to Excel Formulas and Functions

Lecture 15 Introduction to Excel Formulas and Functions

Lecture 16 What is a Formula and What Can It DO for You?

Lecture 17 What is a Function and What Does IT Do?

Section 5: 3 Things to Know Before You Start Using Functions

Lecture 18 The Anatomy of a Formula

Lecture 19 Quickly Select Cells to Use in Your Formula

Lecture 20 Absolute vs. Relative Cell References

Lecture 21 Excel Shortcuts for Mac

Section 6: How to Use the 7 Most Popular Excel Functions

Lecture 22 How to Use the Downloads to Learn Functions Faster

Lecture 23 AVERAGE and AVERAGEA Functions

Lecture 24 COUNT, COUNTA and COUNTBLANK Functions

Lecture 25 IF Functions

Lecture 26 SUMIF and SUMIFS Functions

Lecture 27 COUNTIF and COUNTIFS Functions

Lecture 28 VLOOKUP Function

Lecture 29 LEFT, RIGHT and MID Functions

Section 7: Other Popular Excel Functions

Lecture 30 CONCATENATE – Combining Text

Lecture 31 LEN – Length of Text

Lecture 32 FIND and SEARCH

Lecture 33 MIN and MAX

Lecture 34 AND and OR

Lecture 35 ROUND, CEILING and FLOOR

Lecture 36 TODAY and NOW

Lecture 37 CONDITIONAL FORMATTING

Lecture 38 ALT Shortcut Keys for INDEX/MATCH Lecture

Lecture 39 INDEX and MATCH

Lecture 40 UPPER, LOWER, and PROPER

Section 8: Creating Charts From Your Spreadsheet

Lecture 41 Charts Download

Lecture 42 Introduction – How to Create a Chart

Lecture 43 Format Your Chart

Lecture 44 Create a Bar Chart

Lecture 45 Create a Pie Chart

Lecture 46 Create a Line Chart

Section 9: Pivot Tables and Pivot Charts

Lecture 47 Pivot Tables Download

Lecture 48 Introduction to Pivot Tables – Preparing Your Data

Lecture 49 How to Create a Pivot Table

Lecture 50 Put Your Pivot Table to Work

Lecture 51 Pivot Charts Download

Lecture 52 Pivot Charts

Section 10: Importing Data from Other Sources

Lecture 53 Import from Web, Copy/Paste, and Cleaning Up Data

Section 11: New Features for Excel 2016

Lecture 54 What’s New in Excel 2016?

Lecture 55 6 New Chart Types for 2016

Lecture 56 “Tell Me What You Want To Do” – The New Help Feature

Lecture 57 1-Click Forecasting

Lecture 58 3D Maps

Section 12: Excel Quick Tips and Tricks

Lecture 59 Flash Fill and Auto Fill for Fast Data Entry

Lecture 60 Shortcut Keystrokes for Working Faster

Lecture 61 Paste Special for Better Pasting

Lecture 62 Laying Out Pages and Printing

Lecture 63 Find and Delete Empty Cells Located Outside of Your Data

Lecture 64 Use the Power of Tables

Section 13: Conclusion

Lecture 65 Conclusion

Lecture 66 How to Get Your Course Certificate

Lecture 67 Learn More – Other Courses by Steve McDonald (bonus lecture)

This course is perfect for a first time beginner who needs to learn much more than just the basics.,This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.,This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.,This course would not be useful for an Excel user who has already reached the advanced or expert stage.

Course Information:

Udemy | English | 6h 53m | 3.74 GB
Created by: Steve McDonald

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

New Courses

Scroll to Top