Duration : 04:46:13

Guru : Sankalp Korde

1361 Learners

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.

\r\n\r\n

Are you ready to **land your next job and increase your pay by 13%**?

\r\n\r\n

This course is designed to teach you the basics and beyond of Excel 2016. 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.

\r\n\r\n

**You'll start at the very beginning **by opening and saving your first Excel document. Then you'll move on to:

\r\n\r\n

- \r\n
- Create professional looking
**pie charts, bar charts, column charts**and more. - \r\n
- Create a
**table and a range**and sort your data. - \r\n
- Create
**pivot charts and tables**to do lightening fast analysis of your data. - \r\n
- Learn to use new features of Excel 2016 including
**1-click forecasting and 3D maps**. - \r\n
- 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. - \r\n

\r\n\r\n

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:

\r\n\r\n

- \r\n
- VLOOKUP
- \r\n
- COUNT & COUNTA
- \r\n
- COUNTIF & COUNTIFS
- \r\n
- AVERAGE & AVERAGEA
- \r\n
- SUM, SUMIF & SUMIFS
- \r\n
- IF
- \r\n
- LEFT, RIGHT & MID
- \r\n

\r\n\r\n

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

\r\n\r\n

- \r\n
- Spreadsheets
- \r\n
- Tables
- \r\n
- Ranges
- \r\n
- Pie, Column, Bar and Line charts
- \r\n
- Pivot tables
- \r\n
- Pivot charts
- \r\n
- Tons of tips and tricks to make using Excel 2016 easier every day.
- \r\n

\r\n\r\n

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 **TAKE THIS COURSE **button or check out one of the free basic learning lectures to see if it's the perfect fit for you.

\r\n

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

\r\n

- \r\n
- Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons.
- \r\n
- Learn all of the basics of opening an Excel document, creating a spreadsheet and saving your document to your computer.
- \r\n
- Create a spreadsheet from scratch in Excel.
- \r\n
- Use the most commonly used Excel functions to make powerful calculations.
- \r\n
- Create your own Excel charts, graphs and tables.
- \r\n
- Learn to use several of the new Excel 2016 features such as 1-click forecasting, 3D maps and the Tell Me What You Want to Do feature.
- \r\n
- Create pivot tables and charts for lightening fast sorting and organizing.
- \r\n
- Tons of helpful tips, tricks and shortcuts along the way to help you master the fundamentals of Excel 2016.
- \r\n

\r\n

- \r\n
- This course is perfect for a first time beginner who needs to learn much more than just the basics.
- \r\n
- 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.
- \r\n
- This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.
- \r\n
- This course would not be useful for an Excel user who has already reached the advanced or expert stage.
- \r\n

\r\n