Microsoft Excel 2013 Advanced

Quick Facts

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

Master advanced features and functions of Microsoft Excel 2013, including analysis tools, data tables, PivotTables, and conditional formatting.

Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximise this program's functions and capabilities.

Most organisations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organisation.

You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarise data from multiple sources, become adept at importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.

Learn how Excel 2013 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!

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.

Over the next six weeks, we're going to explore Microsoft Excel 2013's sometimes-overlooked and advanced features. You'll learn how to use data analysis tools and techniques to improve your decision making, and you'll practice generating accurate data more quickly. By the end of this course, you'll be well prepared to contribute more value to your organization with your advanced understanding of Excel. To kick things off, we'll spend this first lesson exploring how you can modify Excel to streamline processes and make your work easier. You'll use the Excel Options dialog box to customize some of Excel's behind-the-scenes behavior, set up your Quick Access Toolbar, and take a look at the status bar and its customizable features. Mastering these processes will lay the foundation for our exploration of advanced topics throughout the course.

Today we'll explore some great table management features in Excel 2013, discuss how to use data forms with Excel databases, and look at a few alternative database techniques. You'll be glad to know that formatting and working with tables has gotten much easier in this latest version of Excel. Now, instead of applying filters, total rows, and formats separately, you can perform these actions through a single user interface. We'll delve into how it's done. You'll also learn how data forms provide a more user-friendly method for adding, deleting, and editing records in a table, and you'll practice using a data form to search for and view records that match specific criteria. We'll wrap things up with a brief look at some of the practical applications for data forms.

In this lesson, we'll tackle data validation techniques—your first line of defense against incorrect or missing data and the logical next step after data forms. You'll practice using whole number, decimal, date, time, list, and other forms of validation. After that, we'll explore the possibilities of custom validation, which allows you to apply validation on a cell or range of cells based on a formula you create. The possibilities for using it are limitless! You'll also learn how to create input messages and error alerts to guide the user's data entry, how to keep track of validation rules, and how to apply a custom validation rule to other cells so that you don't have to create it all over again.

In the first three lessons, we covered what you might call intro-level advanced Excel topics, and now it's time to head into more complex territory. So today, let's start working with custom controls—graphical objects that help facilitate data input and are sure to impress users. We'll start by getting your Ribbon set up to work with custom controls, and then we'll walk through some practice exercises. You'll learn how to create standard and drop-down list boxes, check boxes, option buttons, and group boxes. You'll also master the process of creating a dynamic list box, which allows you to control the values in one list box based on the values chosen by your user in a separate custom control.

Today you'll discover how to use conditional formatting. And I'm not just talking about creating validation based on cell values. We'll do a quick review of that process, just as a refresher, but after that we're going to focus on formula conditional formatting. We'll work through nine different practice exercises that explore row conditional formatting, and we'll briefly discuss how the formula works after each exercise. You'll see how to use conditional formatting to hide errors, to highlight records based on multiple criteria, to track and alert you about due dates, to find the differences between two lists, to shade every other row (my personal favorite), and more. I think you'll especially enjoy learning how to set up a scorecard, which will show you problem areas in red, possible problems in yellow, and everything running smoothly in green. (Your manager will love this.)

In this lesson, you'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources. A lot of people do this the hard way, but with Excel's automatic consolidation feature, you'll no longer need to develop a web of formula links to multiple sources. Goodbye, potential for human error! We'll begin with an exercise on consolidating data within the same workbook, and after that, you'll practice consolidating using an advanced technique with category labels and wildcards. Next, we'll step things up with a practice exercise on consolidating from multiple workbooks. You'll also learn how to use automatic and manual outlining to view or hide different levels or sections of your information.

Excel's functions (or predefined calculations) are too numerous to completely cover in one lesson, so today we'll just focus on a few important ones spanning four categories: Logical, Database, Math & Trig, and Lookup & Reference. We'll start today with an overview of functions, take a look at the Insert Function dialog box, and then practice working with the IF function, nesting functions, the DSUM function, and the VLOOKUP function—all of which will come in handy when you need to perform a quick, thorough analysis of your data.

In this lesson, you'll find out all about importing external data. We'll begin with a practice exercise to get you comfortable with importing data from another Excel file, during which you'll see how to use the Microsoft Query Wizard. You'll test two methods for refreshing the target area for the imported data and find out how to edit an Excel query. After that, you'll do an import from an external database. Finally, you'll learn how to perform a Web query, which—you guessed it—allows you to import data from the Internet. The Web query feature is another fantastic feature in Excel 2013.

It's time to look at data tables, which let you compare the outcomes of different versions of the same formula without slogging through the process of calculating each of them. Data tables are very powerful what-if analysis tools that are great for analyzing potential outcomes of personal or business financial decisions. In this lesson, you'll learn how to use two types of data tables: a one-variable data table (which lets you substitute just one variable into the formula calculation) and the two-variable data table (which allows you to change multiple aspects of the formula).

Today we'll explore three more of Excel's what-if analysis tools: Goal Seek, Scenario Manager, and Solver. You'll find out how to use Goal Seek to solve formulas backward—for example, you might want to do this if you knew the result you wanted but needed to determine how to change a single input cell in order to get that desired result. After that, we'll practice using Scenario Manager to create and save different input values and their results as scenarios (great for working on budgets). And finally, you'll put Excel's Solver to work to discover the optimal solution to models that have multiple variables and constraints.

In this lesson, you'll discover how to use PivotTables, which are excellent for summarizing massive amounts of data and viewing different cuts of the information quickly. There are two methods for creating PivotTables, and you'll practice using both. You'll also learn how to edit a PivotTable, how to filter the table to create individual reports, how to format a PivotTable to make it reader-friendly, how to insert a Timeline, and how to create and use calculated fields and items. After this, you'll create a PivotChart based on the data fields in your PivotTable. We may not be quite done with the course, but after mastering PivotTables and PivotCharts, you'll certainly be able to count yourself an advanced Excel user.

We'll begin our final lesson with a look at the functions available in the Analysis ToolPak, including two of my favorites: the Moving Average and Sampling tools. You'll complete an exercise using advanced filters, and then I'll show you some of my favorite Excel tips and tricks. You'll find out how to work with the View Side by Side tool and how to use the Watch Window to keep tabs on your data when you're updating a workbook. We'll wrap things up with practice exercises using array formulas and the AutoSum Tool. When you're done with this lesson—and the course—you'll want to pass along the techniques you've learned to friends and colleagues who are still wrestling with Excel!

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 Advanced 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 Advanced:

Microsoft Excel 2013 Fundamentals

Microsoft Excel 2013 Intermediate

QuickBooks 2014 Fundamentals

SQL Fundamentals

SQL Intermediate

Discover more online courses

Microsoft Excel 2013 Advanced

$599

$389AUD

Save 35%

Write Fiction Like a Pro

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
6825 Students

A Hollywood writer and author teaches you how professional writers use story outlines to structure any type of story.

What's the single biggest difference between professional authors and novices? Professionals know how to structure novels and stories for maximum dramatic effect. This course helps you develop the same story structuring skills the pros use. You'll understand how your passion, theme, premise, and characters help you create the structure of your story, and you'll discover how viewpoint, dialogue, pacing, and many other techniques are used to build scenes and move your story from beginning to end.

Each assignment in this course helps you develop your own original novel or story. As you apply each technique, your story will take shape, with a clear path from beginning to end. And whenever you have questions or insights to share, you can join your instructor and classmates in the Discussion Area for some interactive brainstorming! Before you know it, you'll be prepared to ...write fiction like a pro.

The name of this course really says it all! For the next six weeks, we'll focus on techniques that professional authors use to write effectively and efficiently and that guarantee a story structure that delivers maximum emotional impact. After all, connecting with your audience is what great writing is all about, right? In this first lesson, we'll explore the idea of story structure, and you'll discover that nearly every piece of fiction that works follows the same fundamental rules. We'll also look at the often misunderstood difference between story and plot, a concept that will be vital throughout the rest of this course.

At the heart of every story are the dramatic elements of passion, theme, character, and premise. Your passion is what drives you to tell your story, and the theme is the underlying message it carries. To convey your theme, you'll create characters who represent that theme—either positively or negatively. Put all of these together and you've got your premise. We'll talk about all of these elements in today's lesson.

Character is what story is all about. Without a character, and a change in that character, there can be no story. In this lesson, you'll discover why the best characters are flawed. We'll explore your main character—the protagonist—and the opposition forces of the antagonist. And finally, we'll take a look at the other characters who round out your story.

Today's is the first of three lessons in which you'll see how to construct a story outline, act by act. In Act 1, you'll learn how to hook your readers. Then you'll fill them in with some character history called backstory. And finally, you'll exit Act 1 with a bang by triggering a traumatic event in the life of your protagonist.

If Act 1 ends with a bang, Act 2 starts with a whimper. Your protagonist begins in crisis, an emotional state brought on by his or her flaw. And because of that flaw, your protagonist will struggle throughout Act 2, as the antagonist delivers setback after setback. Fortunately, at the conclusion of Act 2 your protagonist finally figures out the source of all this emotional distress and how to overcome it.

The epiphany that ended Act 2 has prepared your protagonist for triumph in Act 3. Now it's time to devise a plan. The result will be a final confrontation with the antagonist. In this lesson, we'll discuss the best way to arrange the defeat of your antagonist—it's not what you might guess. Then, with that climax behind you, you're ready to tie up loose ends in the ending.

We've accomplished a lot in the last few lessons. By now you should be pretty comfortable with story structure. In the next three lessons, we'll take the concepts you've learned so far and apply them to the development of a real novel. Today we'll begin by using the dramatic elements to create a character, his or her flaw, and then put it all together into a formal story idea.

In this lesson, we'll expand the story idea for a novel into the nine checkpoints of our three-act outline. This is quite a challenge for just one lesson, but we've become pretty expert at this story structuring stuff by now, so let's go!

Now that you have your outline—and a beautiful one it is!—it's time for that magical moment when you begin expanding it into the long form. Yikes! The actual novel is about to materialize. We'll begin by inserting markers for the scenes that support and develop the outline. Then you'll start expanding those scenes and threading your theme throughout. This is really writing like a pro!

One of the most important choices an author makes is viewpoint. It affects every aspect of the story—from theme, to pacing, to suspense. In this lesson, we'll explore the three most common viewpoints—omniscient, third-person limited, and first person—and discover their advantages and disadvantages. Then we'll dig into techniques for developing characters and establishing a convincing story logic.

In this lesson, we'll look at techniques for refining your plot and controlling its pace. Then we'll unravel the internal structure of every piece of fiction you've ever read, discovering a structure that I bet you never knew existed. After today, you'll never forget it. It's called scene and sequel.

Now that your novel, play, or screenplay is well underway, it's time to think about polishing the final product. In this lesson, we'll look at some techniques for making your writing sparkle, including tips on dialogue and imagery and how to use them to show, not tell. We'll also see how to establish your own unique voice, paying special attention to the aspects of cadence and musicality. Finally, we'll talk a little about the creative process and your role now that you know how to . . . write like a pro.

Steve Alcorn

Steve Alcorn is the published author of a wide range of fiction and nonfiction works including the mystery A Matter of Justice, the historical novel Everything in Its Path, the romance Ring of Diamonds (under the pseudonym Sha... Read more

Read Steve Alcorn'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

If you have an idea for a book, but just can't get it together, this is the class for you. Steve Alcorn gives you the tools and the confidence to pull your ideas together and give them structure. Before you know it, you are inspired and writing. What a class! Steve Alcorn is a gifted instructor.

Verified Student

I have taken both Write Like a Pro and Steve's Mystery Writing course. I have now published three of the stories I worked on in Write Fiction Like a Pro, as a result of the course. Thank you, Steve, for offering it.

Verified Student

Can you see me? I'm giving you a standing ovation! Haven't done this much thinking, rethinking, breaking pencils, and eventually cheering since I graduated from college. Thank you for an inspiring and brilliant class!

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Write Fiction Like a Pro 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