Microsoft Excel 2013 for the absolute beginner

A video course that will teach you the ins and outs of this popular spreadsheet program.
0.0 (0 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.
47 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 40
  • Length 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 9/2015 English

Course Description

This Excel 2013 course is designed for the absolute beginner, if you have heard of excel or seen it and wondered what you can do with it then this course is for you. If you have some knowledge but want to improve upon your skills this course is also for you.

If spreadsheet programs over whelms you, rest assured this course we will break down this popular spreadsheet program bit by bit, you will learn everything from entering data into cells to visually analyzing your excel tables using clustered column charts.

Learning My Microsoft Excel 2013 can help you in getting a new job or a promotion in your current position. At the end of this course you will also receive a certificate of completion and have such a thorough knowledge of the program that you will be able to place it on your resume as a skill.

Here are some of the topics we will go over in this course.

  • Create a new workbook
  • Enter data into cells
  • Select cell ranges
  • Copy and paste data
  • Create new sheets
  • Delete sheets
  • Protect sheets
  • Save excel files in PDF
  • Email excel files from excel
  • Analyze your data using Charts
  • Use basic to advance Formulas

  • What are the requirements?

    • Excel 2013 to follow along with the course

    What am I going to get from this course?

    • Create New Workbooks In Excel 2013
    • Understand Excel Terminology
    • Create Basic And Advanced Formulas
    • Visualize Data Using Charts
    • Create Spreadsheets
    • Move Spreadsheets To Other Workbooks
    • Protect Workbooks And Spreadsheets

    What is the target audience?

    • This course is designed for a beginner level person of Microsoft Excel

    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: Course Overview
    Introduction
    Preview
    01:17
    Section 2: The Excel User Interface
    Opening A New Workbook
    Preview
    01:12
    Excel Program Window
    Preview
    13:32
    Contextual Tabs
    03:09
    Difference Between Workbooks And Spreadsheets
    03:13
    Customizing The Quick Access Toolbar
    02:53
    Section 3: Working With Cells
    Entering Data Into Cells
    02:28
    Selecting Cells In Excel
    03:50
    Undoing Mistakes In Spreadsheets
    02:40
    Doing Simple Calculations In Excel
    03:42
    Using AutoFill
    04:39
    Using FlashFill
    02:10
    Working With Columns
    01:57
    Add And Delete Rows
    01:22
    Naming Cells And Ranges
    09:33
    Adding, Deleting And Editing Comments
    03:49
    How To add And Remove Tables In Your Spreadsheets
    02:41
    Using Wrap Text
    00:59
    Text Orientation
    03:31
    Section 4: Formatting Your Worksheet
    Formatting Numbers In Excel
    03:49
    Adding Styles And Formatting To Spreadsheets
    05:59
    Using Format As Table Styles In Your Spreadsheets
    03:36
    Adding Borders In Your Spreadsheets
    01:15
    Conditional Formatting
    05:52
    Section 5: Working With Workbooks And Sheets
    Adding, Deleting and Moving Sheets Between Workbooks
    06:11
    Add Password Protection To Workbooks
    02:26
    Creating Custom Workbook Templates
    04:36
    Password Protect Worksheets
    03:31
    Hiding And Unhiding Spreadsheets
    02:31
    Section 6: Printing Your Work
    All about printing your work
    09:14
    Section 7: Visualizing Your Data Through Charts
    Using Recommended Charts In Your Spreadsheet
    03:09
    Use Quick Analysis Tool To Add A Chart Into Your Spreadsheet
    01:32
    Moving Charts Between Sheets
    01:15
    Change Chart Type
    01:14
    Format Chart Elements
    05:19
    Adding Sparklines
    03:52
    Section 8: Working With Functions
    Using AutoSum
    05:07
    Section 9: Working With Data
    Using AutoFilter
    03:56
    Creating A Data List
    04:09
    Using A Data Form
    06:46

    Students Who Viewed This Course Also Viewed

    • Loading
    • Loading
    • Loading

    Instructor Biography

    Bobson St. Pierre, Excel VBA Programmer & Certified Microsoft Office Specialist

    My name is Bobson St. Pierre I am a Certified Microsoft Office Specialist and have over 14 years of experience in the IT field. I have worked as an Excel VBA programmer, Ms Office Support Specialist, Consultant, and now Trainer. I want to take what I know about Excel and Microsoft Office and share it with you.

    Ready to start learning?
    Take This Course