Excel 2013 Introduction
4.6 (9 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.
65 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 (9 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.
65 students enrolled
Last updated 3/2015
English
Current price: $10 Original price: $30 Discount: 67% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Basic Windows operating skills
  • Basic mouse skills
Description

COURSE DESCRIPTION

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
    41 Lectures
    04:38:26
    +
    Introduction
    1 Lecture 03:15
    +
    Getting Started
    4 Lectures 34:39

    Starting Excel and Opening a File
    13:17

    Understanding the Application Window
    10:07

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


    Using AutoFill
    06:28

    Using Clear
    05:06

    Working with Worksheets
    06:15

    Using Flash Fill
    09:20

    Saving a Workbook
    05:25
    +
    Creating Formulas
    5 Lectures 37:28
    Working with Simple Formulas and Functions
    18:28

    Using AutoSum
    05:13


    AutoCalculate
    03:52

    Understanding Relative v. Absolute Cell Addressing
    07:30
    +
    Editing a Workbook
    4 Lectures 26:26
    Editing and Deleting
    05:41

    Using Undo and Redo
    03:06

    Cut, Copy, Paste and Paste Special
    09:37

    Using Find and Replace
    08:02
    +
    Formatting a Worksheet
    8 Lectures 01:01:17
    Inserting and Deleting Columns and Rows
    07:25

    Adjusting and Hiding Columns and Rows
    09:41

    Changing Number Formats
    09:05

    Formatting Text
    05:20

    Merging Cells and Changing Alignment
    10:35

    Formatting Borders and Shading
    08:03

    Using, Modifying, and Creating Cell Styles
    06:54

    Using Themes
    04:14
    +
    Working with Large Worksheets and Multiple Workbooks
    4 Lectures 18:55
    Using the Zoom Feature
    03:11

    Freezing Panes and Splitting Windows
    05:57

    Tiling Windows
    05:53

    Viewing Multiple Worksheets
    03:54
    +
    Collaborating
    3 Lectures 21:20
    Protecting Cells
    06:55

    Using Comments
    05:35

    Working with Track Changes
    08:50
    +
    Printing and Page Setup
    4 Lectures 29:54
    Using Page Break and Print Preview
    06:18

    Changing Page Setup
    06:56

    Adding Headers and Footers
    08:41

    Setting Print Titles and Print Areas
    07:59
    +
    Conclusion
    1 Lecture 01:55
    Conclusion
    01:55
    About the Instructor
    Intellezy Trainers
    4.4 Average rating
    5,076 Reviews
    29,023 Students
    137 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.