Excel 2013 Essential Training
4.5 (26 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,512 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.5 (26 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,512 students enrolled
Last updated 7/2017
English
Price: Free
Includes:
  • 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
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.

m
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
01:28:34
+
Introduction
7 Lectures 22:10
Welcome
02:50

Getting Started with Excel 2013
03:00

Using the exercise files
00:39

What's new in Microsoft Excel 2013
02:00

Customizing the Quick Access Toolbar
02:39

The Green File Tab
06:30

Exploring the Ribbon
04:32
+
Managing Workbooks and Worksheets
6 Lectures 24:56
Configuring Excel Options
05:24

The Advanced Options tab
02:06

Excel 2013 Environment Colors
05:32

Using the built-in help
02:01

Workbooks in detail
04:21

Creating, Saving and Opening Workbooks
05:32
+
Entering and Editing Data
10 Lectures 41:28
Entering Text, Numbers and Dates
03:50

Editing the content of a cell
02:39

Undo and Redo actions
03:18

Copying, Cutting, Pasting and Moving Data
06:12

Inserting and Removing Rows and Columns
03:43

Handling operations in Worksheets
09:10

Changing Column Widths and Row Heights
04:52

Hiding and Unhiding Columns and Rows
02:36

Spell Check and AutoCorrect
03:33

Transposing Rows and Columns
01:35
About the Instructor
Luis Federico Peña
4.5 Average rating
24 Reviews
1,512 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.