Microsoft Excel 101 Course - Introduction Excel

Learn Microsoft Excel skills that will give you a solid foundation throughout your Excel career. Exercise files provided
4.6 (24 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.
668 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 59
  • Length 4 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 1/2016 English

Course Description

Quickly Get Up To Speed On Excel Basics

**************** Course Material Works in Excel 2010, 2013 and 2016 *******************

During this Microsoft Excel 101 course you will gain a solid foundation on which you will build the rest of your Excel experience on. Enroll now and I'll guide you step-by-step, exercise files included, through the basics of working with the most powerful spreadsheet tool on the market. In very little time you will master the basics of Excel that'll provide a foundation for more advanced Excel techniques (Course: 102, 103 (Coming Soon)).

Each section in this course will introduce you to a key foundational Excel concept that you will quickly master.

  • Understanding the Excel Interface and Document Structure
  • Entering and Working with Data in an Excel Worksheet
  • Working with Formulas and the most common Excel Functions
  • Formatting Your Excel Data to make it more Presentable
  • Creating and Working with Excel Charts to Visually Present Data
  • Preparing Your Excel Documents to be Printed
  • Creating an Excel Template for Easy Reuse


At completion of this Excel 101 course you will have mastered the above Excel concepts and able to complete the fundamental day to day tasks of an Excel worker.

Each section also includes a quiz to test the knowledge you will gain and exercise files for you to download and practice with. These are the same files that are used in the video lectures.

So, what are you waiting for, enroll now and build a solid foundation within Microsoft Excel.

What are the requirements?

  • You will need Excel loaded on your computer in order to follow along and complete the exercise files provided in each section.
  • Videos have been recorded using Excel 2013, but Excel 2007, 2010 , 2013 or 2016 will work in order to follow along.

What am I going to get from this course?

  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel Functions used in the office
  • Shortcuts to save on common Excel tasks
  • Access to a Professional Trainer with 10+ years of Excel Training

What is the target audience?

  • This Microsoft Excel 101 course was designed for those who are just starting out in Excel or for those that are looking to refresh their own skills and pick up some shortcuts and hidden gems within 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: Microsoft Excel 101 Course Introduction
04:16

During this lecture you will be introduced to the topics that you will be learning and mastering throughout this course.

Course Exercise Files
01:09
Section 2: Excel Fundamentals
02:34

This lecture will walk you through the steps of opening Microsoft Excel to begin working

04:50

This lecture will walk you through the ins and outs of the Excel Interface

  • The ribbon
  • Quick Access Toolbar
  • Formula Bar
  • Status Bar
03:53

During this lecture you will learn how to get quick, easy access to all your favorite Excel commands by customizing the Quick Access Toolbar

05:02

This lecture will walk your through the Excel document structure

  1. Workbook
  2. Worksheets
  3. Columns/Rows/Cells
02:44

This lecture will walk you through the various save features found in Microsoft Excel

02:02

During this lecture you will learn how to open an existing Excel document

5 pages

This lecture will introduce you to some of the more common shortcut keys used for Excel basic commands

4 questions

Test your knowledge on the fundamentals of Excel

Section 3: Entering and Editing Text and Formulas
05:35

During this lecture you will begin create a Monthly Budget Spreadsheet, adding both column and row headers representing dates and monthly bills

03:31

During this lecture you will be introduce to the differences between Alpha/Text and Numeric data in an Excel Worksheet

04:44

During this lecture you will learn how to work with Date values in your Excel worksheets

03:55

During this lecture you will learn how and why of referencing data through Excel Cell Addresses

07:02

During this lecture you will be introduced to the basics of creating an Excel Formula and using Mathematical Operators to perform vatrious types of math

10:38

During this lecture you will be learn the differences between a Relative and an Absolute Cell Reference

03:20

During this lecture you will apply the mathematical concept of the Order of Operation to Excel formulas

4 questions

Test your knowledge on Entering Text and writing Formulas in Excel

Section 4: Working with Basic Excel Functions
02:17

During this lecture you will be introduce to the building blocks of Excel Functions

  1. Equals Sign
  2. Function Name
  3. Function Arguments
04:50

During this lecture you will learn the most popular Excel function, the SUM() Function

03:47

During this lecture you will learn how to find the lowest and highest value from a range of cells using the MIN() and MAX() Functions

02:38

During this lecture you will use the AVERAGE Function to average a range of cells

02:15

During this lecture you will learn how to work with Excel's COUNT() Function to a Count the number of cells that contain data

04:55

During this lecture you will learn how to speed up your Function creation by using Excel's built in AutoSum command

03:09

During this lecture you will learn how to copy formulas quickly using Excel AutoFill command

4 questions

Test your knowledge on Excel Functions

Section 5: Modifying an Excel Worksheet
04:34

During this lecture you will learn how to move and copy data in your Excel Worksheets

05:27

During this lecture you will learn how insert rows and columns into an existing Worksheet within your spreadsheets data

05:06

During this lecture you will learn how to change the width and height of cells within your Excel Worksheet

02:51

During this lecture you will learn how to hide specific data ranges in your Excel Worksheets

02:53

During this lecture you will learn how to Delete an Excel Worksheet from your Excel Workbook

01:58

During this lecture you will learn how to rename and Excel Worksheet

04:12

During this lecture you will learn how to move and copy and Excel Worksheet

4 questions

Test your knowledge on modifying worksheets

Section 6: Formatting Data in an Excel Worksheet
03:54

During this lecture you learn how to use the formatting commands that deal with formatting your text

  • Bold
  • Underline
  • Font Size
  • Font Color
  • Italics
02:50

During this lecture you will learn how to change the background color of your data

03:33

During this lecture you will be introduced to added border to a single cell or range of cells

05:21

During this lecture you will learn how to change the formatting of your numeric data to represent currency values

02:17

During this lecture you will be introduced to formatting numeric data as percentage style


02:47

During this lecture you will learn how to copy cell format and apply it to other cells in the Workbook

08:12

During this lecture you will learn how to create Excel formatting styles to save your formatting options and apply them when needed.

02:50

During this lecture you will learn how to merge multiple cells into one cell and center the content within the merged cells

04:34

During this lecture you will learn to harness the power of Excel's Conditional Formatting feature, formatting data once a condition is met.

  • Cell is greater than...
  • Cell is equal to...
  • Cell contains no value
  • etc...
4 questions

Test your knowledge on formatting data in an Excel Workbook

Section 7: Inserting Images and Shapes into an Excel Worksheet
04:09

During this lecture you will learn how to insert and work with images in an Excel Worksheet

03:55

During this lecture you will learn how to insert Excel shapes into an Excel Worksheet

04:39

During this lecture you will learn how to format Excel shapes

  • Fill Color
  • Border Color
06:46

During this lecture you will be introduced to working with SmartArt, a collection of diagrams to visually display your data.

Section 8: Creating Basic Charts in Excel
04:53

During this lecture you will learn how to create an Excel Clustered Column Chart

05:24

During this lecture you will get an overview of the Chart Ribbon where you will find all the Excel Chart features

03:08

During this lecture you will learn how to add additional data options to your Excel charts

04:40

During this lecture you will learn how to format an Excel chart to make it more presentable

02:31

During this lecture you will learn how to move an Excel Chart to it's own Worksheet

05:06

During this lecture you will learn how to create an Excel Pie Chart and work with some of the options of a Pie Chart

3 questions

Test your knowledge on creating Excel charts

Section 9: Printing an Excel Worksheet
02:11

During this lecture you will get an introduction to working in the Print Preview window and preparing your document to be printed

Changing Margins, Scaling and Orientation
08:06
Working with the Page Layout View
03:49
Adding a Header and Footer
04:35
Printing a Specific Range of Cells
02:58
4 questions

Test your knowledge on printing an Excel Worksheet

Section 10: Working with Excel Templates
01:31

During this lecture you will be introduced to the concept of working with templates within Excel.

05:33

During this lecture you will learn how to take advantage of the templates that come with Excel

04:36

During this lecture you will take the Monthly Budget spreadsheet we have created during this course and turn it into a template

2 questions

Test your knowledge on Excel Templates

Section 11: Congratulations! You've Built a Solid Excel Foundation
Congratulations!
00:52
BONUS! - Special Offer! Discount on Any of my Courses!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kyle Pew, Microsoft Certified Trainer - 25,000+ Udemy Students

Qualifications:

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...


What Students have said about Kyle:

      • "Kyle was off the chart "GOOD""

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

      • "Kyle Pew is very knowledgeable and presented information with exceptional skill."


In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

Ready to start learning?
Take This Course