Microsoft Excel 2013 Beginners/Intermediate Training

The Fastest Way to Learn Microsoft Excel 2013 Inside and Out - On Your Schedule
4.1 (45 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.
3,657 students enrolled
$19
$100
81% off
Take This Course
  • Lectures 59
  • Length 14 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 12/2012 English

Course Description

"Expert Led Excel 2013 Training Course Covers the Skills You Need to Spot Complex Trends and Graph them Effectively.”

Impress the people you work with by cultivating advanced spreadsheet skills. During this 10-hour training course, 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 training course will give you the skills you need to stand out at work.

Plus, when you sign up for our online Excel 2013 Training, you’ll also get these 6 BONUSES in addition to the 50+ online course videos:

  1. Downloadable & printable keyboard shortcuts - to help you save time and get your work done faster.
  2. An online quiz (40 questions) - to test what you've learned.
  3. 18 exercise files – to help you become proficient with the material.
  4. Downloadable & printable transcripts (over 200 searchable pages) – to give you another learning option, if you prefer reading but don’t have time to take notes.
  5. 10 hours of downloadable MP3s to play on your favorite audio device - to help you learn in the car, while you walk, or in the gym.
  6. A certificate of completion to tell everyone you've aced the course.

Where else can you find so many extra tools to help you master Excel 2013?!?!

So start learning today. Because being a technology dinosaur isn’t going to get you a promotion or raise!

All of our Excel 2013 training videos are high-definition videos, therefore, they are best viewed with the HD setting on, and the videos enlarged.

What are the requirements?

  • Excel 2013 software installed.

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.

What is the target audience?

  • Users new to Excel 2013 and those upgrading from previous software versions.

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
Introduction to Excel 2013
Preview
09:12
IMPORTANT - Read this to ensure the best video quality!
Article
What's New
Preview
07:31
Course transcripts
229 pages
7 pages

The Excel 2013 exercise/example files consist of a single .ZIP file. You will need to download the SSI Excel Example Files.zip file to your PC or Mac (the file are not compatible with a mobile device) and unzip the file. Once unzipped, all of the exercise/example files will reside in one folder.

Section 2: Using Touch
Overview of Principles
Preview
03:39
Section 3: Getting Started
Starting and Closing Excel; Workbook, Sheets, Cells, Rows, & Columns
Preview
11:20
Templates; Creating, Opening, and Saving a Workbook
Preview
10:54
Section 4: Help
Online, Offline, and Contextual Help
08:00
Section 5: Settings and Preferences
Excel Options
11:22
Section 6: The Ribbon and Toolbars
Ribbon Interface
Preview
15:00
Quick Access Toolbar
08:03
Mini Toolbar
02:58
Section 7: Backup and Recovery
Create Backup Option; Auto-Recover and Autosave
06:54
Section 8: Entering and Deleting Data
Entering Text and Numbers
15:15
Date Formats
15:57
Formatting Cells; Editing and Deleting Data
15:15
Fill
12:51
Flash Fill
05:08
Section 9: Formatting a Worksheet
Themes and Cell Styles
Preview
14:01
Inserting, Deleting, Hiding and Adjusting Rows and Columns
13:28
Wrap Text and Alignment
15:02
Merging Cells; Applying Themes and Styles
11:36
Borders
09:25
Section 10: Copy, Paste and Paste Special
Copy, Cut and Paste
17:06
Section 11: Proofing
Spell checking
11:57
Section 12: Managing Worksheets
Moving, Copying, Inserting, Deleting and Locking Sheets; Multiple Worksheets
14:51
Section 13: Comments
Inserting Comments
06:54
Section 14: Viewing and Printing
Workbook Views, Zoom and Freeze
11:18
Printing; Headers, Footers and Margins
12:57
Section 15: Formulas and Functions
Course Review
00:43
Overview of Formulas and Functions
Preview
14:08
Cell References
14:50
Names
15:38
Finding Errors; New Excel Functions
14:13
Section 16: Working with Workbooks
Multiple Workbooks and Windows; Comparing Workbooks
10:39
Section 17: Find and Replace
Go to; Find and Replace Options
11:14
Section 18: Conditional Formatting
Applying, Clearing and Managing Rules
15:35
Section 19: Graphing and Charting
Chart Types; Chart Recommendation
Preview
13:35
Basic Formatting
14:41
Selecting Data, Positioning and Printing Charts
15:47
Section 20: File Types
Saving Workbooks; PDF and CSV Formats
11:21
Section 21: Managing Data
Sorting
09:06
Filtering
10:43
Tables
12:25
Section 22: Functions Case Study
VLOOKUP
Preview
12:58
Text Function
05:17
Date and Time Functions
05:32
Logical Functions
18:31
Section 23: Analyzing Data
Financial Analysis Case Study - Part 1
16:03
Financial Analysis Case Study - Part 2
09:23
Quick Analysis Tool
07:57
Section 24: Shapes and Pictures
Adding and Formatting Shapes, Picture, Clip Art, WordArt and SmartArt
14:27
Section 25: Sharing and Protecting
Protecting Worksheets
07:42
Protecting Workbooks
10:02
Sharing and SkyDrive
14:25
Section 26: More Backstage View Options
Trust Center; Export; Inspect Workbook
05:33
Section 27: Closing
Summary; More Help
01:49
Section 28: Downloadable course MP3 audio files
MP3 audio files
Article
Section 29: Assessment
Course Quiz
45 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Simon Sez IT, Over 270,000 Students, Used in 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,000+ 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 250,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