Microsoft Excel 2013 Training for Beginners / Intermediate

Handle your workload 500% faster and get that promotion you deserve.
4.9 (7 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.
389 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 98
  • Length 8.5 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 7/2014 English

Course Description

I Will Teach You The Best Way to Automate Your Work, so You Can Impress Your Boss, Work Less and Get More Done Even if you know nothing about excel, automation or spreadsheets.


Have you ever been bored, or frustrated at work?

The fact is, most jobs nowadays make you deal with calculus, tables, schedules, team management, projects, organization tasks etc.

These tasks are repetitive, mind-numbing and time consuming.

You may have experimented with Excel before, automating little tasks and saving some time here and there.

You probably still feel overworked, under appreciated and frustrated though.

Well, I have some great news for you.

Now, you can work less, get more done, and get that promotion you deserve, all while doing less work.

You can do all this easily with Excel. Seriously.

You may have experimented with Excel in the past, set up some formulas and saved some time, but nothing that was absolutely life changing.

Let me tell you what I've accomplished with Excel in the last five years.

I was able to get promoted every 6 months on average, working at competitive Multinational Technology Companies.

That’s around three times as fast as most employees can hope for.

The reason why I was able to get promoted at such a rocket rate is because no-one can keep up with me.

I consistently impressed my bosses, and all my co-workers were jealous of how little I worked, and how much I got done.

Since I was so much more productive, I was consistently rewarded with more money, benefits and a new role.

I’ll tell you exactly how in a minute, but first let me make sure this course is for you.

This course is designed specifically for professionals who are looking to ramp up their career through learning new skills that will teach them how to use excel to manage staff effectively, increase their productivity and develop more efficient projects.

You also should have the latest version of Excel. (It will still work with older versions, but you won’t get the full benefits.)


Okay, if you’re still reading I assume you fit into that category, so let’s go over exactly what you’ll get in this course, you’ll learn:

  • The right mindset to start using Excel, and how to approach the course.
  • The basics taught in an easy, intuitive manner.
  • The difference between workbook and worksheets, and when to use each.
  • How to save and protect your sensitive files properly.
  • The best way to set up automated dashboards
  • 16 Ways to organize and manipulate data.
  • How to create formulas and charts that will do your work for you.

  • Sounds helpful right? You know you want these benefits, and it’s only $69 so go ahead and grab your unique course code now.

    You’ll also get a certificate of completion, so you can add that to your Linkedin profile to boost your credibility.

    I’ve thought about this a lot, and the only reasons I could think of that anyone who could benefit from this course wouldn’t get it is because they already know it, or they think they can learn it on their own.

    If you already know how to automate your work, get more done in less time and avoid mind numbing robotic tasks on your own, congratulations, that’s spectacular.

    If you spent the time to learn all these techniques it would take you at least 100 hours of studying. (I know, because I did that.)

    Even if your time is only worth $15 an hour, that would be a $1,500 investment.

    Instead, I’ll show you exactly what you need to know, and make sure you get it through quizzes for only $12.

    Logically, it just makes sense. Join over 300+ satisfied professionals now.

    You can’t get this information in this concise and in-depth of a course anywhere else.

    I know, I checked.

    Oh, and one more thing, you have absolutely no risk.

    I offer an unconditional 30 day money back guarantee. No hassles, no hard feelings.

    Don’t let more years of your life slip away entering data, and doing mindless work that should be automated.

    Enroll Now! Start your path to your next promotion today!

    What are the requirements?

    • A working computer or tablet PC with the Microsoft Excel 2013 or 2010 application

    What am I going to get from this course?

    • • 8+ hours of training
    • • 98 Lessons, 12 Quizzes, 12 Workbooks
    • - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
    • By the end of the course you will be able to:
    • • Create, Save and Print worksheets
    • • Understand all the basics around Microsoft Excel 2013
    • • Create and manage 10 of the Top Formulas
    • • Manipulate online and offline pictures
    • • Create, understand and manage the different types of charts
    • • Understand and manage conditional formatting
    • • Create Pivot Tables
    • • Sort and filter tables with advanced features

    What is the target audience?

    • The course aims to target the inexperienced users and those with a good partial Excel Knowledge. It is also a great refresher training for advanced users.

    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 to the course
    00:55

    Introduction of the course

    What is Microsoft Excel?
    Preview
    01:05
    What will you learn from this course?
    Preview
    00:55
    Earn your certificate of completion
    Preview
    00:32
    Section 2: Understanding the basics
    Understanding the basics Intro
    Preview
    00:50
    Create a new template
    06:25
    3D Index
    Preview
    03:09
    Workbook and Worksheets
    01:44
    Ribbon
    06:19
    The formula bar
    07:22
    Entering Data
    02:42
    Excel Operators
    Preview
    10:16
    Find and Replace Tool
    09:00
    Hide Columns and Rows
    02:31
    Shortcuts
    6 pages
    Understanding the basics
    6 questions
    Section 3: Save a file
    Intro
    00:43
    Saving the workbook
    05:08
    Different Extensions
    03:17
    Auto Recover
    02:49
    Protect File
    07:38
    Save a file
    3 questions
    Section 4: Printing and Sharing
    1 - Intro
    00:36
    Let's Print
    01:09
    Print Selection
    01:46
    Print the Workbook
    01:46
    Print to file
    01:59
    Page Orientation
    01:43
    Printing and Sharing
    3 questions
    Section 5: Getting started with data
    Intro
    02:36
    Copy and Paste
    05:04
    Paste Special
    04:47
    Undo & Redo
    03:00
    Format cells
    04:40
    Wrap text
    03:25
    Merge data
    04:06
    Comments
    07:08
    Hyperlinks
    11:18
    Flash Fill
    07:53
    Insert Equations & Symbols
    04:06
    Worksheet Background
    03:52
    Add and remove worksheets
    09:59
    Protect Worksheets
    05:35
    Freeze Panes
    05:37
    Format Painter
    04:25
    Tables and borders
    06:22
    Text to Columns
    11:15
    Getting started with data
    10 questions
    Section 6: View and Review
    Intro
    00:49
    Page Views
    06:07
    Window arrangement
    08:29
    Spell-Check
    02:52
    Translate
    03:05
    View and Review
    3 questions
    Section 7: Accounting
    Intro
    00:36
    Change Currency
    03:22
    Decimal Values
    03:30
    Format with percentage and comma
    06:07
    Accounting
    3 questions
    Section 8: Top 10 formulas to maximize your productivity
    Intro
    02:15
    What is a formula?
    01:25
    Basic Syntax
    02:49
    SUM
    11:08
    COUNT
    05:38
    AVERAGE
    07:27
    SumIF, CountIF & AverageIF
    10:00
    LEN
    03:58
    IF Statement
    13:06
    "=" Sign
    02:54
    VLOOKUP
    07:45
    Analyse the formula
    09:59
    Lock cell references
    05:48
    Top 10 formulas to maximize your productivity
    8 questions
    Section 9: Pictures and graphics
    Intro
    00:38
    Inserting Pictures
    07:04
    Inserting Shapes
    05:30
    Smart Art
    09:20
    Picture Position
    07:33
    Pictures and Graphics
    3 questions
    Section 10: Creating Charts
    Intro
    00:55
    Why do we need them?
    04:16
    Different chart types
    05:44
    Creating a bar & column chart
    08:45
    Different axis
    13:19
    Trend line VS Limit line
    08:35
    Edit chart data
    05:24
    Data labels
    08:29
    Format chart area
    08:47
    Creating Charts
    4 questions
    Section 11: Conditional Formatting

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Hugo Matos, Entrepreneur and Manager

    As an Entrepreneur, Manager and a specialized trainer, Hugo Matos has vast experience in the IT world.

    With a strong IT, Training and Managerial background, Hugo has worked for worldwide leading class companies, managing their staff and departments effectively. He was responsible for training, developing and managing the "Go live" of several Sony VAIO call centers around the world and has worked closely with the management teams of leading corporate clients such as Lenovo, Kaspersky, Avast, Sony, Microsoft, etc.

    He has a passion for training, the IT field and loves to share his knowledge with those that want to progress in life or those that simply want to enhance their skills.

    Ready to start learning?
    Take This Course