Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely used of them too. A solid understanding of how to use this program is vital to nearly everyone in most industries today.
This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically you will understand how to create, save, enter data and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to format spreadsheets, manipulate columns and rows, add headers and footers and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks and use collaboration tools to work in conjunction with other users.
Learn and Master Introductory Features in Excel 2013
Contents and Overview
During the four and half hours of content included in the 41 lectures, this course covers all the key features you need to know to get started with building and using Excel 2013 workbooks.
Upon completion you will be comfortable creating new workbooks and editing existing workbooks, creating formulas and doing basic calculations, setting up a workbook for printing and collaborating with other users on Excel files. You will have all the skills you need to prepare to take the Intermediate and Advanced levels of Excel training.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|Section 2: Getting Started|
What is Excel?Preview
Starting Excel and Opening a File
Understanding the Application Window
Cell Addressing and Navigating a Worksheet
|Section 3: Basic Worksheet Skills|
Creating a WorkbookPreview
Entering and Selecting DataPreview
Working with Worksheets
Using Flash Fill
Saving a Workbook
|Section 4: Creating Formulas|
Working with Simple Formulas and Functions
Working with Date ArithmeticPreview
Understanding Relative v. Absolute Cell Addressing
|Section 5: Editing a Workbook|
Editing and Deleting
Using Undo and Redo
Cut, Copy, Paste and Paste Special
Using Find and Replace
|Section 6: Formatting a Worksheet|
Inserting and Deleting Columns and Rows
Adjusting and Hiding Columns and Rows
Changing Number Formats
Merging Cells and Changing Alignment
Formatting Borders and Shading
Using, Modifying, and Creating Cell Styles
|Section 7: Working with Large Worksheets and Multiple Workbooks|
Using the Zoom Feature
Freezing Panes and Splitting Windows
Viewing Multiple Worksheets
|Section 8: Collaborating|
Working with Track Changes
|Section 9: Printing and Page Setup|
Using Page Break and Print Preview
Changing Page Setup
Adding Headers and Footers
Setting Print Titles and Print Areas
|Section 10: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.