
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.
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.
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.
Explore how to customize Excel options, set a default file location, and efficiently save and open workbooks using the quick access toolbar and file options.
Learn how to edit a cell in Excel 2013 by entering edit mode via double-click, the formula bar, or the F2 key, then insert changes without replacing content.
Master undo and redo in Excel 2013 by using the Quick Access Toolbar and the dropdown to navigate multiple recent changes, with Ctrl+Z and Ctrl+Y shortcuts.
Explains how to copy, cut, paste, and move data in Excel 2013 using the clipboard, with keyboard shortcuts and drag-and-drop, and how to handle overwriting when pasting.
Insert and remove rows and columns in Excel 2013 via the home ribbon or right-click, to the left of the selection. Use Ctrl+- to delete and Ctrl++ to insert.
Demonstrates Excel's spell checker for validating worksheet words and adding terms to a dictionary. Learn to use replacements, ignore, and change all with shortcuts like F7 and Ctrl+Home.
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.