Wireless Networking

Picture of Wireless Networking
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
  • 3650 Students

An industry expert shows you how wireless networking works, as well as how to plan, deploy, and connect to wireless networks.

Wireless networking is one of the fastest growing segments of the computer industry. Every electronic device seems capable of wireless connections these days: computers, handhelds, cell phones , and even digital cameras are all capable of transmitting without a tether. To many people, those wireless connections are nothing short of technical wizardry. This course will remove the mystery and give you a thorough understanding of this fascinating and lucrative technology.

You'll learn how wireless works, how wireless devices connect to networks, and how to build and connect to your own wireless network. We'll also explore wireless standards, wireless security, satellite Internet and cellular phone technology, as well as the future of wireless.

Becoming knowledgeable about wireless networking is easier than ever. With a helpful instructor who is also a working industry expert, a practical and thoughtful approach to teaching, and an emphasis on giving you a practical, hands-on understanding how wireless works, this course will teach you everything you want to know about the world of wireless connectivity.

Course Revised January 2013

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.

The first Internet connection was made at UCLA in September 1969 with a thick gray cable between two computers. Times sure have changed! Today the Internet serves millions of e-mails and Web pages every few minutes, connecting millions of users from all over the world. And today, wireless networking is the hottest networking technology around. People who use wireless networks can check e-mail from their favorite coffee shop, surf the Internet from their couch, and even get instant messages on their Internet-connected cellular phone. Learning how all those wireless networks operate is as interesting as the Internet itself. In this first lesson, you'll learn about basic network facts and operation, preparing you to expand your knowledge in subsequent lessons.

Did you ever wonder how your radio turns invisible waves into music? Or have you wondered why you can hear bass sounds from farther away than cymbals? Why does a radio station cut out when you go through a mountain tunnel or around a bend? Wireless networks have similar characteristics to radio music transmissions, but there are important differences. In this lesson, I'll explain how wireless networking actually works in simple everyday terms that make it easy to understand. You'll also learn about different methods used to pull computer data out of thin air.

Why do some electronic devices gain widespread popularity while others sit on the shelf? In this lesson, you'll learn how standards in the networking world help drive the adoption of technology. You'll also get a firsthand look at how standards operate in every real-world business, like clothes and batteries and shampoo. In doing so, you'll learn why some wireless networking technologies have flourished while others have failed miserably (early wireless technologies were a flop!). By the end of this lesson, you'll know who makes the standards, how something becomes standardized, and why it's so important. And yes, you'll also see how all this applies to wireless networking standards and gain insight on why wireless networking is so popular today.

If you've considered buying wireless networking equipment, you know that there are lots of choices out there. How do you make sense of it all? Which technology is better? What do all of those extra features mean to you? In this lesson, you'll learn all about wireless network devices, what role each device plays, and how to make sense of it all! By the end of this chapter, you'll know exactly what each wireless networking device is capable of doing and which one is right for you.

In this lesson, we'll investigate short-range wireless network technologies. You'll learn all about Bluetooth (it has nothing to do with dentistry!), Wi-Fi, and the details that make each technology unique. We'll also take a firsthand look at why one is better than the other and where each technology fits into the larger wireless networking picture.

Would you consider a wireless networking technology capable of traveling 90,000 miles a long-range wireless technology? I certainly would! In this lesson, you'll learn which wireless technology can go beyond your house, beyond your neighborhood, and even beyond the atmosphere. You'll also learn the drawbacks of having your data travel into space and back, and about some long-range wireless technologies that might give DSL or cable Internet access a run for their long-range money.

Now that you've learned all about wireless technologies, it's time to put your knowledge to work. In this lesson, you'll learn how to plan a wireless network. After all, once you learn about wireless networking, you'll want to get wireless working in your house or office! In this lesson, I'll walk you through each planning phase, complete with network drawings that depict how a real-life wireless network should be prepared.

In the previous lesson, you planned a network. In this lesson, you'll install a wireless access point (WAP) to get the wireless network up and running. You'll also learn about issues you should address when configuring a wireless network, including interference with neighboring networks and how to extend your network to reach far-off corners of your home or office.

Once you have a wireless network ready for computers to access, you're ready for the next step: connecting wireless devices. In this lesson, you'll learn how to outfit a computer with a wireless network card, how to connect that computer to your wireless network, and how to make sure that wireless network connection is properly configured. By the end of this lesson, you'll be ready to surf the Internet from your couch! Then we'll look at the similarities and differences between Windows and Apple software.

Computers aren't the only devices capable of connecting to wireless networks these days. There are all sorts of wireless devices, like Personal Data Assistants (PDAs), that you can connect. In this lesson, you'll learn how to hook those other devices into the wireless network you created in previous lessons. Then you'll get a chance to explore how Bluetooth networks operate, how they differ from Wi-Fi, and how to go about connecting one Bluetooth device to another.

You can't take the security of your computer (or network) for granted these days. In this lesson, you'll discover how wireless networks provide security for wireless devices that connect to them. You'll also learn how to make your own wireless network secure, ensuring that only the people you want to connect to your wireless network are capable of doing so. You'll also learn how to secure your wireless device, such as a computer or PDA, when you're roaming all those cool (but potentially unsafe) public access areas like coffee shops or downtown wireless districts.

What is the future of wireless networking? Are we there? Is this as cool as it's going to get or are we going to see all sorts of new wireless technologies in the future? In this lesson, I'll give you my thoughts on where the future of wireless networking is headed and what that future might have in store. We'll discuss the future of cellular networks, the future of answering the telephone on the Internet, and how power lines and broadband might be a match made in heaven! Of course, the future is open, but it's fun to make some educated guesses based on history and how networking technology has moved in the past. Be prepared to add you own thoughts to our discussion on the future of networking—this will be an especially interesting and exciting lesson!

David Iseminger

David Iseminger

David Iseminger is a computer and networking expert and an experienced teacher of networking topics. As a student first and expert second, Iseminger knows which teaching approaches are most effective. Iseminger has worked at Microsoft Corporation ... Read more

 Read David Iseminger'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

Enjoyed the course very much. I believe this will help me greatly when I set up my own home wireless network.
Verified Student
Great class! Although I have worked with wireless equipment, it was nice to have some of the "background" information to go along with what I've taught myself. I would definitely recommend this class and the instructor to others.
Verified Student
I enjoyed the class very much. It was very informative and will help me in my job. The lessons were well written and easy to understand. Thank you!!
Verified Student
See More Reviews

The Learning Environment

From the moment that you enrol in the Wireless Networking 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 Wireless Networking:

Discover more online courses

Recently viewed products

Picture of Wireless Networking

Wireless Networking

$599
$389AUD
Save 35%
Online Learning Difficulty Courses | Vibe Learning
 

Learning Difficulties

Students are not created equal. There will always be some that will experience learning difficulties. Learn how to teach students with learning disabilities like autism and ADHD. We also have a Teaching Adult Learners course that will help you trim down your lesson plan and teaching approach so it’s more ideal for your adult students.

Featured
Teaching ESL
In the Classroom
Teaching
Learning Difficulties
Picture of Teaching Students With Autism

Teaching Students With Autism

$599
$389AUD
Save 35%
Picture of Teaching Students With ADHD

Teaching Students With ADHD

$599
$389AUD
Save 35%
Picture of Teaching Students With Learning Disabilities

Teaching Students With Learning Disabilities

$599
$389AUD
Save 35%
Picture of Teaching the Adult Learner

Teaching the Adult Learner

$599
$389AUD
Save 35%
Microsoft Access 2007 Intermediate Online Course | Vibe Learning
 

Microsoft Access 2007 Intermediate

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

Expand your Microsoft Access 2007 skills to build better, more user-friendly Access databases.

Microsoft Access 2007 database developers need the technical knowledge and skills to design databases that use multiple related tables. At the same time, good developers must know how to hide some of these underlying complexities so their completed products are pleasant to use.

In this course, you'll master the tools and techniques required to create user-friendly Access 2007 databases. You'll learn to design one-to-many and many-to-many databases and create queries, forms, and reports to reflect those relationships. You'll find out how to create a switchboard form, change database settings, and use macros to make a database easy and intuitive enough for even a computer novice to use.

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.

A database is a collection of data organized into multiple tables. In this lesson, you'll learn the importance of recognizing one-to-many relationships among the data your database will manage. You'll also discover how to create tables that reflect those relationships and create the first table for a sample working database that we'll build together throughout the course.

Today, we'll dig deeper into database design and the natural one-to-many and many-to-many relationships among your data. You'll discover the importance of primary, foreign, and composite keys, and how to create them in your own databases. You'll get plenty of hands-on practice as we create more tables for our working sample database.

While tables provide a means of storing data, they don't offer much in the way of making a database user-friendly. For that, you need forms. In this lesson, you'll create a form for our working database and learn about the three ways to view forms: Form View, Layout View, and Design View. You'll start learning the tools and techniques the pros use to create attractive forms that are easy to use.

Today's lesson will expand on the skills you learned in Lesson 3. Here you'll learn to move, size, and position multiple controls, choose colors and fonts, and more. You'll also find out how to test your forms and fix common problems. All of these skills will allow you to produce more professional-looking forms that make it easy to work with data in your database.

Today, we'll return to the topics of one-to-many and many-to-many relationships among tables and explore how they relate to forms. You'll build on the skills you've already acquired to create more complex one-to-many forms that reflect the one-to-many relationships among your data. You'll also discover the value of lookup queries and combo boxes, which make it easy for users for select data for fields without having to type it in from memory.

Virtually everything you create in Access is an object, and all objects have properties. Understanding that is key to successful database design and development. In this lesson, you'll discover what that's all about and see how you can use properties to gain more control over every aspect of your database. Along the way, you'll add more enhancements to our working database, making your forms more attractive, usable, and user-friendly.

Sorting and Searching are key ingredients of any database. Today, we'll cover new techniques for sorting form data without the complexities of creating queries. You'll give your form a Search Box that allows users to quickly locate data without the need for complex filters or queries. As an added bonus, you'll learn how to create links in a table for sending e-mail messages with a simple mouse click. And you'll find out some of the secrets of SQL, the Structured Query Language that makes all your queries work the way they do.

Storing text and numbers in a database is easy. But what if you want to also store pictures, Word documents, or other external files? You can do that too, thanks to the Attachment data type. In this lesson, you'll learn all about attachments, including ways to use them in forms.

Forms are great for interacting with data on a computer screen, but sometimes you have to print data on paper, too. That's where reports come in. In today's lesson, you'll learn the tools and techniques for creating and formatting reports. You'll see how to control margins, spacing, page breaks, page orientation, and other important formatting features. And you'll get plenty of hands-on practice in using the report Layout View and Design View.

Today, we'll keep working on the skills you learned in Lesson 9, creating a more complex one-to-many report. You'll see how to use a query to combine data from multiple tables, and you'll learn about calculated controls on reports. You'll also discover some important skills for showing subtotals and totals on your one-to-many forms.

By now, you've created many database objects. Eventually, you may have to hand that database over to less knowledgeable users who won't know what to do with all those tables, queries, forms, and reports. Fortunately, they don't need to. As you'll discover in this lesson, you can hide all the complexities from those users. You'll learn to create a switchboard form that's so easy to use, your database users won't need any database expertise at all!

In this, our final lesson, you'll discover still more tools and techniques for making your database more user-friendly. The star of this lesson will be Access macros, which pre-define actions that you can tie to a button click or other event to simplify things for your database users. You'll also learn how to create custom messages that explain things to users so you don't have to. You'll come away with a fully functional database that's easy enough for even a computer novice to operate.

Alan Simpson

Alan Simpson

With over 100 published books to his name, award-winning author Alan Simpson is widely regarded as a computer and Internet guru. His books have been published throughout the world in over a dozen languages. Alan is a seasoned veteran of the comput... Read more

 Read Alan Simpson'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 Access 2007 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 Access 2007 Intermediate:

Discover more online courses

Recently viewed products

Picture of Microsoft Access 2007 Intermediate

Microsoft Access 2007 Intermediate

$599
$389AUD
Save 35%
Linux Fundamentals Online Course | Vibe Learning
 

Linux Fundamentals

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

Learn how to use the Linux desktop operating system along with the included productivity, multimedia, and Internet software.

In this self-paced online course, you'll master the free Linux desktop system, which can perform all of the functions you currently do with Microsoft Windows or Apple Macintosh.

We'll start with the basics of Linux as we practice using its graphical environment to manipulate files and folders, create user accounts, and set up hardware devices. Then we'll delve into the many free programs that come preinstalled on your Linux system, including the popular OpenOffice.org office productivity software. This exciting application allows you to read and create word documents, spreadsheets, and presentation graphics that are compatible with the Microsoft Office suite. Next, we'll cover the Linux multimedia programs that can play, rip, and burn CDs, as well as play DVDs and video files. We'll also discuss Linux audio-editing tools that enable you to create your own masterpieces.

After that, we'll walk through using your Linux desktop to access the Internet. You'll see how to connect to your ISP and use your ISP to read and send messages with Linux's e-mail software. Finally, we'll explore keeping in touch with friends and family by using common Internet Messaging hosts, as well as how to browse your favorite Web sites with the popular Mozilla Firefox Web browser.

Get ready to discover why so many people think Linux makes their computer easier, cheaper, and more fun!

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.

The Linux desktop operating system is quickly becoming a popular choice for both computer professionals and casual home users. In our first lesson, you'll find out the reasons for its popularity. You'll learn exactly what Linux is and why there are so many different Linux packages available. Then you'll discover how to select the Linux package that's right for you. And finally, we'll walk through installing and running the SimplyMEPIS version 6.5 Linux distribution, examining how to avoid some of the pitfalls associated with Linux.

Now that you have Linux installed on your PC, you have a desktop full of unfamiliar icons and menus. So in this lesson, we'll explore the SimplyMEPIS version 6.5 KDE desktop environment. You'll see how a Linux desktop differs from Microsoft Windows or Apple Macintosh. You'll also learn how to customize your desktop with shortcuts and menus so you can always have the items you need right at your fingertips.

No matter what programs you run on your computer, at some point you'll probably need to work with files. Today's lesson describes how Linux handles files and folders and shows you how to access them using Linux's graphical tools. The way Linux handles files is different from Microsoft Windows, and knowing about these differences is crucial to enjoying your Linux experience.

In this lesson, we'll delve into how Linux manages file security. We'll discuss users and groups, and how you can set permissions to files and folders. You'll use various Linux tools to create new users and groups, and assign them permissions on your Linux desktop. You'll find out how to restrict access to your personal files, and then you'll set up a group to share files among several users.

Today, you'll learn how Linux handles desktop printers. You'll see how to configure Linux to support your printer, and how to use your printer with common Linux applications.

In this lesson, you'll find out how Linux's OpenOffice.org packages can replace all Microsoft Office software products. Not only will you be able to create word processing documents, spreadsheets, and presentation graphic documents, you'll be able to read and modify existing documents that were created using Microsoft Office software.

We live in a multimedia world. No modern computer would be complete without the ability to play audio and video files. So today we'll cover how to use the tools available in Linux to perform all of your multimedia needs. You'll learn how to play CDs and DVDs on your Linux system, how to rip music, and how to burn your own CDs.

This lesson is about using your Linux PC to connect to the Internet. There are many ways to connect to it, and Linux supports them all. If you already have a dial-up or high-speed connection, today you'll find out how to use it with your Linux PC. We'll also walk through the software available on your Linux PC to surf, chat, and transfer files.

To many people, the most important feature of the Internet is e-mail. Today, you'll learn how to connect your Linux PC to your ISP e-mail mailbox. We'll discuss setting up and using Linux's popular KMail package.

In this lesson, we'll dig a little deeper into the Linux world. We're going to explore using command lines. By using system commands, you can manually extract information about your operating system. This is often easier and faster than relying on fancy graphical tools. So we'll go over a few simple commands you can use to examine your file system and see all of the applications that your system is currently running.

Even though Linux distributions generally include lots of software, at some point, most users come across additional software they'd like to have. So today, we'll discuss the various ways you can install software on your Linux PC. We'll cover installing it manually, as well as installing it by using graphical installation programs

In our final lesson, you'll learn some basic system administration techniques to help you when things go awry with your Linux system. We'll talk about backing up data and file archiving. You'll discover how Linux logs system events, and how to examine the log files to help troubleshoot any problems that occur. We'll also examine an interactive tool for watching system resources in real-time mode—seeing how the CPU and memory are performing, and how the programs you're running affect your system's resources.

Richard Blum

Richard Blum

Richard Blum has been an IT industry professional for over 18 years, working mainly as a network and systems administrator. During this time, he has worked with Microsoft, Novell, Unix, and Linux servers, and has created Web sites using a variety ... Read more

 Read Richard Blum'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

Great course! Easy to set up, run and learn. Will recommend to my friends.
Verified Student
I found this to be a very useful introductory course, which gave me a good broad understanding without getting too detailed.
Verified Student
I have been wanting to try Linux on my computer for years, and this course was the catalyst for finally doing it. The step by step process of the class was good, because most installations from a book assume a level of skill that a new Linux user (me) does not have.
Verified Student
See More Reviews

The Learning Environment

From the moment that you enrol in the Linux 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 Linux Fundamentals:

Discover more online courses

Recently viewed products

Picture of Linux Fundamentals

Linux Fundamentals

$599
$389AUD
Save 35%
Microsoft Excel 2007 Fundamentals Online Course | Vibe Learning
 

Microsoft Excel 2007 Fundamentals

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

Work with numbers? You need to know Excel. Learn the secrets of this powerful application.


Work with numbers? Then you need to learn Excel 2007. In this unique self-paced online workshop, you'll discover 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, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyse data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons.

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 cover the art of file management in this lesson, so you'll have no trouble saving, retrieving, printing, and emailing your worksheets, or copying, renaming, and even deleting files. 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, 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 will 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 database in Excel, you'll also learn how to subtotal, sort, and filter.

In this lesson and the next, 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, we'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, the bubble chart, and 3-D charts. You'll find out how to personalize your charts with photographs, text labels, and drawings, and you'll discover the best ways to 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 macros can be used 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 teach Excel not only how to make decisions, but also how to act upon those decisions. We'll use a special function in Excel that allows it to make comparisons and use that comparison 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.

What people are saying about our courses

I think this is the best course I have ever taken.
Verified Student
This class was so much easier to comprehend than any text on the market!
Verified Student
Well Done! Thorough and easy to understand.
Verified Student
See More Reviews

The Learning Environment

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

Discover more online courses

Recently viewed products

Picture of Microsoft Excel 2007 Fundamentals

Microsoft Excel 2007 Fundamentals

$599
$389AUD
Save 35%
Flash CS5 Intermediate Online Course | Vibe Learning
 

Flash CS5 Intermediate

Picture of Flash CS5 Intermediate
Quick Facts
  • Delivery Method Online
  • Professional Certificate
  • 24hrs Suggested Study Time
  • 3 Months Access
  • Tutor Support
  • Study On Any Device
  • 147 Students

Master the use of more advanced Flash techniques including Movie Clip symbols, ActionScript, animation, application programming, and interactivity techniques.

If you have a basic understanding of Flash techniques and you're eager to create more sophisticated and powerful Flash movies and applications, this course will take your Flash skills to the next level.

You'll start by examining the versatile Movie Clip symbol, using it to create Flash movies—animations and special effects—inside other Flash movies. Then you'll delve into ActionScript and learn how to turn your simple SWFs into epic Flash masterpieces. For example, you'll learn how to write a single script that controls hundreds (even thousands) of objects based on user input.

Interactivity that goes beyond simple buttons is crucial to many types of Flash applications. In these lessons, you'll find out how to use ActionScript to develop interactive courses, surveys, quizzes, and tests, using scripts that make decisions, count and keep track of user choices, and tally up and report the results. In addition, you'll learn how to compose and use external ActionScript Class files to extend Flash's capabilities. External ActionScript files allow you to use the same scripts across multiple SWFs, as well as to create SWFs that load and interact with other SWFs—the secret to creating in-depth, multifaceted Flash applications.

While this course is heavy on useful, everyday ActionScript examples, it's not just about programming. You'll also try your hand at advanced Flash animation techniques, learning high-end Motion Editor skills for creating artistic transitions and other animated effects. In addition, you'll discover the secrets for creating intriguing Flash effects with advanced Bone tool features that make your IK bones appear more lifelike and believable, as well as the Deco tool, Spray Brush tool, Layer Masks, Onion Skins, and other techniques for creating professional-grade graphics and animations.

And that's not all! You'll also explore Flash Catalyst, Adobe's new no-scripting, Flash-based application for creating user interfaces and custom Flash components. And you'll finish up with an examination of Adobe AIR, which allows you to create full-blown desktop applications that install and interact with computer operating systems just like traditional computer programs.

In each lesson, you'll find practical, hands-on activities that allow you to practice the skills you're learning. By the time you finish this course, you'll know more than enough to confidently market yourself as a Flash designer.

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.

Flash supports many ways to accomplish essentially the same tasks. Depending on your movie’s purpose and overall design, some techniques are much more suited to specific applications than others. In today’s lesson we’ll look at Movie Clip symbols—a powerful and efficient tool for creating rich content. While learning to create Movie Clips, we’ll go over some of Flash’s basic design and interactivity features, just to make sure we all start the course with a similar set of skills. Get ready to dive headlong into Flash’s intermediate-to-advanced movie design techniques.

A design effect that at first looks complicated is the <em>inner pop-up</em>&mdash;a pop-up that loads and plays external content within the main movie Timeline. However, as with many techniques in Flash, creating inner pop-ups really isn&rsquo;t all that difficult, once you know how to do it. While Flash supports many ways to accomplish the inner pop-up effect, an easy and straightforward method is to load and play an external Flash movie in the UILoader component. With UILoader, you can play any Flash SWF movie from your main movie&rsquo;s Timeline. Designing movies this way helps keep your movies small and reduces download time. It also helps keep your main movie&rsquo;s Timeline simple and easy to manage.

As you tackle more sophisticated Flash movies and applications, the method of laying components out frame-by-frame on the Timeline simply won&rsquo;t cut it. That&rsquo;s when it&rsquo;s time to unleash ActionScript 3.0. In this lesson, that&rsquo;s exactly what we&rsquo;ll do as we take on a more complicated project: building an online products and services portfolio that can showcase hundreds of products. You&rsquo;ll learn to make a project of this magnitude manageable by using ActionScript 3.0 to call objects from the Library dynamically&mdash;without physically placing and positioning each one on the Stage. You&rsquo;ll also learn the power of ActionScript classes and variables. By the end of the lesson, you&rsquo;ll know how to write a single event handler that can call hundreds, even thousands, of external movies to the Stage.

In today&rsquo;s lesson, you&rsquo;ll learn to use one of the most important tools in complex application design, the external ActionScript file. External ActionScript files not only help keep Flash files small and manageable, but they also expand your design options and can even increase your overall productivity. In this lesson, you&rsquo;ll learn to write an external ActionScript class file that, when loaded into a Flash movie, will define a new class object. Then you&rsquo;ll use the new class object to turn the user&rsquo;s mouse cursor into an interactive paint brush.

This lesson takes a straightforward procedure&mdash;loading an external image&mdash;and turns it into a multifunction chain of events. The simple event handler that loads an external file triggers other events that not only format and apply special effects to the new content, but also manipulate other objects on the Stage. First, you&rsquo;ll learn how to format external text files with HTML tags and load the text into Flash. Then, you&rsquo;ll start creating the cascade of events, which includes: using the List component to trigger a function that loads image files; which in turn passes the new content to another function that applies a tween to the images as they display; then the chain continues with simple, powerful If Conditionals that play Movie Clips&mdash;all based on the original data passed by the first event in the chain. To make all this possible, you&rsquo;ll use AS3&rsquo;s indispensable trace(); statement to find out what data your functions and statements are passing among themselves.

<p>When it comes to animation, the Motion Editor is one of Flash's most useful features. It allows you to apply multiple transformations and effects all in the same tween. In this lesson, we'll look closely at the Motion Editor, at all its various options and how they work. Next we'll combine several objects containing Motion Tweens to create a sophisticated transition effect and subsequent animation sequence. Then we'll use Flash's built-in Timer to control when our animation sequences play on the Timeline. The resulting movie will be a rotating, never-ending banner similar to those you see on many of today's more popular Web sites.</p> <p>&nbsp;</p>

<p>This lesson explores some advanced Bone tool techniques. The Bone tool uses an animation technology known as inverse kinematics (IK), which simulates the movement of animate objects, such as people and animals with skeletal structures. IK is also used in the science of robotics. This lesson assumes some basic experience with IK chains and builds on that experience, teaching you how to modify IK chains to make their movements appear more realistic. We also look at making IK chains interactive, so that your users can manipulate them at runtime. Then, we go animating IK chains with ActionScript. The lesson ends with a short demonstration on using Movie Clip symbols with the Spray Brush tool to create special effects, such as twinkling stars or rotating planets.</p> <p>&nbsp;</p>

Flash is by far not just an animation program. Many application developers use it to create sophisticated programs that do all sorts of things, such as building online courses, creating shopping carts for online stores, and just about everything else you can think of. In this lesson, we create a self-scoring quiz, or test, where users answer a series of questions and are then given their scores at the end of the test. To accomplish this, we'll revisit the oh-so-powerful external class file, taking the technique further by creating multiple class files that reference one another to make decisions. You'll learn to use several common and highly useful programming concepts, such as Arrays, Sprites, ints, <em>for</em> loops, Boolean operators, radio button groups, and several others. After completing this lesson, you'll have a basic understanding of creating applications with Flash, as well as an all new understanding of the power of ActionScript.<b></b>

Flash designers typically enjoy creating content in Flash Professional's visually-oriented authoring environment. Many designers do not, however, care for coding, or writing the necessary ActionScript to create interaction. New to the Adobe CS5 suite of applications, Flash Catalyst allows you to create simple, interactive animated interfaces <i>without</i> coding. You design the interaction and animations visually, and Catalyst writes the code for you. This lesson introduces you to Catalyst. We start with an Illustrator artboard, import it into Catalyst, and design a Web interface from the Illustrator content&mdash;a completely visual and automated procedure devoid of manual coding. Since Catalyst creates projects compatible with the Flash Platform's Flex environment, this lesson also provides some insight into working with Flex and Flash Builder.<b></b>

Many Flash applications, such as games and quizzes, call for advanced user interactivity&mdash;providing the user with control of various objects on the Stage. Some movies, for example, call for allowing the user to drag and drop objects, or move them from one spot to another. Other applications call for allowing the user to rotate, resize, and recolor objects. All of this interaction is accomplished with ActionScript. In this lesson, you'll learn to write scripts that turn control over important functions to the user. First, I'll show you a simple set of scripts that allows the user to drag and drop an object on the Stage. Then we'll look at creating sets of buttons that allow users to rotate and resize objects. After that we'll look into allowing users to change not only the color of objects on the Stage, but also the Stage itself&mdash;all with the use of a handy little component known as the Color Picker.

In this lesson, we look at a few of Flash's lesser-known, but highly useful features. First, you'll learn how to create layer masks for producing display effects from objects you draw with Flash's drawing tools. Then, I'll show you how to build an image list&mdash;a list consisting of images&mdash;with the TileList component. Finally, the lesson ends with an in-depth look at Flash's metaphorical equivalent to the days (not all that long ago) when animations were created one drawing at a time on translucent sheets of paper, stacked one on top of the other&mdash;a process known as onion skinning<em>.</em> Flash's Onion Skin feature can help you significantly when developing simple frame-by-frame animations.

A relatively new addition to the Flash platform, Adobe AIR allows you to create stand-alone desktop applications with Flash Professional&mdash;fully functional applications that access and utilize system resources, such as the clipboard, system menus, Minimize, Maximize, and Close buttons, print functions, and many others. AIR applications are platform-neutral, meaning that you or your users can install them on any Windows, Mac OS, or Linux computer. Any existing Flash movie can be published as an AIR application. In this lesson, you learn how to create system-level functionality (unavailable in Flash documents destined for Flash Player), and how to publish and install AIR applications&mdash;yet one more way you can utilize and capitalize on your Flash skills.<b></b>

William Harrel

William Harrel

As owner and operator of The Write Desktop Publisher for more than 20 years, William Harrel has been involved in designing Web and print media on computers since the early days of desktop publishing. In addition to running his own design firm, he ... Read more

 Read William Harrel'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 just want to thank you for a truly enjoyable and informative course!
Verified Student
I just finished taking the Introduction to Flash course with Mr. Harrel, so I can confidently say: you are going to have a blast in this intermediate course!
Verified Student
Thank you so very much, Mr. Harrel!  You opened my world to new animation skills as well as provided a bright light of entrepreneurial hope in this current bleak economic time.  My very best wishes for your happiness and success.
Verified Student
See More Reviews

The Learning Environment

From the moment that you enrol in the Flash CS5 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 Flash CS5 Intermediate:

Discover more online courses

Recently viewed products

Picture of Flash CS5 Intermediate

Flash CS5 Intermediate

$599
$389AUD
Save 35%