The Complete Excel 2013 Course for Beginners: Learn by Doing

The Drop-Dead Simple Method to Mastering Microsoft Excel 2013 and VBA, Without Books, in Less Time Than You Thought
4.5 (9 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.
1,116 students enrolled
90% off
Take This Course
  • Lectures 140
  • Length 23.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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 8/2015 English

Course Description

Master the Ins and Outs of Microsoft Excel 2013 and Automate Repetitive Tasks

Contents and Overview

The course is designed for individuals and office professionals who need to master the capabilities of Microsoft Excel 2013. The course also includes advanced level training for individuals and professionals who are new to VBA (Visual Basic for Applications) and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.

Through 23 hours of video lectures and 3 quizzes, you'll learn the essentials with these 3 popular courses:

  • Excel 2013 Beginning/Intermediate: Create basic spreadsheets and use formulas for tracking expenses.
  • Excel 2013 Advanced: Learn complex formulas and perform data analysis on your organization's revenue and expense patterns.
  • VBA for Excel: Discover how to help automate time-consuming procedures in Excel.

When you complete this course, you'll be well on your way to becoming a master with Microsoft Excel 2013.

This bundle includes:

  1. 23 hours of video tutorials
  2. Over 130 individual video lectures
  3. Exercise files to practice what you've learned
  4. 3 optional quizzes with 100+ test questions
  5. Certificate of completion

Courses included with this Bundle:

Microsoft Excel 2013 Beginners/Intermediate Training

During this 10-hour Online Excel 2013 Training, you'll learn to create Excel spreadsheets with ease. Our expert instructor will show you Excel 2013 features to navigate you through the program. Starting with the basics, you'll discover how to enter and format data in the quickest manner possible. Next you'll be introduced to the power of Excel's functions and formulas to help you calculate data and derive useful information. To help you present it all in a visually appealing format, your instructor will then walk you through how to create sophisticated charts and graphs, and publish them online. Finally, you'll learn to analyze and review worksheets for data discrepancies so you can prevent problems before they arise.

Turn your long lists of numbers into slick, engaging visuals that bring data to life. Whether you need to create budgets, financial projections, invoices, calendars, schedules, or lists, our elaborate Excel 2013 Tutorial will give you the skills you need to stand out at work.

Learn Microsoft Excel 2013 – Advanced

Colorful charts, sleek graphs, and cutting-edge databases that offer insight into financial information are a breeze when you learn the secrets of creating sophisticated spreadsheets in our Learn Excel 2013 – Advanced course. That's because you'll get the tools you need to master Excel's powerful data functions in this information-packed 9-hour video training class.

Your expert instructor will kick the course off by leading you through graph and chart basics. Then, you'll explore Excel's array of detailed formatting tools and discover how to make these work for you when graphing and charting financial information. Next, you'll explore the roles played by trends, relationships, and differences in charts, and how to work with sparklines for data visualization and data bars. The course will also take you through detailed discussions of pivot tables, bubble charts, radar charts, and more.

Essential VBA Training for Excel - Automate Repetitive Tasks

Great for automating repetitive tasks and operations that you perform frequently, VBA is a powerful tool to increase your productivity.

The course is designed for individuals and professionals who are new to VBA and who are seeking practical ways to automate tasks in Microsoft Excel that are performed frequently.

Through 4 hours of video lectures, exercise files, and an optional quiz, you'll learn the essentials you need to know to create powerful macros using VBA for Excel.

Find out how to use the VBA editor, VBA syntax, keywords, and comments.

Discover how to define and manage variables, set up subroutines, and create functions.

Also, find out how to use input boxes and message boxes to interact with end users.

Learn practical methods for using macro errors to improve your VBA code.

When you complete this course, you'll be well on your way to using VBA macros in Excel to help you and others automate tasks and operations performed frequently.

What people are saying:

"I am now a business analyst and I attribute my promotion directly to your courses. I'm much more savvy and confident with Excel. Thanks Simon."- Daniel Venti

"Simon Sez IT is one of the best resources if you are looking for Microsoft Office tutorials."- Top Ten Reviews

"Generally I wouldn't find this type of course all that interesting. However, I have found in my current job search that it is a necessary part of my tech skill set in which to become proficient. So, I'm very appreciative that courses like this are offered, and taught by an extremely knowledgeable instructor, who explains lessons clearly and offers opportunities to practice the theme which he has just gone over. He was thorough, and not in the least bit condescending, which I can't say for instructors I have had in the past. So, thank you."- Mary Price

"This is a fantastic intro to the advanced operations in Excel 2013."- Terril Wright

"This is the one....Simon Sez IT has always been my favorite. Excellent contribution by the author. The lectures are informative and engaging. Style of teaching is enterprising."- Jay Dhruv

"The best beginners course out there. Very easy to follow, throughout and detailed explanation to each function and step shown in the process. Ideal learning curve for the total Excel newbie like me."- Daniel Salwerowicz

"Excellent course. I have some experience with Excel but this course really helped me know the functions available in it and how to use them. The instructor explains the subject very patiently and clearly so the student can follow along and master the details. Production quality was good."- Vikram Hegde

"Excellent course (VBA course). Absolutely helpful course designed to guide you step by step through basic and advanced VBA code. Very well structured. Instructor sounds calm and competent. Easy to follow the course if you take your time. Exercises are challenging and helpful. Can highly recommend taking this course."- Oliver

Our videos are high definition; therefore, they are best viewed with the HD setting on and the videos enlarged.

What are the requirements?

  • Microsoft Excel 2013
  • Intermediate knowledge of Microsoft Excel is required before starting the advanced material and VBA course

What am I going to get from this course?

  • Data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
  • Tips for mouse and touch screen users.
  • Graphs and charts using templates or custom designs.
  • SkyDrive and other tools for sharing work.
  • Pivot tables and slicing.
  • Working with flash fill.
  • Bonus exercise files.
  • Working with dates and times
  • Averages, percentiles, and LINEST functions
  • Calculating depreciation
  • Inserting and formatting tables
  • Sparklines and data bars
  • Pivot charts
  • How to automate tasks and operations that you perform frequently.
  • How to set Excel up for VBA.
  • General syntax rules, what keywords are, and how to add comments.
  • What variables are, and how they relate to functions versus methods and subroutines.
  • How to specify different variables, including arrays, and how to manage them in code
  • How to use intellitext with variables, particularly those that are defined constants
  • What functions are, how they are used, and how to stage a scenario to complete
  • How functions return values
  • How to use input boxes and message boxes to interact with the user
  • The intricacies surrounding creating an array formula
  • How to use the application object to control the user experience
  • How to use the workbook and worksheet objects and how they function as data containers.
  • How to use errors to improve your code
  • How to use the name and names object to manage named ranges
  • General information about the PivotTable object and basic approaches to utilizing it

Who is the target audience?

  • Anyone new to Microsoft Excel or upgrading from a previous version.
  • Those wanting to automate repetitive Excel tasks to improve productivity

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.


Section 1: Excel 2013: Introduction to Excel 2013 Beginner Course
Introduction to Excel 2013
Essential Information for a Successful Training Experience
Course exercise files
What's New
Section 2: Excel 2013: Using Touch
Overview of Principles
Section 3: Excel 2013: Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Templates; Creating, Opening, and Saving a Workbook
Section 4: Excel 2013: Help
Online, Offline, and Contextual Help
Section 5: Excel 2013: Settings and Preferences
Excel Options
Section 6: Excel 2013: The Ribbon and Toolbars
Ribbon Interface
Quick Access Toolbar
Mini Toolbar
Section 7: Excel 2013: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave
Section 8: Excel 2013: Entering and Deleting Data
Entering Text and Numbers
Date Formats
Formatting Cells; Editing and Deleting Data
Flash Fill
Section 9: Excel 2013: Formatting a Worksheet
Themes and Cell Styles
Inserting, Deleting, Hiding and Adjusting Rows and Columns
Wrap Text and Alignment
Merging Cells; Applying Themes and Styles
Section 10: Excel 2013: Copy, Paste and Paste Special
Copy, Cut and Paste
Section 11: Excel 2013: Proofing
Spell checking
Section 12: Excel 2013: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
Section 13: Excel 2013: Comments
Inserting Comments
Section 14: Excel 2013: Viewing and Printing
Workbook Views, Zoom and Freeze
Printing; Headers, Footers and Margins
Section 15: Excel 2013: Formulas and Functions
Overview of Formulas and Functions
Cell References
Finding Errors; New Excel Functions
Section 16: Excel 2013: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks
Section 17: Excel 2013: Find and Replace
Go to; Find and Replace Options
Section 18: Excel 2013: Conditional Formatting
Applying, Clearing and Managing Rules
Section 19: Excel 2013: Graphing and Charting
Chart Types; Chart Recommendation
Basic Formatting
Selecting Data, Positioning and Printing Charts
Section 20: Excel 2013: File Types
Saving Workbooks; PDF and CSV Formats
Section 21: Excel 2013: Managing Data
Section 22: Excel 2013: Functions Case Study
Text Function
Date and Time Functions
Logical Functions
Section 23: Excel 2013: Analyzing Data
Financial Analysis Case Study - Part 1
Financial Analysis Case Study - Part 2
Quick Analysis Tool
Section 24: Excel 2013: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
Section 25: Excel 2013: Sharing and Protecting
Protecting Worksheets
Protecting Workbooks
Sharing and SkyDrive
Section 26: Excel 2013: More Backstage View Options
Trust Center; Export; Inspect Workbook
Section 27: Excel 2013: Closing
Summary; More Help
Microsoft Excel 2013 Quiz
45 questions
Section 28: Excel Advanced: Introduction to Excel 2013 Advanced
Pre-requisites of Excel 2013 Advanced Course
Essential Information for a Successful Training Experience
Course exercise files
Section 29: Excel Advanced: Functions
List of Functions; Common Types of Arguments; Basic Use of Functions
Advanced Aspects of Functions; Searching for a Function
Section 30: Excel Advanced: Personal and Professional Financial Functions
Future Value
Principal Payment
Section 31: Excel Advanced: Date and Time Functions
Course Review
How Dates and Times are Stored

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, 280,000+ Students | Wordwide Use 180 Countries |115 Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With 80+ courses and 4,500+ video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 280,000 Udemy students in over 180 countries, Simon Sez IT is the preferred eLearning choice for individuals and businesses everywhere.

Ready to start learning?
Take This Course