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
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
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.
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.

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 01:22:41
+
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
09:00

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
05:21

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
04:02

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
04:00

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
06:49

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

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
13:01

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
08:58

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
04:23

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
07:56

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
00:02
About the Instructor
Sandy McVey
4.3 Average rating
17 Reviews
108 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.