Microsoft Excel 2013 Basic Level

Current Status

Not Enrolled

Price

Free

Get Started

Login to Enroll

Course Content

Expand All

Lesson 1 Learning Basic Excel Elements 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Lesson 1.1 Starting and Closing Excel

Lesson 1.2 Moving Around the Worksheet

Lesson 1.3 Using the Ribbon and Locating the Backstage

Lesson 1.4 Utilizing Worksheet Tabs

Lesson 1.5 Clicking – Left, Right and on the Smart Icon

Lesson 1.6 Saving a Workbook

Lesson 1.7 Opening Existing and Recently Used Workbooks

Lesson 1.8 Setting up the Page Layout

Lesson 1.9 Previewing and Printing a Workbook

Lesson 1.10 Getting Help

Lesson 2 Applying Selection and Viewing Techniques 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Lesson 2.1 Selecting Cells and Ranges

Lesson 2.2 Selecting Non-Adjacent Cells and Ranges

Lesson 2.3 Selecting Columns and Rows

Lesson 2.4 Changing Column Width or Cell Height

Lesson 2.5 Hiding and Unhiding Rows and Columns

Lesson 2.6 Using Excel Views for the Perfect Visual

Lesson 2.7 Freezing Panes

Lesson 3 Utilizing Data Entry and Editing Techniques 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Lesson 3.1 Entering Information

Lesson 3.2 Typing Text versus Numbers

Lesson 3.3 Changing Cell Contents

Lesson 3.4 Deleting Information

Lesson 3.5 Moving and Copying Data

Lesson 3.6 Using Drag and Drop

Lesson 3.7 Using Undo and Redo

Lesson 3.8 Learning AutoFill and Flash Fill Basics

Lesson 3.9 Using AutoFill Tricks

Lesson 4 Working with Excel Data 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps

Lesson 4.1 Inserting Page Breaks

Lesson 4.2 Finding and Replacing Information

Lesson 4.3 Sorting Data

Lesson 4.4 Inserting and/or Deleting Columns and Rows

Lesson 4.5 Naming Ranges

Lesson 4.6 Checking Spelling

Lesson 5 Formatting an Excel Worksheet 10 Topics

Expand

Lesson Content

0% Complete 0/10 Steps

Lesson 5.1 Changing Font and Font Size

Lesson 5.2 Pouring Color into the Cell Background

Lesson 5.3 Bordering Cells

Lesson 5.4 Aligning Text Within a Cell

Lesson 5.5 Using the Text Wrap Feature or Wrapping Text Manually

Lesson 5.6 Using the Merge and Center Tool

Lesson 5.7 Creating the Proper Number Format

Lesson 5.8 Using Built-in Styles

Lesson 5.9 Applying Conditional Formatting

Lesson 5.10 Copying Formats with the Format Painter

Lesson 6 Performing Calculations 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Lesson 6.1 Understanding Formula Operators and Order of Operations

Lesson 6.2 Doing Math with Real Numbers and Cell References

Lesson 6.3 Letting the Sum Button do the Math for You

Lesson 6.4 Creating Simple Formulas

Lesson 6.5 Using Common Functions

Lesson 6.6 Using the Insert Function Dialog Box

Lesson 6. 7 Editing Formulas and Functions

Lesson 6.8 Changing a Formula to a Value