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.
49 students enrolled
$20
Take This Course
  • Lectures 43
  • Contents Video: 1.5 hours
  • Skill Level Beginner Level
  • 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/2014 English

Course 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.

What are the requirements?

  • Internet connection
  • Computer
  • Microsoft Excel 2013
  • And the most important thing a great passion to learn new things that will boost our productivity.

What am I going to get from this course?

  • 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

What 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.

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: Introduction
What we'll be covering
Preview
04:40
Section 2: Getting Started
Starting a workbook
01:52
Knowing the workbook
Preview
04:13
The Backstage view
01:03
Backstage.1 Options
01:36
Backstage.2 Share via e-mail
Preview
01:15
Backstage.3 Inviting people
Preview
00:46
Opening a workbook
00:55
Saving a workbook
01:27
Section 3: Basic Worksheet skills
Selecting Data and No Contiguous groups of cells
Preview
01:03
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
Section 4: Creating a Workbook and Formatting
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
Section 5: Formulas
Introduction to formulas
04:44
Order of operations
03:42
Relative and absolute references
04:34
Introduction to Functions
05:22
Section 6: Working with big workbooks
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
Section 7: Printing
Page Lay out view
01:42
Page breaks
01:17
Working with headers
01:15
Printting
01:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gilberto Berlanga, 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

Ready to start learning?
Take This Course