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

English [Auto],

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
Begin with Excel 2013 for beginners, mastering the user interface and workbook and worksheet management, data entry and editing, and essential tools like undo, cut, copy, paste, and basic formatting.
What's New and What to Expect in Excel 20131:31
Explore what's new in Excel 2013, including cloud storage with OneDrive and revamped charts. Discover dozens of new worksheet functions and basics like terminology, creating and saving files, and formatting.
Excel is Workbook and Worksheets3:03
Explore the workbook and worksheets in Excel, with tabs and renaming sheets. Learn how columns labeled A to XFD and rows from 1 upward are navigated with Ctrl shortcuts.
The User Interface3:00
Identify the Excel 2013 user interface parts, the active cell and address, and use backstage view, ribbon, status bar, and quick access toolbar to display, scroll, and customize the worksheet.
The Quick Access Toolbar2:09
Discover how to customize the quick access toolbar in Excel, add frequently used commands from the drop-down list, and toggle its position near the ribbon for faster access.
Creating and Saving a New Workbook3:10
Create an exercise files folder on your desktop, then start a new workbook in Excel 2013 from a blank file or template and save to your computer or OneDrive.
Opening Workbooks and Save As Options2:41
Open workbooks from recent lists or browse your PC, then edit data and save as a new file in a chosen location or in an earlier Excel format.
Saving and Opening OneDrive Files2:01
Save your Excel file to OneDrive via the File tab and Save As, then open it later from OneDrive to edit on any PC with internet access.
Moving Around a Workbook2:58
Master navigating an Excel 2013 workbook using the mouse and keyboard, including arrow keys, home, Ctrl+Home, Ctrl+End, and Ctrl+Page Up and Ctrl+Page Down to switch sheets.
Adding and Removing Worksheets2:33
Learn to add and remove worksheets in Excel 2013 using plus button or insert menu, placing sheets to left of current sheet with labels, and deleting with right-click and warnings.
Renaming. Copying, and Moving Worksheets3:37
Learn to rename, move, and copy worksheets in Excel 2013 using navigation keys, right-click renaming, and drag-and-drop with or without control for copying, while managing hidden sheets and naming limits.
Entering Text, Numbers, and Dates2:04
Learn to enter text, numbers, and dates in Excel, accept entries with the tab key, view spillover in the formula bar, and adjust column width to prevent spillover.
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
Learn how to edit the contents of a cell in Excel 2013 without replacing it, using double click, the formula bar, or the F2 key, then press return.
Undo and Redo Actions2:14
Learn how to use undo and redo in Excel 2013, enabling quick access toolbar buttons, dropdowns to undo multiple actions, and shortcuts like Ctrl+Z and Ctrl+Y.
Cut, Copy, and Paste4:10
Learn how to cut, copy, and paste in Excel 2013 using the clipboard, right-click or the home ribbon, and keyboard shortcuts to move data across cells and ranges.
Dragging and Dropping Cells1:57
Use drag and drop to move or copy cell ranges within a sheet or across sheets. Hold the control key to copy, seen as a plus sign.
The Fill Handle5:32
Master the Excel 2013 fill handle to quickly copy cells, create incremental series, and auto-fill dates, months, and days of the week across rows and columns.
Inserting and Deleting Cells, Columns, and Rows4:39
Master inserting and deleting cells, rows, and columns in Excel 2013, using right-click menus, the ribbon, and the fill handle to manage data and labels.
Changing Column Widths and Row Heights2:48
Learn how to adjust column widths and row heights in Excel 2013, including auto-fit options, dragging borders, and applying auto-fit to multiple columns or rows.
Searching for Values in a Workbook2:33
Discover how to use Excel's find feature to locate values across a workbook, including find next, find and replace, and options like scope, match case, and match entire cell contents.
Hiding and Un-hiding Columns and Rows2:49
Learn how to hide and unhide rows and columns in Excel 2013, using right-click menus, the Hide and Unhide commands, and drag-to-unhide techniques, including effects on printing.

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.