Master Excel 2013: Beginners
5.0 (4 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.
50 students enrolled
Wishlisted Wishlist

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

Add to Wishlist

Master Excel 2013: Beginners

Learn how to use this helpful tool and get the best out of it
5.0 (4 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.
50 students enrolled
Last updated 9/2014
English
Current price: $10 Original price: $20 Discount: 50% off
16 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
By the end of this course you will be able to work with large quatities of data in Excel by applying certain techniques to make everything easier
You will learn how to work with functions, how to manage multiple workbooks and big quantities of data
View Curriculum
Requirements
  • Internet connection
  • Computer
  • Microsoft Excel 2013
  • And the most important thing a great passion to learn new things that will boost our productivity.
Description

This course is intended for complete beginners who want to learn excel but don't have enough time while doing it. The information is explained in the most practical way and most of the videos are really short (less than 3 minutes) so you can take a look at them every time you get a change, so you can learn at your own pace. We will start from scractch You will learn evreything from getting to know the elements of the workbook apply basic formatting,freeze panes, creating custom views, working with formulas, inserting hyperlinks, page breaks, sorting, filtering, wrapping compare sheets etc.

You will be provided with material to work ( the same workbooks used on the videos)so you can practice while you watch the lessons.

We all know that Excel has become a necessity in our working lives so whether you are a student or you are already working, knowing Excel will boost your curriculum and your probablities of finding and keeping a job will definitely improve

There is no pre-requisite for this course. A complete new beginner can start this course.

I will be answering your doubts and questions so you can feel free to ask anything related to the course.

Who is the target audience?
  • A complete new beginner can start this course. There is no pre-requisite for this course.
  • This is great for students, accountants, finance & non-finance professionals, basically for everyone who works with large quantities of data.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 43 Lectures Collapse All 43 Lectures 01:34:57
+
Introduction
1 Lecture 04:40
+
Getting Started
8 Lectures 13:07
Starting a workbook
01:52


The Backstage view
01:03

Backstage.1 Options
01:36



Opening a workbook
00:55

Saving a workbook
01:27
+
Basic Worksheet skills
5 Lectures 10:01

Naming and moving worksheets
02:21

Copy & Paste
03:45

Entering Data using fills
02:03

Changing the default folder for opening & saving
00:49
+
Creating a Workbook and Formatting
6 Lectures 16:24
Formatting the basics
05:11

Creating a Table
02:04

Editing a Table
01:52

Changing column width and row height
01:37

Wrapping, Merging and Orienting text
03:01

Insert move & delete rows & columns
02:39
+
Formulas
4 Lectures 18:22
Introduction to formulas
04:44

Order of operations
03:42

Relative and absolute references
04:34

Introduction to Functions
05:22
+
Working with big workbooks
15 Lectures 26:33
Using the clipboard
01:14

Grouping & Hiding
02:34

Filtering Data
02:04

Sorting Data
01:24

Creating Hyperlinks
01:41

Comparing sheets
01:19

Handling multiple workbooks
00:48

Resizing windows
00:57

Find & Replace
02:25

Freezing Panes
02:10

Check the spelling
02:01

Conditional formatting
03:07

Creating a Custom view
01:43

Creating Hyperlinks to another workbook
01:12

Adding comments
01:54
+
Printing
4 Lectures 05:50
Page Lay out view
01:42

Page breaks
01:17

Working with headers
01:15

Printting
01:36
About the Instructor
Gilberto Berlanga
4.1 Average rating
194 Reviews
7,386 Students
4 Courses
Industrial Engineer

I am an Industrial Engineer, I have more than 6 years teaching Excel and the rest of the Office Suite online. Working as an Industrial Engeneer, you have to make Excel your best friend whether to use it in statistical process, logistics, human resources, purchasing, sales and other departments to maximize productivity so I have gain a lot experience and expertise in Excel that i would like to pass this knowledge to you.

I like to explain using simple words and going straight to the point, that makes it easier for my students to understand the information quickly

I have made my curriculum boosted by my knowledge of the Office Suit, specially with excel, this little tool is a big plus for the companies, so my recomendation if you are not familiar with this software, is not only to learn how to use it but to be an expert, or at least try to be.

I speak English, Spanish, and Portuguese, I love Web Programming