Excel 2013 Essential Training
4.4 (42 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,973 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Essential Training to your Wishlist.

Add to Wishlist

Excel 2013 Essential Training

Learn Excel from zero to advanced.
4.4 (42 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,973 students enrolled
Last updated 8/2017
Price: Free
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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.
View Curriculum
  • • 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.

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 is the target audience?
  • • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
23 Lectures
7 Lectures 22:10

Getting Started with Excel 2013

Using the exercise files

What's new in Microsoft Excel 2013

Customizing the Quick Access Toolbar

The Green File Tab

Exploring the Ribbon
Managing Workbooks and Worksheets
6 Lectures 24:56
Configuring Excel Options

The Advanced Options tab

Excel 2013 Environment Colors

Using the built-in help

Workbooks in detail

Creating, Saving and Opening Workbooks
Entering and Editing Data
10 Lectures 41:28
Entering Text, Numbers and Dates

Editing the content of a cell

Undo and Redo actions

Copying, Cutting, Pasting and Moving Data

Inserting and Removing Rows and Columns

Handling operations in Worksheets

Changing Column Widths and Row Heights

Hiding and Unhiding Columns and Rows

Spell Check and AutoCorrect

Transposing Rows and Columns
About the Instructor
Luis Federico Peña
4.4 Average rating
42 Reviews
1,973 Students
1 Course
LFTrainings - Your online academy

Luis Federico Peña

LF Trainings

This online training is led by Luis Federico Peña, a social media and digital marketing consultant and lead director and founder of LFStudio and LFTrainings.  I am also author and entrepreneur.  I develop techniques to help small businesses to grow, get clients and generate income.   

I have more than 10 years of experience in the web design field, having created more than 200 commercial websites for big companies in the Caribbean, Europe and the United States.

I am passionate about helping others learn and improve their lives.

In this area of LFTrainings, the emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.