Excel 2013: Beginner to Master

Learn how to go from knowing nothing to knowing lots in Microsoft Excel.
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
2 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 34
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2015 English

Course Description

Learn the basic, intermediate, and advanced knowledge needed to make great spreadsheets in the program Microsoft Excel.

Build a strong foundation in Excel and amazing spreadsheet programming with this tutorial for intermediate and beginner people.

  • Functions
  • Formatting
  • Dashboard Design

A Powerful Skill at Your Fingertips
Learning Excel will make your life much more easier. With Excel, you'll be able to create spreadsheets to make your life earier.

You can sell your spreadsheets on Ebay or Etsy to make money, as I do right now. Also, Excel knowledge will help you in your life.

Content and Overview

Suitable for mainly intermediate and beginner people, through this course of 34 lectures and 2 hours of content, you'll learn all of the Excel fundamentals and core knowledge, make spreadsheets, and establish a strong understanding of the concept behind making perfect spreadsheets, in only 2 hours of your time!

Starting with the basics such as saving, formatting, and all that, your knowledge builds as you program different stuff. Each new concept builds on the last one.

With these basics mastered, this course will take you through complex functions by teaching you how to use the IF, VLOOKUP, INDEX, and MATCH functions to add complexity and functionality to your programs.

Students completing the course will have the knowledge to create functional and useful Excel spreadsheets.

You'll be able to work alongside me as you work through each concept, so you won't get confused.

What are the requirements?

  • You will need Microsoft Excel 2007, 2010, or 2013 installed, although 2013 works best.

What am I going to get from this course?

  • Create complex spreadsheets in Excel
  • Become a master at Excel

What is the target audience?

  • People who know little to nothing about Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Fundamentals
01:20
Learn all about me.
03:54
Introduction. Learn what we'll learn in this course.
02:32
Learn what Excel is and what it does, as well as some history of the program.


02:46
Learn how to move around in Excel.
02:55

Learn the basic skills to use Excel: Undoing, Redoing, Saving, Adding Sheets

03:21

Learn how to merge cells.

02:27

Learn what the ribbon is and some of the features it contains.

02:44
Learn what the quick access toolbar is, how it helps you, and how to customize it.
01:40

Learn the differences of Workbook and Worksheet.

02:05
Learn how to edit rows and columns in Excel and the differences they have.
03:15
Learn how to format cells so they show the format you want.
03:56
Learn how to protect workbooks/worksheets so only people with the password can access them.
05:42

Learn the syntax for each of these functions and what each one does.

Section 2: Intermediate Stuff
02:00
Learn how to sort data in Excel.
03:49

Learn how to freeze rows and columns so that you can scroll down in 1 section and leave 1 section unscrolled.

02:56

Learn how to use these functions to sum only certain cells in a range.

01:36

Learn how to use these functions to count certain cells in a range.

04:10

Learn how to use this function to hide errors.

01:48

Learn how to use one of the mos widely used functions on Excel, the IF function.

02:14

Learn how to use the CONCATENATE function to join different cells.

03:28
Learn how charts work and how to make them in Excel.
03:41

Learn how to use conditional formatting so that cells format themselves based on a function.

03:41

Learn how to name ranges so you can refer to certain cells easier.

Section 3: Advanced Stuff
04:40
Learn what Macros are and about the developer tab.
04:08
Learn how to use these functions to perform data lookups.
03:44

Learn how to use the INDEX and MATCH functions as a substitute for VLOOKUP and when to use them.

03:09

Learn the value testing functions: ISNUMBER, ISODD, ISEVEN, ISBLANK, ISFORMULA functions

04:38
Learn what , when ,and how to create nested IF functions in Excel.
02:56
Learn how to use Data Validation to restrict cell entries.
Section 4: Example Spreadsheets
05:43
Create a spreadsheet that adds up and averages school grades.
02:33

Create a spreadsheet that creates a pie chart with data entered randomly.

08:44
Create a spreadsheet, that automatically updates based on current date (eg. If it's 6/7/15, 4 cells on the spreadsheet will say .Mar-2015, Apr-2015,May-2015,Jun-2015. If it's 7/8/15, the dates will shift left.)
05:34
Create a spreadsheet that takes in a purchase and selling price, and with the push of a button, determines the selling price to make a $0 profit.
Section 5: Conclusion
02:01

In case you wanted to leave a review for this course, this lecture will show you how.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Koki Gunasinghe, Excel Programmer

I am a 13 year old residing in Colorado, United States. In my free time, I love to make spreadsheets. I'd like to share my knowledge with the world, as well as raise money for my college funds. I also find it fun and relaxing. That is why I teach on Udemy.

Ready to start learning?
Take This Course