Excel 2013 Introduction
4.6 (7 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.
52 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 2013 Introduction to your Wishlist.

Add to Wishlist

Excel 2013 Introduction

Unleash the power of Excel worksheets
4.6 (7 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.
52 students enrolled
Last updated 3/2015
Learn Fest Sale
Current price: $10 Original price: $30 Discount: 67% off
15 hours left at this price!
30-Day Money-Back Guarantee
  • 4.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Open files and navigate in Excel
  • Create and save new files, enter data, use AutoFill and Flash Fill
  • Create simple formulas and formulas containing functions
  • Understand relative v. absolute cell references
  • Edit the contents of workbooks
  • Use cut, copy, paste and paste special
  • Work with find and replace
  • Format the cells, cell contents, columns, and rows in a worksheet
  • Manage large worksheets or multiple workbooks
  • Protect cells and use comments
  • Work with track changes
  • Set print titles and print areas
  • Alter page setup commands in preparation for printing a worksheet
View Curriculum
  • Basic Windows operating skills
  • Basic mouse skills


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

  • Getting start with open files and navigating Excel
  • Understand basic skills like create new files, entering data, using AutoFill and saving
  • Create formulas, use functions, work with date math and understanding cell relativity
  • Edit workbooks, use Clipboard commands and work with find and replace
  • Format a workbook and modify its structure
  • Deal with the difficulties of work with large or multiple workbooks
  • Use collaboration tools to work with other users on the same files
  • Use the page setup commands to prepare to print a worksheet

  • 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.

    Who is the target audience?
    • Students interested in learning the basics of Excel
    • Anyone who edits or uses worksheets created by others
    • Students who are self taught in Excel and looking to explore features they may have missed
    Students Who Viewed This Course Also Viewed
    Curriculum For This Course
    Expand All 41 Lectures Collapse All 41 Lectures 04:38:26
    1 Lecture 03:15
    Getting Started
    4 Lectures 34:39

    Starting Excel and Opening a File

    Understanding the Application Window

    Cell Addressing and Navigating a Worksheet
    Basic Worksheet Skills
    7 Lectures 43:17

    Using AutoFill

    Using Clear

    Working with Worksheets

    Using Flash Fill

    Saving a Workbook
    Creating Formulas
    5 Lectures 37:28
    Working with Simple Formulas and Functions

    Using AutoSum


    Understanding Relative v. Absolute Cell Addressing
    Editing a Workbook
    4 Lectures 26:26
    Editing and Deleting

    Using Undo and Redo

    Cut, Copy, Paste and Paste Special

    Using Find and Replace
    Formatting a Worksheet
    8 Lectures 01:01:17
    Inserting and Deleting Columns and Rows

    Adjusting and Hiding Columns and Rows

    Changing Number Formats

    Formatting Text

    Merging Cells and Changing Alignment

    Formatting Borders and Shading

    Using, Modifying, and Creating Cell Styles

    Using Themes
    Working with Large Worksheets and Multiple Workbooks
    4 Lectures 18:55
    Using the Zoom Feature

    Freezing Panes and Splitting Windows

    Tiling Windows

    Viewing Multiple Worksheets
    3 Lectures 21:20
    Protecting Cells

    Using Comments

    Working with Track Changes
    Printing and Page Setup
    4 Lectures 29:54
    Using Page Break and Print Preview

    Changing Page Setup

    Adding Headers and Footers

    Setting Print Titles and Print Areas
    1 Lecture 01:55
    About the Instructor
    Intellezy Trainers
    4.4 Average rating
    3,355 Reviews
    22,177 Students
    134 Courses
    Computer Training Specialists

    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.