"Your Excel skills could land your next job."

Description

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

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:

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

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.

• 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 content

• Introduction to Microsoft Excel
  • Introduction
  • How to Get the Most Out of This Course
  • Take a Tour of the Excel Dashboard - How to Use the Tabs and Ribbon
  • Using Excel Templates to Save Time and Effort
• Creating Your First Excel Document
  • Saving Your Document Where You Can Find It
  • Entering Data and Navagating Around the Cells
  • Creating Simple Formulas to Do Powerful Calculations
  • Working with Workbooks and Worksheets
  • Put Your Knowledge to Work - Create Your First Excel Document
• Create a Kitchen Remodel Cost Worksheet
  • Introduction - Creating and Formatting Your Heading
  • Formatting Subheadings and Columns and Alphabetizings Lists
  • Entering and Formatting Numbers
  • Create Formulas to Quickly Calculate Your Costs
  • Formatting - Grids and Spacing
• Introduction to Excel Formulas and Functions
  • Introduction to Excel Formulas and Functions
  • What is a Formula and What Can It DO for You?
  • What is a Function and What Does IT Do?
• 3 Things to Know Before You Start Using Functions
  • The Anatomy of a Formula
  • Quickly Select Cells to Use in Your Formula
  • Absolute vs. Relative Cell References
  • Excel Shortcuts for Mac
• How to Use the 7 Most Popular Excel Functions
  • How to Use the Downloads to Learn Functions Faster
  • AVERAGE and AVERAGEA Functions
  • COUNT, COUNTA and COUNTBLANK Functions
  • IF Functions
  • SUMIF and SUMIFS Functions
  • COUNTIF and COUNTIFS Functions
  • VLOOKUP Function
  • LEFT, RIGHT and MID Functions
• Other Popular Excel Functions
  • CONCATENATE - Combining Text
  • LEN - Length of Text
  • FIND and SEARCH
  • MIN and MAX
  • AND and OR
  • ROUND, CEILING and FLOOR
  • TODAY and NOW
  • CONDITIONAL FORMATTING
  • ALT Shortcut Keys for INDEX/MATCH Lecture
  • INDEX and MATCH
  • UPPER, LOWER, and PROPER
• Creating Charts From Your Spreadsheet
  • Charts Download
  • Introduction - How to Create a Chart
  • Format Your Chart
  • Create a Bar Chart
  • Create a Pie Chart
  • Create a Line Chart
• Pivot Tables and Pivot Charts
  • Pivot Tables Download
  • Introduction to Pivot Tables - Preparing Your Data
  • How to Create a Pivot Table
  • Put Your Pivot Table to Work
  • Pivot Charts Download
  • Pivot Charts
• Importing Data from Other Sources
  • Import from Web, Copy/Paste, and Cleaning Up Data
• New Features for Excel 2016
  • What's New in Excel 2016?
  • 6 New Chart Types for 2016
  • "Tell Me What You Want To Do" - The New Help Feature
  • 1-Click Forecasting
  • 3D Maps
• Excel Quick Tips and Tricks
  • Flash Fill and Auto Fill for Fast Data Entry
  • Shortcut Keystrokes for Working Faster
  • Paste Special for Better Pasting
  • Laying Out Pages and Printing
  • Find and Delete Empty Cells Located Outside of Your Data
  • Use the Power of Tables
• Conclusion
  • Conclusion
  • Learn More - Other Courses by Steve McDonald (bonus lecture)