Learn Excel from zero to advanced.
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late. Scroll Down and click Enroll Now button to get enrolled
What You will 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.
Scroll Down and click Enroll Now Button to get enrolled into the Free Course
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.
Show less
Course content
3 sections • 23 lectures • 1h 28m total lengthCollapse all sections
Introduction
- Welcome
- 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
- 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
- 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
All ratingsFive starsFour starsThree starsTwo starsOne star
Note: Course Free for limited time and limited users(500 limit) so Enroll ASAP. If not free it means you are late.
