Excel 2013 Introduction

Unleash the power of Excel worksheets
4.5 (5 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.
44 students enrolled
$30
Take This Course
  • Lectures 41
  • Contents Video: 4.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 3/2015 English

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

    What are the requirements?

    • Basic Windows operating skills
    • Basic mouse skills

    What am I going to get from this course?

    • 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

    What 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

    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: Introduction
    Course Introduction
    Preview
    03:15
    Section 2: Getting Started
    What is Excel?
    Preview
    02:48
    Starting Excel and Opening a File
    13:17
    Understanding the Application Window
    10:07
    Cell Addressing and Navigating a Worksheet
    08:27
    Section 3: Basic Worksheet Skills
    Creating a Workbook
    Preview
    02:56
    Entering and Selecting Data
    Preview
    07:47
    Using AutoFill
    06:28
    Using Clear
    05:06
    Working with Worksheets
    06:15
    Using Flash Fill
    09:20
    Saving a Workbook
    05:25
    Section 4: Creating Formulas
    Working with Simple Formulas and Functions
    18:28
    Using AutoSum
    05:13
    Working with Date Arithmetic
    Preview
    02:25
    AutoCalculate
    03:52
    Understanding Relative v. Absolute Cell Addressing
    07:30
    Section 5: Editing a Workbook
    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
    Section 6: Formatting a Worksheet
    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
    Section 7: Working with Large Worksheets and Multiple Workbooks
    Using the Zoom Feature
    03:11
    Freezing Panes and Splitting Windows
    05:57
    Tiling Windows
    05:53
    Viewing Multiple Worksheets
    03:54
    Section 8: Collaborating
    Protecting Cells
    06:55
    Using Comments
    05:35
    Working with Track Changes
    08:50
    Section 9: Printing and Page Setup
    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
    Section 10: Conclusion
    Conclusion
    01:55

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Intellezy Trainers, 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.

    Ready to start learning?
    Take This Course