Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel : Get All You Need To Know And Do!
Rating: 4.2 out of 5(1,364 ratings)
67,073 students

Microsoft Excel : Get All You Need To Know And Do!

Microsoft Excel: From Beginner to Advanced!
Created byWarren Chalklen, PhD
Last updated 6/2017
English
English [Auto],Turkish [Auto],

What you'll learn

  • Use Excel terminology
  • Create charts and tables
  • Use formulas such as IF, SUM and VLOOKUP
  • Create and use Pivot Tables

Course content

4 sections • 11 lectures • 1h 0m total length

  • Welcome to the course!4:16

    Explore Microsoft Excel basics from cells and formulas to lookups, averages, charts, and pivot tables, while navigating course features like downloads, quizzes, and Q&A.

  • Introduction9:24

    Explore basic Excel elements, from entering data to using autocomplete, drag-to-fill, and paste special, while learning about workbooks, sheets, and cell locations for formulas.

  • Sort, Filter, Wrap Text and Merge Cells6:28

    Master basic data management in Excel by filtering and sorting data, merging cells for titles, wrapping text, and formatting tabs and cells for clear, readable spreadsheets.

  • About the review1:45

    Provide a five-star review with a typed comment to help improve this course for future students.

  • IF_Countif_Average and Conditional Formatting13:15

    Explore using if, countif, sum, and average formulas to analyze data, then apply conditional formatting with color scales and text or numeric rules to highlight insights.

  • Terminology

Requirements

  • Excel 2013
  • Working internet

Description

A complete template with additional formulas for Mac and PC added for easier use!

Loads of practice exercises!

See FOUR FREE Preview lectures below!

+++++++++++

Become the Excel expert in the room with this value for money course! 

Receive your certificate on completion of this course!

+++++++++++

As a professor and data analyst I have worked with hundreds of people around the world advancing their skills in Excel. I developed a system that rapidly moved them from beginner to expert regardless of their starting skill level. 

And now…I want to share this process with you so you can improve how you use data to inform performance, communicate results through meaningful charts and find information with razor sharp formulas.

++++++++++++

✔ 14+ Lectures and Over 3.5 hours of content!

✔ Easy to Learn Material—free template download available to get started

✔ Project Based Learning—Know Excel through this hands on approach

✔ Apply what you learn to your context

✔ Follow the Best Practices of Top Corporations For Your Context

Five-Star Review: Perfect for beginners.

Here are some facts about Excel:

Today, organizations continue to enjoy the many uses of MS Excel® and rely on the ubiquitous application to complete a wide variety of finance and accounting processes.

  • 89% of companies use Excel for budgeting, planning and forecasting

  • 70% of companies use Excel for mission-critical financial processes

  • 83% of companies use Excel for month-end close processes

Here's what we will cover in this course...

 We start with the Excel terminology, formulas such as IF, SUM, COUNTIF, and then craft charts and tables. Finally, we tie it all together with pivot tables and VLOOKUP

Don't forget to check out the free preview lectures to sample my course. Are you ready to learn with me? By the end of this course students will know:

    • Excel terminology

    • Formulas: IF, SUM, COUNTIF, VLOOKUP

    • Charts, Tables  

    • Create and use pivot tables

Don't wait another day to start learning Excel.

CLICK "TAKE THIS COURSE" TO GET STARTED NOW!

Who this course is for:

  • Anyone ready to move from beginner to expert in Excel

Report abuse