Excel in Microsoft Excel 2013: Part I

Name: Excel in Microsoft Excel 2013: Part I
Rating: 4.3 (270 reviews)

A course comprising of six parts with over ninety two-to-four minute videos each focusing on a very specific skill.

Created byGurmeet Grewal

Last updated 7/2015

English

What you'll learn

Launch Excel 2013 with the know-how of working with it confidently and accomplishing the required tasks with ease. The daunting fear of Excel will be laid to rest permanently once you realize that the steps explained in each lecture cut to the chase in a matter of a few minutes.

Course content

1 section • 22 lectures • 1h 1m total length

Introduction2:28
What's New and What to Expect in Excel 20131:31
Excel is Workbook and Worksheets3:03
The User Interface3:00
The Quick Access Toolbar2:09
Creating and Saving a New Workbook3:10
Opening Workbooks and Save As Options2:41
Saving and Opening OneDrive Files2:01
Moving Around a Workbook2:58
Adding and Removing Worksheets2:33
Renaming. Copying, and Moving Worksheets3:37
Entering Text, Numbers, and Dates2:04
Entering Numbers as Text1:30
Learn to enter numbers as text in Excel to preserve leading zeros for telephone numbers by using a leading apostrophe or by setting the cell format to text.
Editing the Contents of a Cell2:07
Undo and Redo Actions2:14
Cut, Copy, and Paste4:10
Dragging and Dropping Cells1:57
The Fill Handle5:32
Inserting and Deleting Cells, Columns, and Rows4:39
Changing Column Widths and Row Heights2:48
Searching for Values in a Workbook2:33
Hiding and Un-hiding Columns and Rows2:49

Requirements

You should have access to the Microsoft Excel 2013 application on your computer to able to download and open the exercise files in order to follow along with the lectures.

Description

This course covers the basics of Excel 2013 with over 90 short videos spanning over 6 parts. Each video will focus on a very specific skill with attached resources which will require your participation as the lesson is played out. These 2-to-6 minute lessons will help you, the student, to zoom in on exactly what you want to master, quickly and with ease. In Part I, you will learn 20 unique skills in Excel 2013, for example, in Lecture 9 you will go through the activity of Adding and Removing Worksheets in 2 minutes and 33 seconds, in Lecture 17 you will touch on the power of The Fill Handle in 5 minutes and 32 seconds and in Lecture 19 Changing Column Widths and Row Heights in 2 minutes and 48 seconds. The whole purpose of this course is to get you up and running in the shortest time. The lessons are succinct and to the point, without unnecessary clutter. Resources in the form of pre-formatted Excel documents have been made available for you to download and work along with the lectures. Each part of the course will cover an additional 20 to 24 unique skills, and by the end of Part VI, you will be able to handle all the basic requirements in working with Excel as well as setting yourself up for moving forward to the Intermediate/Advanced level content.

Who this course is for:

This course is for beginners with no or very little knowledge of the basics of Microsoft Excel 2013. Students with a fair degree of Excel proficiency will find this course too basic for their needs but could serve as a refresher for the nitty gritty stuff that may have been forgotten.