Microsoft Excel 2013 Fundamentals

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
2528 Students

Become proficient in using Microsoft Excel 2013 and discover countless shortcuts, tricks, and features for creating and formatting worksheets quickly and efficiently.

Do you work with numbers? Then you need to master Microsoft Excel 2013—and this is the place to do it. Even ""non-techie"" beginners will find it easy to learn Excel in this fun, step-by-step online course.

These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.

In addition, you'll get tips on sorting and analysing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers the new Quick Analysis, Flash Fill, and charting capabilities available in Excel 2013.

This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2013 application like a pro.

Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.

This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.

In our first lesson, you'll develop a solid understanding of the Excel interface. You'll become fluent in the secret language spoken only by Excel users, you'll discover the best way to correct just about any mistake you might make in Excel, and you'll find yourself gliding effortlessly from cell to cell, leaving behind expertly written labels, numbers, and formulas.

In this lesson, you'll learn five simple steps you should always follow to ensure that your worksheets are always well-planned, well-constructed, and beautifully formatted.

Our third lesson will teach you the tricks of the Excel masters: a wide variety of useful shortcuts guaranteed to save you time, energy, and frustration. We'll also spend some time working with the Quick Analysis and Flash Fill tools, introduced in Excel 2013. By the time you finish this lesson, you'll really start to feel like an Excel pro.

Do you know the difference between a relative reference, an absolute reference, a mixed reference, and a circular reference? You will after this lesson. Today, we focus on writing sophisticated formulas that can help ease us through some rather sticky scenarios.

With enough practice, most Excel users quickly become adept at organizing their worksheets across two dimensions: rows and columns. But only a select few will learn how to take their worksheets into the third dimension. Today, you'll join that exclusive group. Prepare to have your socks knocked off as you gain hands-on experience in the construction of three-dimensional workbooks.

No Excel course would be complete without a discussion of Excel's amazing data-crunching capabilities. Today, you'll not only learn how to build a table in Excel, you'll also learn how to subtotal, sort, and filter.

In this lesson, we'll explore the exciting world of charts. You'll build your first graph today, and you'll learn how easy it is to adjust the chart type, labels, titles, colors, and many other aspects of your chart.

Today, you'll dig deep into Excel's charting capabilities. You'll explore everything from bar charts and line charts to more prosaic graphs like the pie chart and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings. You'll also discover the best ways to format your chart for print or otherwise display the truly impressive charts that you'll be creating.

Excel includes many powerful functions that can automatically perform some very complicated tasks for you. In today's lesson, you'll learn some very interesting ways to put these functions to work for you. You'll find out how to ask Excel to magically derive averages, modes, maximums, minimums, and other useful statistics from nothing more than a column or two of numbers.

We'll continue our exploration of Excel functions with an in-depth look at Excel's handy financial functions today. By the time this lesson is over, you'll be able to figure out how much money you'll have when you retire, when your kids reach college, or just before your next vacation. You'll be able to calculate the monthly payment on just about any type of loan, and you'll know how to figure out how long it will take to pay off your credit cards. You'll even create an amortization table of your very own, just like the one lenders use to track a loan's payoff amount over time.

Students often rank this lesson as one of their favorites. Today, you'll find out how to automate just about any task you find tedious or time-consuming. You'll discover how to move your most frequently used commands from their present, obscure locations to a much more convenient place: the toolbar that's always perched at the very top of your screen. You'll also learn how you can use macros to reduce just about any complex task to a single keystroke.

I think you'll be intrigued by our final lesson, in which you'll learn how to use Excel to aid you in decision making. We'll use a special function in Excel that allows it to make comparisons and use those comparisons as the basis for important decisions.

Chad Wambolt

Chad Wambolt is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. He has spent his entire professional career in the finance field, working for both privately and publicly held companies with sales rangin... Read more

Read Chad Wambolt's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Online learning is a flexible way to study that fits around your schedule, giving you the freedom to learn at your own pace from anywhere in the world. You'll have 3 months to complete the course and can take the multiple-choice questions and final exam whenever it suits you.

If you need help, you can contact us anytime. You can also join the discussion area where you can interact with other students. The discussion area for each lesson is open for the entire duration of the course.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

We do not offer extensions or transfers for this self-paced course. However, you will have 3 months to complete the course, and if you need to cancel within the first 10 days of enrolment, we offer a money back guarantee.

What people are saying about our courses

I appreciate what I learned and I gained some new skills in Excel 2013. I learned a lot about the new features and what makes Excel easier to work with, so that was a plus. Thank you for this wonderful course.

Verified Student

Thank you for the awesome lessons! I learned a lot and enjoyed the last three lessons the most. I love Excel and I certainly will recommend this course to everyone.

Verified Student

I found this course to be among the best I have ever taken and I feel like my proficiency, as a result, is going to only improve!

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Microsoft Excel 2013 Fundamentals you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Our Values

Learn At Your Own Pace

We believe in personalised learning. That's why we provide all the tools and support you need to succeed at your own pace. With flexible learning, you'll stay motivated and retain more information. Plus, you can balance your studies with work and family commitments to make your dreams a reality.

We Won't Break The Bank

Education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry with payments plans for just $25 per week. Investing in your future is a smart choice and doesn’t have to break the bank.

Industry-Led Courses

There's no better way to learn than from experts with years of experience in your field. That's why each of our 200+ industry-led courses are designed to give you a real-life perspective on your industry. With our expert mentors, you'll learn from people who have a wealth of knowledge and experience, and who are passionate about sharing it with you.

Get The Personal Support You Deserve

At Vibe Learning, we're real people who are dedicated to providing you with personal support every step of the way. Our industry experts are not only professional and knowledgeable but also incredibly passionate about sharing their expertise with you. With their guidance, you'll gain invaluable insights and practical knowledge to help you succeed.

Still looking?

Check out the following courses related to Microsoft Excel 2013 Fundamentals:

Microsoft Excel 2013 Intermediate

Microsoft Excel 2013 Advanced

Microsoft Excel 2010 Fundamentals

Microsoft Excel 2010 Intermediate

Microsoft Excel 2010 Advanced

Discover more online courses

Microsoft Excel 2013 Fundamentals

$599

$389AUD

Save 35%

Teaching Students With Autism

Now Only

$389

AUD

35% off

$599 AUD

Quick Facts

Delivery Method Online
Professional Certificate
24hrs Suggested Study Time
3 Months Access
Tutor Support
Study On Any Device
4908 Students

Help your students with high-functioning autism and Asperger's Syndrome unlock their potential in the classroom.

Just 20 years ago, we didn't see students with autism in our classrooms. But today, we teach children with high-functioning autism and Asperger's Syndrome right alongside their neurotypical peers. Reaching and teaching these students requires a delicate balancing act: understanding how their brains are wired, helping them turn challenges into opportunities, and learning to enjoy the rich perspective they bring to the classroom.

If you've ever had a student who blurted out in class, screamed when someone patted his or her shoulder, or rocked back and forth in the chair, you'll appreciate the lessons ahead. We'll discover the neurobiology behind these disorders and the way it affects students' behavior, learning, and thinking. Most important, you'll learn creative, easy, low-budget strategies to help these kids succeed in the classroom and beyond.

Develop the skills to counter these students' social awkwardness, sensory sensitivities, meltdowns, problems with homework completion, language reciprocity issues, and violent fixations. Even if you don't have a student with high-functioning autism or Asperger's Syndrome in your class this year, these strategies will equip you to deal with any student who exhibits these characteristics on a regular basis.

You may have already taught students with high-functioning autism or Asperger's Syndrome, but have you taken the time to get to know them? Today we'll discover how their brains are wired differently, the ways they behave, and smart strategies to make the most of the opportunity to teach these kids.

Now that we've met our students, in this lesson we'll develop an understanding of the characteristics they often display in our classrooms. From trouble handling change to difficulty with social interaction, language processing, and distractions, we'll discover how these characteristics shape students' worldview and ability to perform in academic settings.

Did you know that most students with high-functioning autism and Asperger's Syndrome are visual thinkers? Today we'll spend some time determining how these students process information so we can tailor our lesson plans to their preferred learning and thinking styles.

In this lesson, you'll discover how students with high-functioning autism and Asperger's Syndrome struggle socially. We'll talk about the extent of the problem, some of the causes, and its very real impact. Then we'll discuss some nonverbal and verbal exercises we can do in class to lessen these students' social anxiety.

Today we'll explore how students with high-functioning autism and Asperger's Syndrome converse and why it's so incredibly hard for them to keep conversations going. Then we'll talk about a graphic organizer that is very helpful when students need to translate between their thoughts and ours. Finally, we'll cover how to write social stories that help kids understand what's expected of them.

In this lesson, we're going to examine why students with high-functioning autism and Asperger's Syndrome have such delicate sensory sensitivities. Then we'll discuss two strategies for helping them reclaim control over daily experiences that once seemed quite intimidating. Both the strategies we'll discuss are visual ones, and they're wonderfully easy and effective.

Students with high-functioning autism or Asperger's Syndrome are often "little professors" who have highly specialized interests and fixations. How do we direct these gifts for math or language or science into appropriate academic channels? With visual strategies that help students link their interests to the broader world. You'll learn the strategies today!

This may just be your favorite lesson in the course! Every teacher I know is looking for new and exciting strategies to get students to do their homework. Today you'll learn how to engage students with high-functioning autism or Asperger's Syndrome in their studies and link their interests with meaningful learning.

What if you had an emotional meltdown every single day? Would you be excited to get out of bed and do it all over again? Probably not. Many students with high-functioning autism or Asperger's Syndrome are prone to meltdowns and tantrums that derail their focus and take up precious classroom time. In this lesson, you'll learn how to turn these charged encounters into more positive learning experiences.

No one likes to be teased! Sadly, many students with high-functioning autism or Asperger's Syndrome are bullied or made fun of on a daily basis. Because this makes them so fearful and frustrated, they often fixate on objects of power or violence—fixations that can have very serious consequences in today's world. Today we'll delve into how to channel these frustrations into more appropriate feelings.

Imagine what it would be like if your mind raced all the time, darting from thought to thought at warp speed. It would be pretty hard to pay attention to anything, wouldn't it? In this lesson, we'll look at ways to help students focus on our lessons and learn a little something in the process. Here's a hint: Visuals help!

In our final lesson, we'll talk about smart ways to prepare students for life beyond our four walls. It's never too early to start thinking about ways to encourage students to reach their highest potential in future classes, jobs, and social roles. After all, isn't that why we chose to be teachers in the first place?

Ellen Arnold

A veteran educator, Ellen Arnold has been a reading specialist at the primary level, a social studies and reading teacher at the middle school level, and a special educator at the high school level. Ellen has spent years helping learners unlock th... Read more

Read Ellen Arnold's Profile

Frequently Asked Questions

Once you've made the payment, we'll send you a confirmation email with a link to start your course. Feel free to get started whenever you're ready!

You'll have 3 months access to your course. In that time you are free to study at your own pace. The course duration is 24 hours.

Of course! We offer a 7-day money back guarantee. As long as you haven't completed the course, you can get a full refund within 7 days of enrolling.

What people are saying about our courses

I have to say this course is turning out to be wonderful for me! It has helped me to put words on the things I am seeing in and about this child who has been diagnosed Autistic. I am using many of the strategies and suggestions to help him feel more at ease, less anxious(a personal agenda on his desk, a quiet area in the room where he can go when he feels the need) and more verbal with his classmates. I am going to begin working on a couple Social Stories with him. I just love the information you are provided.

Verified Student

I have taken a lot of online classes. I have also gathered a lot of information on Asperger's to help my son and my students. However, I have never had an online class that was so organized, informative, and geared toward us learning about these special students. We were lucky to have such an amazing online course and professor. The children that will be helped by it are lucky to have you in their little corner of the world. Many thanks!

Verified Student

Thank you Ellen for your wonderful guidance throughout this course. Your passion shines through. Your interactions in the discussion areas were insightful and helpful. I am so glad I took this course. I will be taking some great new ideas back to the classroom when I return to work next week, which will enable me to be a more effective teacher. I completed the final exam and scored 100 %, so your teaching methods were very successful. I took this as a two semester credit hour course. I feel very prepared to successfully write on the topics included in the final assignment. I have taken some very good online courses before, but they did not provide the interaction with an instructor as this one did. I really appreciated that feedback so I knew if I was on the right track. Your expertise was so helpful in each of the discussion areas. I liked the structure of the class.

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Teaching Students With Autism you will become an integral part of our learning community. You'll find yourself with the freedom to learn at a speed that suits you, on any device, from anywhere in the world. Achieving your career goals no longer has to mean compromising family and work commitments.

Ready to get started?

Enrol Now