EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

4.6

5 217 комментариев

Обучение платное

Сертификация бесплатная

7 часов курса

О курсе

"Your Excel skills could land your next job."

- Fortune Magazine

A 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:

VLOOKUP

COUNT & COUNTA

COUNTIF & COUNTIFS

AVERAGE & AVERAGEA

SUM, SUMIF & SUMIFS

LEFT, RIGHT & MID

Here are more of the most sought after skills in Excel that are included in this course:

Spreadsheets

Tables

Ranges

Pie, Column, Bar and Line charts

Pivot tables

Pivot charts

Tons 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 Guaranteed

Did 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.

Программа

Introduction to Excel 2016

At the end of this section you will be able to start an Excel worksheet/spreadsheet, enter data into your spreadsheet, create a heading, use a simple formula and save your file where you can find it.

Introduction

In this course you'll start out at the very beginning, opening an Excel document and saving it onto your computer. Then, you'll create your first Excel spreadsheet including data entry, formatting and even using simple formulas.Once you've created your first spreadsheet you'll learn how to use themost popular Excel functions for powerful calculations. Next, you'll learn how to use some of the new featuresof Excel 2016, such as 3D Mapping and 1-Click Forecasting. Finally you'll learn how to create tables, charts, and graphs as well as pivot tables and charts.When you are finished with this course you will have a solid working knowledge of the most commonly usedfeatures in Excel. The course includes Excel file downloads that you can use to follow along with the lectures. It also includes practical assignments along the way so you can put what you learn to use right away.

How to Get the Most Out of This Course

There are 3 things you can do to get more out of this course.

Use the speed control to speed up or slow down lectures so you can best understand the audio
Beginners, go through the whole course start to finish. Experienced Excel users should skip to the parts they need to learn.
Download and use the Excel workbook provided. Practice with them as you go through the lectures.

Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon

This lecture is a complete tour of the various Excel dashboards and interfaces. It will show you how to use the tabs and ribbons at the top of an Excel workbook, how to navigate the file menu to save, print and customize documents in Excel. And it gives you a tour of the many features and tools available to you in Excel 2016.

Using Excel Templates to Save Time and Effort

Templates are an often overlooked aspect of Excel. Using the right template can save you tons of time creating and formatting your own spreadsheets. It also allows you to take advantage of Excel tools and features that you wouldn't otherwise learn to use.Even though templates are ready to use, they still require an understanding of the way Excel works. After you complete this course you'll not only be able to create and use many Excel functions and features, you'll also be able to better utilize templates because you'll have the understanding to use them correctly and even to modify them to best suit your needs.

Creating Your First Excel Document

At the end of this section you will be able to create a basic spreadsheet in Excel, save it where you can find it and even set up some simple calculations using formulas in Excel.

Saving Your Document Where You Can Find It

The first step to successfully creating your first spreadsheet is opening and saving a document. This lecture will show you how to do that and how to save it to a place where you can find it later.

Entering Data and Navagating Around the Cells

Quickly learn how to enter data into cells in your worksheet and move from cell to cell.

Creating Simple Formulas to Do Powerful Calculations

Learn how to create simple but powerful addition and multiplication formulas. These will prepare you to do the calculations necessary for the Kitchen Remodeling Cost worksheet later in the course.

Working with Workbooks and Worksheets

In this lecture I'll show you the difference between a workbook and a worksheet. I'll also teach you various ways of moving, copying, renaming and managing your worksheets within, and between different workbooks.

Put Your Knowledge to Work - Create Your First Excel Document

Activity. Now it's time to put what you have learned into practice.

Create a Kitchen Remodel Cost Worksheet

At the end of this section you will be able to create a Kitchen Remodel Worksheet from scratch, including addition and multiplication formulas and simple formatting to make your spreadsheet look good.

Требования

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

Что Вы изучите?

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.

Лекторы

Steve McDonald

Dedicated Instructor Will Help You Excel | 300K+ Students

Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals.

My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek.

I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.

I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.

I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.

I'm always happy to help. I believe in you, and I'm here to support you in your learning process.

Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.

I'll see you in there!

Платформа

Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.

64.99 $ 99.99 $

Продолжительность: 7 ч
Уровень: Начинающий
Уроков: 66
Ресурсы для скачивания: 24
Статьи: 6
Язык: English
Субтитры: English... 1 ещеItalian [Auto]
Заинтересовано: 54.7K
Сертификат: Да