12 Microsoft Excel Examples Everyone Can Use
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
Wishlisted Wishlist

Please confirm that you want to add 12 Microsoft Excel Examples Everyone Can Use to your Wishlist.

Add to Wishlist

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
Created by Sandy McVey
Last updated 11/2015
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Acquire key skills employers expect
  • Master Excel tips and tricks that enhance proficiency
  • Enjoy using Excel instead of dreading its graph paper interface
View Curriculum
  • 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.

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.

Who 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.
Compare to Other Excel Courses
Curriculum For This Course
13 Lectures
Getting Started
5 Lectures 28:21

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.

Preview 05:58

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.

2. Absolute References in depth

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!

3. IF Function to set a cap or threshold value

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.

4. Named Ranges for use in formulas

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!

5. Dropdown Boxes eliminate key-entry errors

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

Use it or lose it!
1 question
Intermediate Challenges
3 Lectures 27:57

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.

6. VLOOKUP: unique values like zip codes or ID numbers

7. VLOOKUP: close matches like grade conversion from a number to a letter

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.

8. Printing like a pro

Use it or lose it 2
1 question
Impress the Boss
4 Lectures 21:19

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.

9. Chart basics, thermometers (year-over-year), and forecasts

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.

10. Timesheets to calculate volunteer hours or salaries for small businesses

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.

11. Protecting your data and formulas

Use it or lose it 3
1 question

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

12. Helpful Resources
About the Instructor
Sandy McVey
3.6 Average rating
25 Reviews
132 Students
2 Courses
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.