- Delivery Method Online
- Professional Certificate
- 24hrs Suggested Study Time
- 3 Months Access
- Tutor Support
- Study On Any Device
- 11174 Students
Microsoft Excel 2007 Intermediate
Quick Facts
Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity.
Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical, hands-on course, you'll learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques.
You'll see how Excel 2007 can give you further insight into your valuable data. And by learning how to create macros that eliminate repetitive tasks, you'll earn your coworkers admiration and gratitude. With your macro knowledge, you'll be able to manipulate data with the push of a button.
You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by learning how to use Excel's VLOOKUP, INDEX & MATCH, and other time-saving functions.
So get ready for action-packed learning that will take your Excel skills to the next level!
Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.
This course has a 3 month duration. You'll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate. Courses must be completed within the 3 month access period.
In our first lesson, you'll discover why Excel 2007 is such a powerful and user-friendly charting tool. To you, a workbook's numbers might tell an interesting story. But to others, that story might not be quite so obvious—they might just see plain old numbers. So today, you'll find out how to choose the right chart for telling your story, and then how to create, format, and edit your chart to help others clearly visualize that story.
There are so many great charting features and enhancements in Excel 2007, there's no way we could cover all of them in a single lesson. So today, we'll continue exploring Excel's charting options—this time looking at the lesser-known options that are available to you. Even though they aren't well known, these options can add tremendous value to your worksheets in the right situations. We'll walk through a few of them step-by-step so you'll see the value for yourself.
Networking Intermediate
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
- 5868 Students
Gain practical experience in a hot new career field. Topics include VPNs, security, and Internet connectivity.
Learn real-world applications for the concepts you learned in Introduction to Networking. Continue to build your knowledge of networks and networking, with detailed treatments of TCP/IP, how switches and routers operate, DNS, and more. You'll gain a full understanding of almost every aspect of networking technology, including hot topics such as virtual private networks, security, Internet connectivity, and cloud computing. Completion of this course and its prerequisite should serve as a springboard for a career in computer networking or training for CCNA Certification.
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.
Working with data in Excel can be quite easy—and sometimes even fun—when you know about the extra tools that are available once you have your data arranged in a table format. One of these great tools is the Auto Filter command. In today's lesson, you'll learn how to use Auto Filter to limit your table information to just the records you want. Not only does Auto Filter allow for finding exact matches, but it can also filter and sort based on cell shading or font color. How great is that?
Normally, you'll use your Excel workbooks as a place to enter formulas and get answers. But what if the formula isn't returning the answer you want? If you know what you want but you just don't know what formula will get you there, then Excel's Goal Seek is exactly what you need. This tool will help you avoid the trial-and-error approach that most Excel users go through to get to the right answer. In this lesson, we'll walk through multiple examples together, exploring several ways to apply this great feature.
Today, you'll learn how to use one of the best features of Excel: the PivotTable. If you've heard about PivotTables before, then you know what I mean. There's no greater what-if analysis tool to summarize, reorganize, and report data. When we practice creating a PivotTable, you'll discover how "pivoting" your data helps you gain valuable insights by seeing the same information from a different perspective. This is a lesson you won't want to miss!
Just like charting, Excel's PivotTables are too big a topic to fit into one lesson. So today, we'll take PivotTables to the next level by taking a tour through some of Excel's more advanced techniques. You'll learn how quick and easy it is to group your data to give your PivotTable even more power. Then you'll find out how a PivotTable can serve as your source and inspiration for some really nice charts, specifically, the PivotChart.
Have you ever worked with a financial model in Excel and wondered how you could speculate different outcomes by changing different input amounts? The Excel Solver can do just that. In this lesson, you'll learn how to use Solver to solve a complex problem based on the criteria and constraints we provide it. If you liked the Goal Seek lesson, then this Solver lesson is going to knock your socks off.
Back by popular demand, it's Solver! Today, we'll continue with our topic from the prior lesson, but this time, we'll throw in a little bit of a wrinkle. Instead of me guiding you step-by-step through a practical, hands-on experience with the Solver, I'm only going to guide you to a point because I want to help you master a tool that's as complex as it is powerful. By the end of this lesson, and mostly on your own, you'll have successfully mastered using Solver!
Today's topic is a student (and instructor) favorite. In this lesson, you'll find out how to use macros to turn boring, repetitive, time-consuming tasks into automated Excel functions. Tired of doing the same formatting on the same report month after month? Here's your chance to see how to record a macro that performs that time-consuming task in seconds with just one swift click of a button! How will you spend all the extra time that this lesson will save you?
If you've used Excel for a while, you know there are hundreds of functions at your disposal. We're going to spend the last three lessons of this course going over exactly how and why you'd use them. We'll start today by going through a quick overview of all the categories of functions and the different methods you can use to create them. Then, later in the lesson, we'll ease into creating various functions using some from the Text category.
Next to learning how to create macros, most students want to learn as much as they can about Excel functions. In today's lesson, we'll dig a little deeper into using some of the slightly more complex functions that you'll find in the Math & Trig category. Specifically, we'll look at two of my favorites, the SUMIF and COUNTIF functions, and discuss how to use one of Excel 2007's new functions, SUMIFS. If one of your objectives in taking this course is to learn more about functions, you're in for a treat!
In our first lesson, you'll learn about the concept of a network stack. After a succinct review of essential network and networking terms, we'll compare the theoretical structure of a network stack—commonly called the OSI model—to real-world networking. We'll then trace how data travels through the computer for transmission on the network.
We'll pick up right where the last lesson left off today when we begin our discussion on how a unit of computer data—called a packet—gets from one computer to another. You'll learn all about how packets are formed, how packets are sometimes chopped then reassembled to go across WAN links, and how the receiving computer handles packets upon arrival. You'll also learn why the network's most important device is the router.
Today's lesson is dedicated to helping you understand how routers operate. You'll learn all about how routers create a virtual map of the entire Internet. You'll also see how routers connect to different network types—an Ethernet segment and an ATM link, for example—transmit data across those different mediums. Then we'll discuss why routers have their own special languages, called routing protocols.
Today you'll learn the language of routers: routing protocols. You'll learn why some routing protocols are appropriate for smaller networks, and why very large networks require specialized routing protocols. You'll also learn about the two most revealing measurements of a router's capability: latency and packets per second (pps).
You've heard of TCP/IP, but its details may seem mysterious. After you complete this lesson, those mysteries will be banished forever! You'll learn about IP addressing, the four primary IP address classes, and all about the various protocols that come packaged within TCP/IP. Prepare to demystify TCP/IP!
Security is on everyone's mind these days, so in this lesson, you'll learn the fundamentals of how computers enforce security. You'll learn what a security descriptor is and how it can allow some people to only read a document, while others can delete or modify the document as much as they like. You'll also learn the difference between a security implementation and security protocols. Finally, you'll find out how security operates in a Windows environment, including exactly what happens during log on, authentication, and authorization.
In today's lesson, we'll explore encryption, a method used to secure data for transmission over the Internet. You'll learn about various encryption schemes, and you'll get firsthand knowledge of how a chunk of data gets encrypted, how it gets decrypted on the receiving end, and how this process can be secure. You'll also learn how Secure Sockets Layer (SSL) makes it safe for you to order merchandise online, and how SSL ensures that your connection to the seller's Web site is secure.
The Internet is a great public network, but what if you need it for private communication? For example, what if a salesman needs to make a private connection to her company's network to check on special bulk pricing? In today's lesson, you'll learn how you can create a virtual private network out of your Internet connection. You'll get a hands-on view of how these private connections are made, and why they're so useful.
The Internet, and almost every other network today, uses Domain Name System (DNS) to translate names we understand (like www addresses) into IP addresses that computers can use. It's important to understand how this system works, so in this chapter you'll learn details about how DNS operates. You'll learn how resource records are the building blocks of DNS, and how DNS scales to the entire Internet by being broken into zones.
We'll expand on our discussion of DNS in this lesson. Here you'll learn about t
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.
Verified Student
The Learning Environment
From the moment that you enrol in the Networking 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.
Ready to get started?
Enrol NowOur 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 2812 51.09375 61.089844 54.738281 59.832031 C 56.460938 59.234375 57.722656 57.777344 57.457031 55.992188 C 56.261719 48.90625 51.425781 40.894531 44.867188 38.378906 Z M 44.867188 38.378906 " fill-opacity="1" fill-rule="nonzero" />
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 Intermediate:
