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.
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.
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.
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!
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.
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!
Prove to both of us that you understand the trade secrets demonstrated in this course.
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.
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.
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.
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.
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.
There are lots of great resources on the web to continue your learning journey!
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.