Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Comprehensive Microsoft Excel
Rating: 4.4 out of 5(9,612 ratings)
24,383 students
Created byJordan Hudgens
Last updated 10/2013
English

What you'll learn

  • By the end of this course you will be able to quickly and masterfully utilize Microsoft Excel, including how to: design and template worksheets, manipulate text, build complex financial models, apply conditional formatting, and be able to utilize shorts that will make using Excel an efficient process.

Course content

3 sections • 31 lectures • 2h 33m total length

  • Intro to Excel Tutorial2:21
  • How to Configure Excel3:53
  • How to Design and Format an Excel Spreadsheet4:07

    Design and format a professional Excel spreadsheet by inserting a logo, merging and centering the header, aligning text, applying borders and color, and adjusting decimal and orientation.

  • Sorting and Filtering Data in Excel4:58

    Learn to sort and filter data in Excel, clean up a large rig dataset by deleting unnecessary columns, replacing text patterns, and applying borders and color for readable, shareable results.

  • Text Formatting6:31
  • Connecting Text Columns in Excel4:44
  • Managing Tabs5:34
  • How to Pull Data from Tabs in Excel4:30
  • How to Use the Format Painter2:58
  • How to Freeze the Top Row in Excel4:09
  • How to Add a Header and Footer3:34

    Learn to insert and customize headers and footers in Excel using the page layout ribbon, page setup, and header/footer options, including page numbers, dates, and file paths for printed documents.

  • How to Print an Excel Spreadsheet on One Page2:47

Requirements

  • Basic understanding of how to use a computer.

Description

Learning Microsoft Excel has never been more important. No matter what industry you may work in, being able to create functional spreadsheets is no longer optional, it's required.

Upon completing the course you will receive an official certificate of completion.

Some of the benefits to this Edutechional course are:

Project based tutorials - This means that you won't be wasting time on the theory behind spreadsheet development, you will be able to jump right in and learn how to build practical worksheets.

Comprehensive series - Whether you are a beginning level student or you have been using Excel for years, this course offers a full suite of tutorials that can supply you with tools that will help you in your job immediately.

Experienced instructor - The instructor for this course, Jordan Hudgens, has been teaching users all over the world how to design, manage and improve Excel worksheets for the past decade, and in this course you will get access to a wealth of knowledge!

Who this course is for:

  • This course can be utilized by beginner through advanced Excel students alike.

Report abuse