Microsoft Excel 2013 for the absolute beginner
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
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 2013 for the absolute beginner to your Wishlist.

Add to Wishlist

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
Created by Bobson St. Pierre
Last updated 9/2015
English
Learn Fest Sale
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Excel 2013 to follow along with the 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

  • Who is the target audience?
    • This course is designed for a beginner level person of Microsoft Excel
    Students Who Viewed This Course Also Viewed
    Curriculum For This Course
    Expand All 40 Lectures Collapse All 40 Lectures 02:33:56
    +
    Course Overview
    1 Lecture 01:17
    +
    The Excel User Interface
    5 Lectures 23:59


    Contextual Tabs
    03:09

    Difference Between Workbooks And Spreadsheets
    03:13

    Customizing The Quick Access Toolbar
    02:53
    +
    Working With Cells
    13 Lectures 43:21
    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
    +
    Formatting Your Worksheet
    5 Lectures 20:31
    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
    +
    Working With Workbooks And Sheets
    5 Lectures 19:15
    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
    +
    Printing Your Work
    1 Lecture 09:14
    All about printing your work
    09:14
    +
    Visualizing Your Data Through Charts
    6 Lectures 16:21
    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
    +
    Working With Functions
    1 Lecture 05:07
    Using AutoSum
    05:07
    +
    Working With Data
    3 Lectures 14:51
    Using AutoFilter
    03:56

    Creating A Data List
    04:09

    Using A Data Form
    06:46
    About the Instructor
    Bobson St. Pierre
    1.5 Average rating
    2 Reviews
    59 Students
    3 Courses
    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.