Excel 2013 The Basics

This course covers the basic functions and features of Excel 2013.
3.3 (4 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
25 students enrolled
$50
Take This Course
  • Lectures 160
  • Contents Video: 4 hours
    Other: 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2013 English

Course Description

This course covers the basic functions and features of Excel 2013. Students will learn about calculations and how to modify and format a worksheet. They will also learn how to customize the Excel environment and how to manage and print workbooks.

Total Video Time: 3h 54m

Review Quizzes included for each Section, test your knowledge!

Workbooks included for each Section, print out the course slides and take notes as you go!

Some Topics Include:

Getting Started with Microsoft Excel 2013

Performing Calculations

Modifying a Worksheet

Formatting a Worksheet

Printing Workbook Contents

Managing Large Workbooks

Customizing the Excel Environment

Instructor: Debbie Fierst

Debbie Fierst owns a thriving technology training, consulting and development firm she started in 1990. A summa cum laude graduate of Indiana Wesleyan University, Debbie holds various technical certifications. She teaches more than sixty software applications and programming languages in both online and in-person venues, but she specializes in business and project management topics. Her presentations are packed with strategies, statistics, real-life examples and common-sense messages.

What are the requirements?

  • Basic Computer Knowledge

What am I going to get from this course?

  • Learn the Basics of Microsoft Excel 2013
  • Learn About the Changes Between 2010 and 2013
  • Learn About Excel Formulas
  • Review Quizzes for Each Section
  • Downloadable Workbooks

What is the target audience?

  • Anyone Seeking Training with Excel 2013
  • Anyone Seeking to Advance Their Knowledge of Excel 2013

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started with Microsoft Excel 2013
Instructor Introduction
Preview
00:22
Course Introduction
Preview
00:31
Section 01 Introduction
Preview
00:20
Topic A: Identify the Elements of the Excel Interface
00:35
Microsoft Excel 2013
00:22
Spreadsheets, Worksheets, and Workbooks
Preview
01:10
The Excel Interface
01:48
Cell References and the Formula Bar
00:54
The Go To Feature
Preview
00:40
ScreenTips and Key Tips
01:11
Demo 1-1: Excel Elements
Preview
05:22
Topic B: Create a Basic Worksheet
00:31
The Ribbon
02:43
The Backstage View
01:20
Data Types
Preview
01:29
Excel 2013 File Formats
01:12
SkyDrive
Preview
01:50
The Convert Option
01:10
The Compatibility Checker
01:05
Demo 1-2: Creating a Spreadsheet
Preview
04:10
Topic C: Use the Help System
00:11
The Excel Help Window
01:18
Demo 1-3: Using Help System
01:46
Review
00:15
Getting Started with Microsoft Excel 2013
5 questions
Workbook
Preview
21 pages
Section 2: Performing Calculations
Section 02 Introduction
00:13
Topic A: Create Formulas in a Worksheet
00:19
Formulas
01:57
The Formula Bar
02:46
Elements of an Excel Formula
01:51
Common Mathematical Operators
01:35
The Order of Operations
01:13
Demo 2-1: Creating Formulas
04:42
Topic B: Insert Functions in a Worksheet
00:21
Functions
01:18
The Function Library
01:00
Using the AutoSum Button
01:18
The Formula AutoComplete Feature
01:01
Demo 2-2: Insert Functions in a Worksheet
07:12
Topic C: Reuse Formulas
00:18
The Cut, Copy, and Paste Commands
02:56
Relative References
01:35
Absolute References
02:18
Mixed References
01:48
Demo 2-3: Reusing Formulas
05:25
Review
00:13
Performing Calculations
5 questions
Workbook
20 pages
Section 3: Modifying a Worksheet
Section 03 Introduction
00:17
Topic A: Manipulate Data
00:13
The Undo and Redo Commands
00:50
Auto Fill
01:55
Live Preview
01:34
The Clear Button
01:44
Demo 3-1: Manipulating Data
05:39
Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
00:14
The Insert and Delete Options
01:27
The Hide and Unhide Options
01:13
Demo 3-2: Adjust Display of Columns
04:46
Topic C: Search for and Replace Data
00:17
Cell Names and Range Names
02:00
The Find Command
01:13
The Replace Command
01:18
Demo 3-3: Searching for and Replacing Data
06:12
Topic D: Spell Check a Worksheet
00:12
The Spelling Dialog Box
01:27
Demo 3-4: Spell Checking a Worksheet
03:07
Review
00:16
Modifying a Worksheet
5 questions
Workbook
18 pages
Section 4: Formatting a Worksheet
Section 04 Introduction
00:16
Topic A: Modify Fonts
00:19
Fonts
01:17
The Font Group
00:42
The Format Cells Dialog Box
00:58
Galleries
00:45
Live Preview and Formatting
01:02
The Mini Toolbar
01:10
Demo 4-1: Modifying Fonts
04:19
Topic B: Add Borders and Color to Cells
00:13
Border Options
01:21
Sheet Backgrounds
01:21
Demo 4-2: Adding Borders and Color to Cells
06:05
Topic C: Apply Number Formats
00:17
Number Formats
01:29
Number Formats in Excel
01:14
Demo 4-3: Applying Number Formats
06:08
Topic D: Align Cell Contents
00:15
The Indent Commands
01:11
The Wrap Text Command
02:02
Orientation Options
01:10
Demo 4-4: Aligning Cell Contents
04:42
Topic E: Apply Cell Styles
00:08
Cell Styles
01:38
Demo 4-5: Applying Cell Styles
05:18

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Career Academy, Producing Quality Technical Training Videos Since 1999

Career Academy was established in 1999 to help people deal with changes and acquire the knowledge and skills they need to compete in the 21st Century. We are the global leader in self paced computer technology training solutions for the IT Professional, providing the most complete and up to date self-paced certification and job related training library available.

Career Academy blends technical know-how and a quality knowledge base and implements that blend throughout the four corners of the globe. It empowers you with complete control over the learning process. Learn via OnDemand Training whenever you want. We have recreated the classroom experience for students who are not able to fit a class schedule into their busy lifestyle. Career Academy provides you the finest instructor led lectures with the latest Technological trends in content development and delivery to help create your own unique learning. 

Ready to start learning?
Take This Course