Microsoft Excel 2013 Fundamentals

Picture of 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

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.

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.

Complete Logic Online Course | Vibe Learning
 

Complete Logic

Picture of Complete Logic
Now Only
$449
AUD
24% off
$589 AUD
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • Unlimited Access
  • 80hrs Suggested Study Time
  • Tutor Support
  • Study On Any Device
  • 1021 Students

Combining our Introduction and advanced courses, this Complete Logic Professional Certificate will teach you all the knowledge necessary to start making music with Logic Studio or Express.

Want to learn how to make music with Logic Studio or Express?  This unique online course provides a thorough understanding of the basics as well as advanced techniques of the Logic software.  Designed and presented by Logic expert, Rob Jones you will gain a solid understanding of how to use Logic Studio or Express software.

As well as being guided through the main areas of the software, this course also covers more general producer, performance and production information.

Bonus: In addition to the videos and resources in this course you will also receive a huge collection of nearly 1GB of royalty free samples from loopmasters as well as a cult classic ‘Bass Station’ software synth.

Frequently Asked Questions

Yes you will complete an assessment at the end of each module to achieve an overall percentage grade.

Yes you will receive a professional certificate upon successfully completing this course.

Yes, you can study device.

There are never any guarantees when it comes to getting a job. This course is designed to help you gain the industry knowledge, skills and understanding required to enter this competitive industry.

The Learning Environment

From the moment that you enrol in the Complete Logic 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

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 Complete Logic:

Recently viewed products

Microsoft PowerPoint 2010 Fundamentals Online Course | Vibe Learning
 

Microsoft PowerPoint 2010 Fundamentals

Picture of Microsoft PowerPoint 2010 Fundamentals
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 3390 Students

Learn how to use Microsoft PowerPoint 2010 to create exciting slide presentations that include SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks. 

Take your PowerPoint presentations from ""so-so"" to sensational! In these lessons, you'll learn how to use Microsoft PowerPoint 2010 to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.

First, you'll explore the latest features of PowerPoint, from the all-new File menu to the Backstage View. After that, you'll find out how to create dazzling presentations formatted with themes and a variety of slide layouts. You'll embellish your slides with text, objects, SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks, and you'll discover that global changes are a snap with the Slide Master.

In addition, you'll find out how to download an online image and insert it onto a slide. You'll also discover how to edit clip art, images, WordArt, and shapes easily with the commands on the Ribbon. You'll explore the printing interface in Backstage View, and find out how to view your presentations in the new Reading View.

And that's just the start! You'll also learn how to create a PowerPoint photo album with your digital pictures, and you'll work with PowerPoint Web App—an online version of PowerPoint. Finally, you'll add versatility to your PowerPoint skills as you learn to save presentations as PDF files and videos.

Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!

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.

Come explore the basic features of Microsoft PowerPoint 2010! You'll learn about the Ribbon, which replaces the menu and toolbars so common in other programs written for the Windows operating system. You'll fi<a name="_GoBack"></a>nd out how to plan a presentation and start the PowerPoint program. And you'll practice working with different views, task panes, tabs, and templates.

Now that you know the basics of PowerPoint, it's time to create a presentation from scratch. We'll start by choosing a theme for the presentation and slide layouts. You'll find out about the Live Preview feature, and we'll discuss how to save a file so you can find it later. You'll also create and edit slides in the slide pane and the Outline tab. Finally, we'll go over the ways to put on a slide show. Important stuff in Lesson 2!

Including tables in your presentation lets you present a lot of information in a little space. So in this lesson, you'll add, revise, and reformat tables. I'll also show you multiple ways to open a presentation. Then, I'll teach you how to preserve different versions of your work by using different filenames.

Today we'll cover two topics: printing and proofreading. You'll learn to print your presentation as slides, handouts, an outline, and notes pages. This versatility will really help you connect with audience members! And to make sure your printed presentation is as close to perfect as it can be, we'll explore the spelling checker, the AutoCorrect feature, the Research task pane, and the thesaurus.

We're going to switch gears in this lesson and work with images instead of text, which I think you'll enjoy. I'll show you how to embellish your slides with media clips, which could include illustrations, clip art, photographs, videos, or audio clips. You'll even learn how to download an image from a website and insert the image on a slide.

You're going to work with WordArt, Shapes, and SmartArt objects in this lesson, which I think you'll find exciting. It's fun to transform text into colorful WordArt objects and to draw and fill shapes with color and special effects. You'll learn to group and edit the ob<a name="_GoBack"></a>jects you create. And you'll add visual sophistication to your slides with SmartArt features&mdash;including Venn diagrams, flow charts, and more.

In this lesson, you'll create and edit a chart slide to illustrate statistical data. You'll find this lesson easy if you like working with numbers! But if you don't enjoy math, that's okay&mdash;I'll walk you through everything you need to know and do to create a chart slide. I'll also show you how to change the look of your chart by using Shape Fill, Shape Outline, and Shape Effects.

Making the same changes to dozens of PowerPoint slides is boring and time-consuming. Today we'll look at global changes you can make to your slides, handouts, and notes. For example, if you want to increase or decrease the font size on all the slides in a presentation, just make the change on the Slide Master. You also make global changes when you modify your presentation's theme colors or background.

In this lesson, we'll work with hyperlinks and action buttons. You'll enliven your presentation as you learn to create links from text or objects to other slides, presentations, documents, and Web pages. You can even add sounds and 3-D effects if you want!

Have you seen a presentation where text, images, or entire slides fly in from the top or push up from the bottom? That's animation. In this lesson, you'll learn about slide transitions, and you'll apply animation to individual slides and the Slide Master. You'll also find out how to add sound effects, such as chimes and whooshes. And perhaps most important, you'll learn how to avoid overdoing these effects!

You already know how to apply animation to your slides as they transition. Now it's time to apply advanced animation effects to text and objects on individual slides and Slide Masters. With the animation commands and the Animation Pane, you'll add and reorder animated text and objects on slides. You'll also add sound clips to your presentation.

Now that you know so much about creating PowerPoint presentations, we'll focus on different ways to save and share them. You'll see how easy it is to make your presentation into a PDF file, so it'll be accessible on computers that don't have PowerPoint 2010. You'll learn to open, edit, and share your presentation online with a Windows Live account. And you'll turn your presentation into a video.

Kathy Van Pelt

Kathy Van Pelt

Kathy Van Pelt has been involved in education for many years, teaching and assisting students with microcomputer application courses. Kathy specialises in Microsoft Office applications, the Windows operating system, and keyboarding. For the past 2... Read more

Read Kathy Van Pelt'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

The Learning Environment

From the moment that you enrol in the Microsoft PowerPoint 2010 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.