Try the Complete Excel Course for Free!

Excel Training Tutorial Free Online

/ / Excel 2013, Latest, Microsoft, Microsoft Excel Training for Lawyers, Office 2013
A picture of the interface in the Excel training named

Excel Training Tutorial Introduction

            This blog post is a free online Excel training tutorial. Excel is one of the most used spreadsheet software today. You use Excel to create powerful worksheets that can manipulate numbers for you. It is a very powerful program, and has many advanced features that can automate and simplify your work. Whether you want it to create charts, worksheets, or data sources, Excel can assist you in accomplishing your tasks quickly and easily.

            This free Excel training tutorial will give a basic skill set to a student with little or no knowledge of the software. It covers the basics of making a workbook in Excel 2013. This free online Excel training tutorial shows you how to create a workbook. You will learn how to enter data into the workbook. You will also learn how to create formulas in the workbook. After that, you will learn how to manage columns and rows in the workbooks. You will then learn how to prepare the workbooks for printing. At the end, you will learn how to print your workbook. This Excel training will provide you with basic skills in using the Excel program.

            The lessons in this free online Excel training tutorial come from our premier Excel training, titled “Mastering Excel Made Easy v.2013-2007.” It is available to buy online. The complete Excel training has 37 chapters with 222 video lessons. It covers many more topics about using Excel. It includes three printable classroom instruction manuals: Introductory, Intermediate, and Advanced. This link is a sample of the “Introductory Excel” manual, this link is a sample of the “Intermediate Excel” manual, and this link is a sample of the “Advanced Excel” manual. The manuals include step-by-step actions and practice exercises.

            The complete training covers more in-depth topics. These topics include formatting a workbook. It also includes how to create advanced formulas. You will also learn how to create charts. How to create PivotTables is also included. Other topics include tables, sparklines, slicers, security, and many more.

            The free online Excel training tutorial contained in this blog post will focus on the essentials of using Excel to create a basic workbook with data and formulas.  The topics covered will include Excel training lessons on the following 6 subjects:

Part 1- File Management

Part 2- Data Entry

Part 3- Creating Formulas

Part 4- Columns & Rows

Part 5- Setting Worksheet Layout

Part 6- Printing Worksheets

Excel Training Tutorial Resources

Microsoft Office 2013– This is a link to Microsoft Office 2013, which includes Excel 2013, on the company’s web site. You can purchase the software directly from Microsoft at this link.

Microsoft Excel 2013– This is the specific product page for Microsoft Excel 2013 on the Microsoft web site. This page allows you to read more about Excel and try it for one month for free.

Mastering Excel Made Easy v.2013-2007 (Online, DVD, or Digital Download)– This is a link to the complete Excel training. This includes 222 video lessons with over 10 hours of video lessons. Watch, listen, and learn as your expert teacher guides you through each lesson. You will see each step performed as if the teacher was there with you. You can purchase and view it online, on DVD, or download it digitally, directly from TeachUcomp, Inc.

 A picture of the interface in the Excel training named "Mastering Excel Made Easy v.2013-2007." Learn Microsoft Excel with this comprehensive course from TeachUcomp, Inc. It features 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.

Mastering Excel Made Easy v.2013-2007 at Udemy.com– This is the same Excel training course content offered for purchase at the above link, but provided by Udemy.com, a leader in online learning.

Mastering Excel Made Easy v.2013-2007 on iBooks– This is a link to the iTunes preview of the multi-touch iBooks version of the complete Excel training course. Note that this version is only available for use with the iBooks program on Macs or iPads. This book is available for download with iBooks on your Mac or iPad, and with iTunes on your computer. You can read multi-touch books with iBooks on your Mac or iPad. Books with interactive features may work best on an iPad. iBooks on your Mac requires OS X 10.9 or later.

 A picture of the cover of the Excel training in ibooks. Learn Microsoft Excel 2013 through 2007 with this comprehensive multi-touch course from TeachUcomp, Inc. Mastering Excel Made Easy features 222 video lessons with hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the printed text of our classroom instruction manual, additional images and practice exercises to complete in your copy of the software.

Mastering Excel Made Easy for Lawyers- CPE Edition v.2.0– This is an enhanced version of the “Mastering Excel Made Easy v.2013-2007” Excel training with extra material on using Excel for lawyers. This Excel training course includes a CPE module for lawyers. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. In addition, you receive the complete Excel training.

 A picture of the interface in the Excel training named "Mastering Excel Made Easy for Lawyers- CPE Edition v.2.0." When it comes to Microsoft Office programs, law firms have unique needs. This Excel training course includes a CPE training module specific to the practice of law. You will learn how to effectively use legal templates, legal business functions (such as the Pv and Fv functions) and simple IOLTA management. In addition, you’ll receive our complete Excel curriculum. Learn Microsoft Excel with this comprehensive course from TeachUcomp, Inc. Mastering Excel Made Easy features 222 video lessons with over 10 hours of introductory through advanced instruction. Watch, listen and learn as your expert instructor guides you through each lesson step-by-step. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Reinforce your learning with the text of our three printable classroom instruction manuals (Introductory, Intermediate and Advanced), additional images and practice exercises. You will learn how to effectively create and format spreadsheets, charts, pivot tables and much more.

Microsoft Excel 2013 Introductory Quick Reference Card– Designed with the busy professional in mind, this 4-page laminated quick reference guide provides step-by-step instructions in Excel 2013. When you need an answer fast, you will find it right at your fingertips. Durable and easy-to-use, quick reference cards are perfect for individuals, businesses and as supplemental training materials.

A picture of the Excel training supplement "Microsoft Excel 2013 Introductory Quick Reference Card."

Excel Training Tutorial: Part 1- File Management

Lesson: 2.1- Creating New Workbooks- 2013 Only

Lesson: 2.4- Saving Workbooks- 2013 Only

Lesson: 2.7- Closing Workbooks- 2013 Only

Lesson: 2.9- Opening Workbooks- 2013 Only

Excel Training Tutorial: Part 2- Data Entry

Lesson: 3.1- Selecting Cells

Lesson: 3.2- Entering Text into Cells

Lesson: 3.3- Entering Numbers into Cells

Lesson: 3.4- AutoComplete

Lesson: 3.6- Flash Fill- 2013 Only

Lesson: 3.7- Selecting Ranges

Lesson: 3.9- Using AutoFill

Excel Training Tutorial: Part 3- Creating Formulas

Lesson: 4.1- Ranged Formula Syntax

Lesson: 4.2- Simple Formula Syntax

Lesson: 4.3- Writing Formulas

Lesson: 4.4- Using AutoSum

Lesson: 4.5- Inserting Functions

Lesson: 4.6- Editing a Range

Excel Training Tutorial: Part 4- Columns & Rows

Lesson: 6.1- Selecting Columns and Rows

Lesson: 6.2- Adjusting Column Width and Row Height

Lesson: 6.4- Inserting and Deleting Columns and Rows

Excel Training Tutorial: Part 5- Setting Worksheet Layout

Lesson: 9.1- Using Page Break Preview

Lesson: 9.3- The Page Setup Dialog Box

Excel Training Tutorial: Part 6- Printing Worksheets

Lesson: 10.1- Previewing and Printing Worksheets- 2013:2010

TOP
Extra 30% Off Store-Wide 2 Days 13 Hours 43 Minutes 10 Seconds      Use Coupon: EXTRA30
Shop Now