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%

Medical Writing

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

Take your first step toward a lucrative and rewarding career as a medical writer.

Take your first step toward a lucrative and rewarding career as a medical writer; no specialised or advanced degrees required! In this course, you'll learn about the different types of medical writing that you can do, how to break into and succeed in this industry, and how to write effectively on medical topics, whether you're writing for healthcare providers, patients, or regulatory organisations.

We'll examine the various types of writing that you can do, from producing technical pieces like abstracts and regulatory documentation to writing breezier items like medical news stories and patient education materials. You'll gain insights about what goes into putting together a solid and compelling article, regardless of what you're writing about or who you're writing for. Along the way, we'll review how to consider your audience and construct an outline that addresses your audience's informational needs. You'll also learn how to keep your writing free of medical jargon and common grammatical errors, while ensuring the scientific integrity of your work.

Throughout the lessons, you'll discover lots of invaluable tools and technologies that can make your life as a medical writer easier. We'll examine informational resources, productivity tools, marketing resources, devices, and software, and we'll review how to use them optimally to achieve your goals. You'll also discover numerous tips and tricks that can help set you apart from others in the field and enable you to keep your career momentum going. And of course, you'll master key medical and statistical terms that you'll need to know.

The knowledge you'll gain in this course will give you the foundation and confidence you need to work for almost anyone as a medical writer, whether your goal is to find permanent employment with a company or to work as a freelancer from the comfort of your own home.

In our first lesson, you'll learn what medical writing is all about. We'll discuss what medical writers do and what it takes to be a medical writer. We'll also examine the many types of writing medical writers produce, as well as the tools of the trade—the equipment that medical writers need to have. By the end of this first lesson, you'll have a solid grasp of the field and the items you should have with you as you begin your medical writing career!

Today we'll examine the two main career paths you can take as a medical writer: freelancer and employee. We'll start by examining general factors that you need to consider. Then, we'll examine the benefits and drawbacks of being a freelancer and an employee. After you complete this lesson, you'll have a good understanding of both of these routes, enabling you to determine which one will better serve your needs and objectives.

There are a few core things you'll need to get a handle on before you start any medical writing project: knowing your audience, understanding your topic, and creating your outline. You can't expect to succeed without first tackling these elements, so we'll go into good detail in this lesson! After you complete this lesson, you'll be equipped to lay a solid foundation for your writing, regardless who you're targeting and what you're writing about.

The focus of this lesson is on grammar, which is essential for making your writing polished and coherent. We'll start by looking at key sentence-level issues, including sentence structure and use of punctuation. Then we'll move on to building easy-to-follow paragraphs and transitions, as well as a few rules specific to medical writing!

In today's lesson, we'll focus on language you'll often come across in medical literature. We'll start by looking at abbreviations, including when and how to use them. Then we'll look at how to spot medical jargon. Finally, we'll review some key statistical terms so that you can better understand how to process the information you're writing about. After you complete this lesson, you'll have a better understanding of the language that dominates the medical arena and how to use it!

In this lesson, we'll focus on how to add visual elements to your writing and enhance its readability. We'll start by looking at the accessories you can create: figures, tables, and sidebars. We'll review what these accessories are, when to use them, and considerations to keep in mind when creating them. Then we'll turn our attention to proofreading your work, focusing on strategies you can use to catch errors and improve flow. After you complete this lesson, you'll understand how to add the finishing touches to your work that'll really help it shine!

This lesson is all about ethics! We'll talk about the ethical issues that surround medical writing and the responsibilities that come with authorship. We'll start by looking at scientific misconduct and how it can affect your writing. Then we'll turn our attention to plagiarism and how to avoid it. And finally, we'll review ghostwriting and other situations that can cause ethical dilemmas, as well as steps you can take to secure the integrity of your work. After you complete this lesson, you'll have a good understanding of the ethical terrain that underlies medical writing.

Today we'll examine the markets that need medical writers. We'll start by looking at the pharmaceutical industry, which directly and indirectly employs medical writers. Then, we'll examine medical communications companies, another major employer of medical writers. Finally, we'll review some of the smaller markets, like hospitals, managed care organizations, and professional medical associations. After you complete this lesson, you'll have a good understanding of these markets and where to aim in your job search!

In today's lesson, we'll examine the medical writing freelance arena. First, we'll review how you can build a portfolio, which can be an important tool for helping you secure work. Next, we'll examine where to look for freelance work and steps you can take to increase your odds of finding work. Finally, we'll review the business side of being a freelancer, including how to develop a business plan and which business structures you can consider. After you complete this lesson, you'll have a better understanding of the freelance environment and how you can be successful in it.

How can you find permanent employment as a medical writer? That's what we'll discuss today. First, we'll review how to put together an effective resume and maximize your job search. Then, we'll examine strategies that can enhance your chances of getting an interview, such as constructing a thoughtful cover letter. And finally, we'll look at some ways to really shine during your interview. By the time you finish this lesson, you'll have the knowledge you need to stand out from the crowd, from resume prescreening through the interview process!

Now it's time to think about how you can advance your medical writing career. We'll review credentials you might pursue to make you more enticing to employers or clients, and we'll look at strategies for building a good reputation. Also, every writer's career reaches a standstill at some point—even if you're not there yet, it'll help to be prepared when that happens. We'll close out this lesson by discussing some ways to get career momentum going when you find you've peaked!

How is technology shaping medical writing and the way we look for and find medical information? That's what this lesson is all about. First, we'll review how writing for the Web is different from print and what you need to know to write effectively for online viewing. Then, we'll look at social media and how companies are using them to promote content and brands, and we'll discuss how you can use these platforms to promote your own work. And finally, we'll examine how technology continues to shape the writing world and some technology solutions that can make your life as a medical writer a bit easier!

Christina Loguidice

Christina Torster Loguidice graduated from Rutgers University in New Brunswick, NJ, with a Bachelor of Arts degree in English. She has 15 years of experience as a scientific, technical, and medical (STM) editor and writer and has overseen numerous... Read more

Read Christina Loguidice'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 am so glad I took this course! By the end, I felt empowered to get the medical writing job of my dreams. Christina is very knowledgeable about the industry and offered common-sense tips as well as insider info on how to do well as a medical writer. I look forward to a second course in this series.

Verified Student

Overall, an excellent course with up-to-date useful and actionable information. Well done! Thank you.

Verified Student

Christina is an excellent instructor. Her Explore a Career in Medical Writing course enabled me to open my mind and explore my career options in ways I would never have considered. Thank you, Christina!

Verified Student

See More Reviews

The Learning Environment

From the moment that you enrol in the Medical Writing 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