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
64 reviews
TAUGHT BY
  • Infinite Skills High Quality Training

    InfiniteSkills is a Canadian based company that offers an ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples. The emphasis is on teaching real life skills that are essential in today's commercial environment. All InfiniteSkills courses are taught by experts who have a true passion for teaching.

WHAT'S INSIDE
  • Lifetime access to 107 lectures
  • 7+ hours of high quality content
  • Closed captioning enabled
  • A community of 25700+ students learning together!
  • 120+ discussions
SHARE

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
64 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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.

    • Excel 2013 - Windows
    • 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.
    • Beginners and Intermediate

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

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

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,800,000
Students

RATING

  • 46
  • 16
  • 2
  • 0
  • 0
AVERAGE RATING
NUMBER OF RATINGS
64

REVIEWS

  • Duy, Trinh Khac
    Detailed and easy to follow

    This course seem to far under my knowledge up to now (I have few years working with excel), however, I still strongly recommend it. - The course is exactly what it's called: Excel for beginner. + Step by step instruction. + Easy to follow (instructor's voice is easy to hear too). + Plenty examples and explanation. (I have done many things with excel without knowing the reason why I can do that, this course helps me out). - The material is very good, I was amazed by some of them. I'm in Section 4 so far, not sure what will come next, will update if there is anything changes.

  • C Flower
    Great course

    Useful exploration on enhancements on previous Excel versions. Although I consider myself an advanced user, it still learned tips to doing tasks more efficiently.

  • AJ Speller

    I really enjoyed the title. The instructor moved with a great pace. I did not feel like he was rushing or wasting time to lengthen the tutorial. The examples were also well thought out because they were practical and will help with real situations. I have some experience with Excel but this course has helped to take my knowledge to the next level. I have already purchased the advanced title and will dig into that very soon. I highly recommend this course.

  • Khalid S. Melebari
    Excel 2013

    Excellent solution to learn Office Excel

  • Anthony Spence
    Good starting point

    I have to say i have been using excel for a while know, but there were so many basic things i was missing out and many which i had already forgotten, this course was a really helpful tool to remember all that. I would recommended it to anyone with little or no excel experience.

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion
MORE FROM Infinite Skills