Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel 2013 Essential Training
Rating: 4.1 out of 5(624 ratings)
14,894 students

Excel 2013 Essential Training

Learn Excel from zero to advanced.
Created byLuis Federico Peña
Last updated 8/2017
English
English [Auto],

What you'll learn

  • Learn the most common Excel Functions used in the office.
  • To take your basic Excel skills to the next level.
  • From the fundamentals to advanced features. This training covers everything you need to know about Excel from zero to advanced.
  • Presented with high-quality video lectures, this Excel course will visually show you how to easily do everything we show you in Excel.

Course content

3 sections • 23 lectures • 1h 28m total length

  • Welcome2:50

    Explore Excel 2013 essential training by learning to manage workbooks, use formulas and functions, analyze data with charts, filters, and sorting, and build data models for financial statements.

  • Getting Started with Excel 20133:00
  • Using the exercise files0:39

    Access the exercise files by downloading the SSA files from the course page, then open the chapter folder in the library to view the lesson files referenced by each chapter.

  • What's new in Microsoft Excel 20132:00

    Discover the new features of Microsoft Excel 2013 that speed up data work, including quick analysis, conditional formatting, spark lines, live preview, and recommended charts.

  • Customizing the Quick Access Toolbar2:39

    Learn how to customize the quick access toolbar in Excel 2013 by adding frequently used commands like save and print preview, exploring more commands, and arranging items for faster access.

  • The Green File Tab6:30

    Discover the green file tab and backstage area in Excel 2013, and use file-level commands—new, open, save, save as, print, close, export—plus OneDrive and SharePoint access.

  • Exploring the Ribbon4:32

    Explore the Excel 2013 ribbon: navigate grouped commands, access options via the dialog box launcher, and use chart tools and font dialogs.

Requirements

  • • You will need Excel loaded on your computer in order to follow along and complete the exercise files provided in each section.
  • • Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.

Description

In this Microsoft Excel 2013 training course, I take you through the basics of the world's 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 way.  No prior experience in Excel 2013 or spreadsheets is required to get the most out of this Excel beginners to advanced video training.

I have outlined this course as a step-by-step guide where you will learn from zero to advanced.  


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, and even more.


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.


Note: This is an introduction for the full course Microsoft Excel 2013 Essential Training from LFTrainings.   

Who this course is for:

  • • This course is perfect for a first time beginner who needs to learn much more than just the basics.
  • • This course would also be helpful for an intermediate Excel user who needs to improve their skills in areas such as using functions; creating charts, graphs and tables; creating pivot tables and charts; formatting spreadsheets; navigating efficiently within an Excel worksheet and more.
  • • This course is helpful for increasing personal productivity, efficiency at work or even develeping skills to obtain a better job.

Report abuse