Главная IT и ПО Операционная система Windows EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

EXCEL at Work - Complete MS Excel Mastery Beginner to Pro

4.6 (5217)

Онлайн-курс

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

Английский

7 часов курса

Курс от Udemy

$ 64.99

Продолжительность: 7 ч
Уровень: Начинающий
Язык: Английский
Заинтересовано: 54674
Сертификат: Да

Чему вы научились?

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.

О курсе

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

Лекторы

Steve McDonald

Dedicated Instructor Will Help You Excel | 300K+ Students

Платформа

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

Рейтинг

4.6