Microsoft Excel 101 Course - Introduction Excel
4.5 (38 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.
704 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel 101 Course - Introduction Excel to your Wishlist.

Add to Wishlist

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.5 (38 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.
704 students enrolled
Created by Kyle Pew
Last updated 8/2016
English
English [Auto-generated]
Current price: $10 Original price: $40 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • 12 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
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.
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.

Who 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.
Curriculum For This Course
59 Lectures
03:57:41
+
Microsoft Excel 101 Course Introduction
2 Lectures 05:25

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

Preview 04:16

Course Exercise Files
01:09
+
Excel Fundamentals
7 Lectures 21:05

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

Preview 02:34

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

  • The ribbon
  • Quick Access Toolbar
  • Formula Bar
  • Status Bar
Preview 04:50

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

Preview 03:53

This lecture will walk your through the Excel document structure

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

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

Preview 02:44

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

Preview 02:02

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

Common Shortcut Keys
5 pages

Test your knowledge on the fundamentals of Excel

Excel Fundamentals Quiz
4 questions
+
Entering and Editing Text and Formulas
7 Lectures 38:45

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

Entering Text to Create Spreadsheet Titles
05:35

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

Working with Numeric Data in Excel
03:31

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

Entering Date Values in Excel
04:44

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

Working with Cell References
03:55

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

Creating Basic Formulas in Excel
07:02

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

Relative Versus Absolute Cell References in Formuals
10:38

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

Understanding the Order of Operation
03:20

Test your knowledge on Entering Text and writing Formulas in Excel

Entering and Editing Text and Formulas Quiz
4 questions
+
Working with Basic Excel Functions
7 Lectures 23:51

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

  1. Equals Sign
  2. Function Name
  3. Function Arguments
The Structure of an Excel Function
02:17

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

Working with the SUM() Function
04:50

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

Working with the MIN() and MAX() Functions
03:47

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

Working with the AVERAGE() Function
02:38

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

Working with the COUNT() Function
02:15

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

Using the AutoSum Command
04:55

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

Using the AutoFill Command to Copy Formulas
03:09

Test your knowledge on Excel Functions

Basic Excel Functions Quiz
4 questions
+
Modifying an Excel Worksheet
7 Lectures 27:01

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

Moving and Copying Data in an Excel Worksheet
04:34

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

Inserting and Deleting Rows and Columns
05:27

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

Changing the Width and Height of Cells
05:06

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

Hiding and Unhiding Excel Rows and Columns
02:51

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

Deleting an Excel Worksheet
02:53

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

Renaming an Excel Worksheet
01:58

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

Moving and Copying an Excel Worksheet
04:12

Test your knowledge on modifying worksheets

Modifying Worksheets Quiz
4 questions
+
Formatting Data in an Excel Worksheet
9 Lectures 36:18

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

  • Bold
  • Underline
  • Font Size
  • Font Color
  • Italics
Working with Font Formatting Commands
03:54

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

Changing the Background Color of a Cell
02:50

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

Adding Borders to the Cells
03:33

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

Formatting Data as Currency Values
05:21

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


Formatting Percentages
02:17

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

Using Excel's Format Painter
02:47

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

Creating Styles to Format Data
08:12

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

Merging and Centering Cells
02:50

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...
Using Conditional Formatting
04:34

Test your knowledge on formatting data in an Excel Workbook

Formatting Data Quiz
4 questions
+
Inserting Images and Shapes into an Excel Worksheet
4 Lectures 19:29

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

Inserting Images
04:09

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

Inserting Excel Shapes
03:55

During this lecture you will learn how to format Excel shapes

  • Fill Color
  • Border Color
Formatting Excel Shapes
04:39

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

Working with Excel SmartArt
06:46
+
Creating Basic Charts in Excel
6 Lectures 25:42

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

Creating an Excel Column Chart
04:53

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

Working with the Excel Chart Ribbon
05:24

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

Adding and Modifying Data on an Excel Chart
03:08

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

Formatting an Excel Chart
04:40

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

Moving a Chart to another Worksheet
02:31

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

Working with Excel Pie Charts
05:06

Test your knowledge on creating Excel charts

Working with Excel Charts Quiz
3 questions
+
Printing an Excel Worksheet
5 Lectures 21:39

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

Viewing your Document in Print Preview
02:11

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

Test your knowledge on printing an Excel Worksheet

Printing an Excel Worksheet Quiz
4 questions
+
Working with Excel Templates
3 Lectures 11:40

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

Intro to Excel Templates
01:31

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

Opening an Existing Excel Template
05:33

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

Creating a Custom Template
04:36

Test your knowledge on Excel Templates

Working with Excel Templates Quiz
2 questions
1 More Section
About the Instructor
Kyle Pew
4.6 Average rating
13,947 Reviews
70,432 Students
16 Courses
Microsoft Certified Trainer - 65,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!