12 Microsoft Excel Examples Everyone Can Use

Guide to the most valuable Microsoft Excel tips
4.5 (2 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.
5 students enrolled
Instructed by Sandy McVey IT & Software / Other
$19
$20
5% off
Take This Course
  • Lectures 13
  • Length 1.5 hours
  • Skill Level All Levels
  • 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 11/2015 English

Course Description

Excel is the number one program employers ask for by name in job descriptions. This extremely powerful program may not feel as intuitive as other Microsoft products to you. As a computer instructor for 14 years I know how to help you jumpstart learning. Join me for a tour of the key features you need to master to become Excel-lent! Each session of this course includes a workbook for you to download and practice right along with me. Save yourself hours of frustration knowing that there must be a better way to accomplish these common tasks in Excel. Check out the course curriculum. I bet there's at least one task that you struggle with. Join me for a fun and painless learning experience.

What are the requirements?

  • Downloadable practice files are included for every session.
  • Students should have access to Microsoft Office's Excel program version 2007 or newer.
  • All students will have support from a dedicated instructor every step of the way.

What am I going to get from this course?

  • Acquire key skills employers expect
  • Master Excel tips and tricks that enhance proficiency
  • Enjoy using Excel instead of dreading its graph paper interface

What is the target audience?

  • This course is designed for beginners who want to know what all the fuss about Excel is about.
  • It's also for the intermediate and self-taught Excel users who need to "work smarter--not harder".
  • Experts will also find clear directions for some more advanced functions.

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: Sneak Peak
Sneak Peak at Relative and Absolute References in Formulas
Preview
05:02
Section 2: Getting Started
05:58

Learn about how formulas are structured in Excel. Download the practice file and work along through the guided tour as you learn to apply the fundamental functions built into Excel: SUM, AVERAGE, and COUNT.

09:00

By default formula references remain RELATIVE. As the formula is copied to adjacent cells the cell references shift, too. Sometimes there's an advantage to including ABSOLUTE references that don't shift as the formula is copied. This lesson demystifies the process.

05:21

We can make Excel reason as we do using the IF function. IF a doctor see a certain number of patients we won't increase his case load. The reasoning can also be flipped that IF a sales person reaches a certain threshold they'll receive a bonus. Once you understand how the IF functions works, finding ways to apply it ad impress your colleagues becomes fun!

04:02

Those Battleship-like cell references can still be confusing. Learn this under-rated and highly useful trick of naming cell ranges to make formula building more human.

04:00

Increase productivity and reduce keying errors by adding dropdown boxes to your spreadsheets. Those Named Ranges from the pervious lecture really come in handy here!

1 question

Prove to both of us that you understand the trade secrets demonstrated in this course.

Section 3: Intermediate Challenges
06:49

VLOOKUP is often requested because it's not the most intuitive function. Customer Service Representatives should ask callers their zip code and confirm the client's city and state. Get comfortable;e with and apply this function at every opportunity to save yourself time and consequently your employers money.

7. VLOOKUP: close matches like grade conversion from a number to a letter
08:07
13:01

This tutorial is the longest in the course for good reason. Excel has 65,000 columns and over 1 million (ha-ha-ha...evil laugh) rows per worksheet. If you don't set column headers and row labels to repeat your data can end up floating around without any references. Watch, download the file and practice, and watch the tutorial again. You'll never have to curse Excel for making you kill helpless trees the next time you visit the printer.

Use it or lose it 2
1 question
Section 4: Impress the Boss
08:58

Download the associated workbook to sample basic charting skills. Then ramp up your powers be including thermometer and forecast charts that will impress the data analysts on your team.

04:23

Need to track the time your student volunteers spend on task? Perhaps you want to calculate salaries for your mall business. This video takes you through the process step-by-step.

Web security prevents me from posting this Timesheet sample in template format. After downloading the Excel file customize for your situation and save it as the File Type of Excel Template. Then every time you need to begin with a blank timesheet look for it in Excel under your Personal Templates.

07:56

You've worked hard developing your skills and creating workbooks with complex formulas. Learn how to protect your data so others who haven't taken this course don't accidentally corrupt or wipe out your carefully crafted work.

Use it or lose it 3
1 question
Article

There are lots of great resources on the web to continue your learning journey!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sandy McVey, Computer Skill Developer & Professional Floral Designer

I love to teach and enjoy sharing the tips and techniques I've acquired over the years. As one person with two passions: computer skill development and floral design I enjoy applying creative concepts in an organized manner. I balance my instruction the same way, delivering key concepts through familiar analogies and example. Friends ask me how I manage to accomplish so much in a given day. I'm self-motivated -- just like you!

An educational technology consultant and computer skill developer by professional I've developed my knowledge and techniques over the past 15 years. As a Microsoft Office Certified Specialist teaching adult learners I am the often requested guide. I enjoy working with adults looking to improve their skill-set and understand how to target topics that directly support the competencies employers seek. I hope to meet you in "12 Microsoft Excel Examples."

Colleagues encouraged me share my floral design wisdom by developing an online course. Hence the creation of, "Floral Design -- Not Just Flower Arranging," in 2014.

Join my floral design course to learn core concepts to begin your floral design career. I believe that good designs are based on creativity, not budget, and encourage you to make every day a celebration. Floral creations are a natural, non-fattening, feel-good complement to any occasion. I'll show you ways to combine fresh flowers and greenery with silk floral accents and whimsical supplementals such as vegetables, fruits, ribbons, beads, and picture frames to accent life's special moments with your memorable gifts.

Floral design has long been my passion. I've collected an abundance of knowledge through classes, workshops, floral-focused events, and life experiences with my network of like-minded gardeners and designers. I was highly-honored to be selected the people's choice winner of the Container Garden Challenge at the 2014 Philadelphia Flower Show.

I'm also continually learning and look forward to discussions that my udemy courses inspire.


Ready to start learning?
Take This Course