Microsoft Excel 2010 Intermediate

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

Take your Microsoft Excel 2010 skills to the next level as you master charts, PivotTables, Slicers, Sparklines, and other advanced Excel features.

Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010, and discover how this powerful MS Office program can boost your productivity.

In these hands-on lessons, you'll learn how to create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel's other time-saving functions to your repertoire.

So get ready for action-packed learning that will make you an Excel expert!

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 discover why Excel 2010 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So today, you'll find out how to choose the right chart for telling your story, and then how to create, format, and edit your chart to help others clearly visualize that story.

There are so many great charting features and enhancements in Excel 2010, there's no way we could cover all of them in a single lesson. So today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step, so you'll see the value for yourself.

Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?

Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want, but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.

Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!

Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart. Last, you'll become an expert in using a new Excel 2010 PivotTable filtering tool called Slicer.

Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.

There's nothing more exciting than learning how to master a new feature in Excel.  In Excel 2010, Microsoft added a thrilling new feature called Sparklines.  In today's lesson, we'll explore in detail how to create all three types of Sparklines, as well as formatting options for each.  By the end of the lesson, you'll have the skills to create dashboard-like mini charts sure to make you the envy of your office.  If you enjoy creating charts, you'll really enjoy this lesson.

Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?

If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.

Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of Excel 2010's new functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!

Since functions are such an important and integral part of using Excel, we'll spend our final lesson going over a few more of them. Today, you're going to learn how to use the extremely popular VLOOKUP function. If you're already accustomed to using VLOOKUP, don't feel short changed, because we're going to add to the complexity. We're going to use the INDEX and MATCH functions to do something just short of amazing. This is another lesson you won't want to miss!

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.

What people are saying about our courses

I enjoyed the way Mr. Wambolt taught his class. I took both the Basic and Intermediate Excel classes that he taught and I would highly recommend his class to others.
Verified Student
The instructor's writing style, coupled with colored screenshots, made this a very effective learning experience.
Verified Student
This was the second Excel course I have taken, and again it was a great course. I learned many valuable things that I can apply to my job and home business. Thank you for your time and effort in teaching this course.
Verified Student
See More Reviews

The Learning Environment

From the moment that you enrol in the Microsoft Excel 2010 Intermediate 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 2010 Intermediate:

Discover more online courses

Recently viewed products

Picture of Microsoft Excel 2010 Intermediate

Microsoft Excel 2010 Intermediate

$599
$389AUD
Save 35%
Write and publish Your Own Self-Help Books Online Course | Vibe Learning
 

Write and publish Your Own Self-Help Books

Picture of Write and publish Your Own Self-Help Books
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 558 Students

Learn how to position your self-help book for success, write a persuasive proposal for agents and publishers, and use storytelling techniques to make your message compelling.

Are you serious about becoming a published self-help book author—and are you ready to roll up your sleeves and get to work? Then this course is for you!

One of the most important secrets in publishing is that writing self-help books is different from writing books in other genres. That's because in this genre, you can land a writing contract before you complete your manuscript. In these lessons, a New York Times bestselling author shares the secrets for turning a book idea into a winning proposal to sell to publishing houses.

First, you'll learn about two of the most important players in the publishing industry—literary agents and acquisitions editors. You'll discover what they're looking for and find out how to maximise your chances of landing a contract.

Once you understand how the book industry works, you'll explore the three crucial criteria for selecting a topic for your first self-help book. You may even discover that you have more than one book in you! You'll also investigate the pros and cons of collaborating with other writers or having your book ghost written.

Next, you'll conduct a market survey of your key competitors and strategise how to position your book to sell. Then you'll find out the biggest secret for turning a self-help book into a top seller: a great hook! You'll learn the four characteristics of a good hook, and create your own sensational hook.

At this point, you'll get down to business and focus on writing your book. You'll confront one of the most challenging parts of writing a book—putting your life experience and insight into a concise, linear book format. You'll learn how to structure your book, how to speak directly to your readers, and how to use compelling stories to illustrate your message. To wrap up your writing practice, you'll create a dynamic chapter opening and learn how to write a chapter ending that keeps your readers engaged.

As you follow the step-by-step instructions in these lessons, you'll create a polished proposal package consisting of a proposal summary, a writing sample, a press kit, and supplemental information. By the end of the course, you'll have everything you need to start selling your book—and you'll know exactly what agents are looking for in a first-time author!

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 this first lesson, you’ll learn one of the most important secrets in self-help publishing—that self-help books are different from all other writing genres, making it possible for you to land a writing contract before you complete your manuscript! First, you’ll get some surprising advice about what not to do as you start this process, and then you’ll take a tour of the world of self-help publishing. Once you understand how this industry works, you’ll trace the steps you’ll take as you turn your idea into a winning proposal to sell to publishing houses leading—hopefully—to your first book contract! By the end of this lesson, you’ll know all of the elements required in a strong proposal and understand exactly what you need to do to get your work published.

You might be surprised to find out that some of the most successful self-help authors have made a lot of mistakes in their lives! The difference between a “winner” and a “loser” isn’t the number of failures, but whether you learn from these mistakes. In this lesson, you’ll explore your own manuscript-worthy mistakes and learn the three criteria for selecting a topic for your first self-help book. You may even discover that you have more than one book in you! Finally, you’ll learn how to write your own success story that includes five crucial phases so you can begin to turn your experience into a system that can help others.

You've got your idea for a book, but will anyone want to buy it? In this lesson you'll learn how to make an informed assessment of current publishing trends so you can test the waters for your future book. You'll use a model that is helpful when discerning when your book would be best published, and then conduct a market survey of your key competitors on the market today. By the end of the lesson, you'll have a concise summary of the publishing market that you can add to your publishing proposal.

Do you have credibility? In this lesson, you'll gain the insight you need to answer this question with confidence. You'll start by learning more about the various ways authors establish their credibility—through education, professional expertise, personal experiences, and affiliations. Then you’ll look at authors in your subject area to see how they established their authority. This will give you the information you need to examine your own credibility, locate areas that need to be strengthened, and develop a game plan for doing just that. You’ll use these new insights to create two versions of your author bio: a short paragraph for the body of your proposal and an extended bio to include in your publishing package.

In Lesson 5, we’ll take a look at the most important people in your life—your prospective readers. Yes, you must impress your agent and editor, but even if your book is published, without readers to buy your books, your efforts won’t be successful. Essentially, a self-help book is a conversation between you and your readers, except you’re the only one talking. The readers answer you back by either buying, or not buying, your book. You’ll see that everything in your book must speak to your readers’ needs and interests. Without a clear understanding of your audience, you'll probably miss the mark. Finally, you’ll develop a clear definition of your primary and secondary audiences that will be used in your proposal package.

With this lesson, you get to the heart of the course as you begin to explore the content and structure of your book. You'll confront one of the most challenging parts of writing a book—putting your life experience and insight, which is multifaceted, into a concise, linear book format. To triumph over this challenge, you’ll explore the creative process and begin to identify your own strengths and weakness as you consider how to cooperate with your own process. Lastly, you'll see the difference between setting a goal or a “what” and a method to achieve that goal or a “how.”

In today’s lesson, you will learn about two levels of structure present in most self-help books: the overall structure that will become your table of contents and the structure of each chapter. You’ll gain a working knowledge of the four structure models most self-help book authors use. Don’t expect to sit back and absorb knowledge in this lesson! By the time you’re finished, you'll have a completed structure for your book and for the first chapter, which will serve as your writing sample.

With a good hook, your book has the best chances of getting published and onto the shelves of bookstores where excited readers will discover their new favorite author—you! In this lesson, you’ll learn that a good hook is comprised of words that mean something specific to your readers. This might seem obvious, but it requires careful and creative thought to match your hook with your topic and your specific audience. You’ll learn the four characteristics of a good hook. After studying and rating hooks in other books, you’ll be ready to create a sensational hook for your book—which you'll do in this lesson’s assignment.

In today’s lesson, the information you want to share will move from inside your head and onto the page as you begin to draft your sample chapter. You'll start by thinking about the tone you want to set and exploring how it can meet the needs of your audience. Once you’ve set the tone, you'll follow your outline and write a first draft of your paragraphs!

This lesson and the next will demonstrate the importance of using stories that help readers relate to your message. You’ll explore the four purposes of stories which are to engage, illustrate, inspire, and motivate. You’ll discover the many places you can find great stories and learn how to include them without violating other people’s privacy. In addition, you'll explore “voice” in a story: first person, second person or third person. The chapter will wrap up by showing you how to determine how many stories you will need to include in your writing sample.

In this lesson, you return to the craft of storytelling by exploring how the five-part story structure discussed earlier in the course shapes not only your success story, but also any other success stories you include, as well as the overarching structure of your book. You’ll identify where your first draft needs story illustrations. Starting at the easiest place in each story, you’ll write your first draft of each story along with transitions that introduce and conclude each story so that your chapter will read seamlessly. Finally, you’ll write a dynamic chapter opening and learn how to write a chapter ending that keeps your reader engaged and motivated to continue reading on.

The last lesson in this course pulls all of the pieces together. You'll finish writing all sections of your proposal, including the final summary and an annotated outline. Then you'll put all of the information you've gathered and written throughout this course into a proposal package with a professional, simple format. Once you're armed with your book proposal, it's time to take your first step into the publishing world as you gain tips on how to find an agent who will help take you to your ultimate goal: a book contract!

Carmen Berry

Carmen Berry

Carmen Berry, a New York Times bestselling author, has written more than 20 books published by houses such as HarperCollins, Simon & Schuster, and Penguin. She has appeared on high-profile television and radio programs including OprahRead more Read Carmen Berry'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 Write and publish Your Own Self-Help Books 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 Write and publish Your Own Self-Help Books:

Discover more online courses

Recently viewed products

Picture of Write and publish Your Own Self-Help Books

Write and publish Your Own Self-Help Books

$599
$389AUD
Save 35%
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.

What people are saying about our courses

I have no doubt but that I landed on my feet with this course and I'm pleased I committed myself (financially). I'm really pleased I found this course via a web search. I'm pleased I can come and go, stop, repeat and absorb at my own pace. The videos are compact and articulate. I couldn't wish for anything better and look forward to using logic to compose with.
Verified Student
I just cannot find words for your course, especially the Advanced one. Let me tell you I am really satisfied and happy to do this course. This is a miracle how fantastic and endless opportunities in logic and your explanation is always straight and clear. I find your course much more better than go to somewhere in to school to do this, it’s because I can "stop you, rewind you" and I have time go through a difficult part of a certain unit as many time as I want. My Logic knowledge been developed huge!
Verified Student
Before I started the course I already had some knowledge on logic so was unsure whether I needed to start on the beginner’s course or go straight to advanced. After completing the beginners, id highly recommend it as it covers lots i didn't know and offered interesting alternatives and tips with the stuff I did know. The advanced course then goes into much more detail. all through the course you get plenty of support from the course tutors and the sample you get thrown in are a massive bonus! Cheers
Verified Student
See More Reviews

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:

Discover more online courses

Recently viewed products

Picture of Complete Logic

Complete Logic

$589
$449AUD
Save 24%