Microsoft Excel 2013 Course Beginners/ Intermediate Training

Learn to Master Microsoft Excel In Easy To Follow Step-By-Step Training Course. Comes With Extensive Working Files
  • Lectures 107
  • Video 8 Hours
  • Skill level all level
  • Languages English , captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion

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.

Course Description

A Verifiable Certificate of Completion is presented to all students who undertake this Excel 2013 Training course.

In this Microsoft Excel 2013 training course, expert training provider InfiniteSkills takes you through the basics of the worlds most popular spreadsheet software. Excel can be a complex and confusing program to use, but this course breaks it down into bite-sized pieces and teaches it in plain English. No prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel beginners video training.

You will start with the absolute basics, creating and saving a new workbook. The course proceeds step by step through the process of entering data in cells, doing basic math, formatting your worksheets, setting up pages for printing and applying basic mathematical formulas. Once you are comfortable with the basics, you will move on to more advance formatting with themes, using Excel provided templates, adding graphics and charts, and using Excel as a database. You finish off with advanced formulas, and applying conditional formatting to your worksheet.

By the time you have completed this video training course for Microsoft Excel 2013, you will be comfortable with day to day operations that you would perform in this software program. You will be able to perform calculations, and create professional graphs and charts from your data. Working files are included to allow you to follow along using the same source material that the author uses throughout the lessons in this computer based training video.

What are the requirements?

  • Excel 2013 - Windows

What am I going to get from this course?

  • Over 107 lectures and 8 hours of content!
  • Learn Microsoft Excel 2010 from a professional trainer from your own desk.
  • 106 lectures (7.5 hours of content) teaching you from the basic to the advanced of this powerful program
  • Suitable for beginners to advanced users. ideal for users who learn faster when shown.
  • Visual training method, offering users increased retention and accelerated learning.
  • Breaks even the most complex applications down into simplistic steps.

What is the target audience?

  • Beginners and Intermediate

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: 01. Start Here
Working Files - Download These First
Text
0101 Let's Get Started With Excel 2013
02:20
0102 The Excel Workbook Explained
02:24
0103 Signing Up For Your Own Free SkyDrive
02:20
0104 Customize The Quick Access Toolbar
02:40
0105 Using The Included Working Files
01:35
How to obtain your Certificate of Completion for this Infinite Skills course.
Text
Section 2: 02. Managing Excel Workbooks And Worksheets
0201 Creating And Saving A New Workbook
03:19
0202 Opening Workbooks And Save As Options
03:21
0203 Saving And Opening SkyDrive Files
02:22
0204 Navigating An Excel Workbook
04:25
205 Adding And Removing Worksheets
03:02
0206 Renaming Copying And Moving Worksheets
04:21
Section 3: 03. Entering And Editing Data In Cells
0301 Entering Text, Numbers, And Dates
03:29
0302 Entering Numbers As Text
03:30
0303 Editing The Contents Of A Cell
02:41
0304 Undo And Redo Actions
02:50
0305 Cut, Copy, And Paste
04:40
0306 Dragging And Dropping Cells
02:48
0307 The Fill Handle
06:46
0308 Inserting And Deleting Cells Columns And Rows
04:09
0309 Changing Column Widths And Row Heights
04:19
0310 Hiding And Un-Hiding Columns And Rows
03:23
0311 Searching For Values In A Workbook
03:00
Section 4: 04. Math Basics
0401 Getting Started With Basic Math Formulas
05:15
0402 Order Of Operation With BODMAS
03:52
0403 Introduction To Basic Formulas
05:41
0404 Copying Formulas And Functions
04:39
0405 Displaying Formulas On A Worksheet
04:11
Section 5: 05. Formatting Worksheets
0501 Selecting Cells For Formatting
02:53
0502 Modifying Typeface Font, Size, And Colour
05:37
0503 Merging And Wrapping Cell Contents
06:02
0504 Using Number Formats
05:56
0505 Cell Content Alignment And Orientation
03:43
0506 Adding And Removing Borders From A Selection
04:33
0507 Applying A Date Format To A Cell Or Range
03:42
0508 The Format Painter
03:48
0509 Finding And Replacing Formats
06:13
0510 Clearing Cell Contents Vs. Clearing Cell Formatting
05:12
Section 6: 06. Workbook And Worksheet Management
0601 Worksheet Navigation And Coloured Worksheet Tabs
04:24
0602 Moving Or Copying Worksheets Within And Between Workbooks
03:39
0603 Viewing And Scrolling Multiple Workbooks At The Same Time
03:46
0604 Hiding And Un-Hiding Sheets
02:28
0605 Modifying More Than One Worksheet At A Time
04:45
Section 7: 07. Page Setup And Printing
0701 Using Print Titles And Print Areas
05:36
0702 Paper Size, Orientation, Margins, And Scaling Options
06:25
0703 Creating Headers and Footers
06:03
0704 Using The Page Break And The Page Layout Views
04:51
0705 Printing A Range Of Cells
02:15
0706 Running The Spell Checker
04:27
0707 Controlling Most Print Settings In One Place
05:34
Section 8: 08. Mathematical Formulas
0801 The Sum Function
06:51
0802 Copying Formulas And Functions
06:45
0803 Other Mathematical Functions: Average, Min, And Max
05:52
0804 Useful Count Functions
03:26
0805 Absolute Referencing Explained
07:08
0806 Formulas Across Worksheets
07:07
0807 3D Referencing
07:25
0808 Making Use Of Named Cells And Ranges
08:15
Section 9: 09. Advanced Formatting
0901 Enhancing Worksheets Using Themes
04:34
0902 Adding, Editing, And Deleting Comments
03:33
0903 Creating Your Own Autofill List
04:23
0904 Converting Data To A Table For Formatting
05:24
Section 10: 10. Security
1001 Activating And Deactivating Worksheet Protection
03:51
1002 Protecting Part Of A Worksheet To Aid Data Entry
03:07
1003 Password Protecting The Whole Workbook
04:51
Section 11: 11. Excel 2013 Templates
1101 Using The 2013 Templates
04:13
1102 Creating And Using Your Own Template
04:39
Section 12: 12. Graphics Objects
1201 Obtaining And Inserting Online Images
04:02
1202 Using SmartArt Graphics
05:46
1203 Inserting Shapes And Screenshots
05:26
1204 Formatting Graphical Objects
05:38
1205 The Stacking Order
04:51
1206 Grouping Multiple Objects Together
05:05
1207 Using Graphical Objects And Mathematical Formulas
03:39
Section 13: 13. Using Charts In Excel
1301 The New Recommended Charts Option
04:17
1302 Create A Chart Using The Long Or The Short Method
03:34
1303 Formatting A Chart With The 2013 Shortcut Options
03:22
1304 Modifying The Chart Type
03:52
1305 Formatting Chart Elements
04:45
1306 Adding A Trendline
03:12
1307 The Pie Chart In Detail
08:01
1308 Mini Graphs: Sparklines
05:50
Section 14: 14. Excel As A Database
1401 Fixing On Screen Rows And Columns
05:41
1402 Fixing Print Rows And Columns
03:02
1403 Sorting Data In Excel
05:59
1404 Filtering Data To Reduce Dataset Size
06:03
1405 Removing Duplicate Entries In The Data
02:20
1406 Adding Subtotals To A Worksheet Of Data
04:49
1407 Using Text To Columns Effectively
05:09
1408 Linking To Data On A Webpage
04:14
Section 15: 15. Advanced Formulas
1501 Using An If Formula
05:01
1502 Use Of The If Function To Hide Excel Error Messages
04:51
1503 Datedif: A Useful But Hidden Formula
04:37
1504 Text Manipulation Using Functions
05:40
1505 Use The Text Function To Format Numbers
03:57
1506 Date Manipulation Functions
03:39
1507 Introducing Sumif, Countif, And Averageif
06:38
1508 Use Of Rank To Calculate Placings
04:33
1509 Flash Fill: The Magic Touch
03:39

Instructor Biography

Infinite Skills , High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Join the biggest student community

7,700,000

Hours of video content

28,000,000

Course Enrollments

7,500,000

Students

Reviews

Average Rating
4.6
Details
  1. 5 Stars
    74
  2. 4 Stars
    21
  3. 3 Stars
    3
  4. 2 Stars
    1
  5. 1 Stars
    2
    • Andres Rengifo

    Great!!

    Great course, I recommend it to everyone!!!

    • Sandra Clow

    EXCEL - lent course!

    He didn't just cover the info in one chapter but used it in others chapters thus helping us remember. This helped cement the newly learned functions.

    • Praharsh Modi

    ***Amazing course for beginners***

    The instructor is very clear and concise. He start from baby steps and explains everything in detail so you don't miss a beat. The production quality is simply great! The instructor is truly a professional at teaching these courses. After reading the reviews and previewing some courses by Guy, I went out and grabbed close to 10 other courses from Infinite Skills. These guys and gals know what they are doing. Thank you for improving my Excel skill level!! (Now onto the Advanced Course!)

    • Paul Brown

    Outstanding course

    Everything about this course is terrific. It's a brilliant introduction to MS Excel. The technical quality is extremely high and the course covers an ambitious amount of material. Guy's presentation is clear and efficient, and I'm really looking forward to the Advanced class!

    • Joakim Astrom

    Excellent

    Absolutely excellent course. Good teacher that goes through all the steps in a very clear and educational way.

Show more reviews
Ready to start learning?
Preview this course