Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
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.2 out of 5(9,614 ratings)
24,396 students

Comprehensive Microsoft Excel

Discover how to use Microsoft Excel with an easy to follow tutorial series that focuses on project based learning.
Created byJordan Hudgens
Last updated 10/2013
English
English [Auto],French [Auto],

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

    Learn to master Excel from beginner to advanced in a concise two-hour course of 30 videos, covering basics, shortcuts, formulas, charts, and data import to build professional, polished spreadsheets.

  • How to Configure Excel3:53

    Configure Excel by customizing the quick access toolbar and ribbons, adding commands such as paste and copy for faster actions, and managing recent items and pinned workbooks.

  • 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

    Format cells in Excel to display money, dates, percentages, text, and time consistently using the home ribbon. Learn about preserving leading zeros and choosing date formats.

  • Connecting Text Columns in Excel4:44

    Use concatenate formula to create a full name from first and last names in a personnel database, then apply formatting, rotate text, insert left column, and drag the formula down.

  • Managing Tabs5:34

    Manage Excel workbook tabs with insert, rename, delete, duplicate, move, and color options to organize worksheets and keep data well structured.

  • How to Pull Data from Tabs in Excel4:30

    Pull data from multiple tabs in Excel using formulas, lock references with F4, and display player batting averages on a single summary page for quick comparison.

  • How to Use the Format Painter2:58

    Learn to apply formatting quickly with the format painter, using merge and center, borders, bold headers, italics, and color changes to create a cohesive, polished Excel table.

  • How to Freeze the Top Row in Excel4:09

    Learn to keep the top row visible while scrolling in Excel, using freeze panes and rows to repeat at top for printing across all pages, with optional gridlines.

  • 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

    Master controlling the print area and using print preview to fit an Excel worksheet on one page. Adjust margins, scaling, and paper orientation to print efficiently on legal size.

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