Excel 2013: Beginner to Master
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
Wishlisted Wishlist

Please confirm that you want to add Excel 2013: Beginner to Master to your Wishlist.

Add to Wishlist

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
Created by Koki Gunasinghe
Last updated 9/2015
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create complex spreadsheets in Excel
  • Become a master at Excel
View Curriculum
Requirements
  • You will need Microsoft Excel 2007, 2010, or 2013 installed, although 2013 works best.
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.

Who is the target audience?
  • People who know little to nothing about Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 34 Lectures Collapse All 34 Lectures 01:55:50
+
Fundamentals
13 Lectures 38:37
Learn all about me.
Preview 01:20

Introduction. Learn what we'll learn in this course.
Preview 03:54

Learn what Excel is and what it does, as well as some history of the program.


Preview 02:32

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

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

Basic Skills: Undoing, Redoing, Saving, Adding Sheets
02:55

Learn how to merge cells.

Merging cells and other formatting
03:21

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

The ribbon
02:27

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

Learn the differences of Workbook and Worksheet.

Workbook, Worksheet, what's the difference?
01:40

Learn how to edit rows and columns in Excel and the differences they have.
Editing rows and columns
02:05

Learn how to format cells so they show the format you want.
Formatting cells
03:15

Learn how to protect workbooks/worksheets so only people with the password can access them.
Protecting worksheets/workbooks
03:56

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

SImple math functions: SUM, COUNT, MIN, MAX
05:42
+
Intermediate Stuff
10 Lectures 29:23
Learn how to sort data in Excel.
Sorting Data
02:00

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

Freezing rows and columns
03:49

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

SUMIF and SUMIFS functions
02:56

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

COUNTIF and COUNTIFS functions
01:36

Learn how to use this function to hide errors.

IFERROR and IFNA functions
04:10

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

IF function
01:48

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

CONCATENATE function
02:14

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

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

Conditional Formatting
03:41

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

Named Ranges
03:41
+
Advanced Stuff
6 Lectures 23:15
Learn what Macros are and about the developer tab.
Developer tab and Macros
04:40

Learn how to use these functions to perform data lookups.
VLOOKUP and HLOOKUP functions
04:08

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

Using the INDEX and MATCH functions as a substitute for VLOOKUPKUP.
03:44

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

ISNUMBER, ISTEXT, ISEVEN, ISODD, and more value testing functions.ions.
03:09

Learn what , when ,and how to create nested IF functions in Excel.
Nested IF functions
04:38

Learn how to use Data Validation to restrict cell entries.
Data Validation
02:56
+
Example Spreadsheets
4 Lectures 22:34
Create a spreadsheet that adds up and averages school grades.
Beginner: Simple school grade spreadsheet
05:43

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

Intermediate: Pie chart spreadsheet
02:33

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.)
Advanced: Automatically updating date spreadsheet
08:44

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.
Advanced: Break-even calculator spreadsheet
05:34
+
Conclusion
1 Lecture 02:01

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

Leaving a review on Udemy
02:01
About the Instructor
Koki Gunasinghe
0.0 Average rating
0 Reviews
2 Students
1 Course
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.