- Delivery Method Online
- Professional Certificate
- 24hrs Suggested Study Time
- 8 Weeks Access
- Tutor Support
- Mobile and Tablet Friendly
- 3272 Students
Microsoft Excel 2007 Advanced
What's it all about?
Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you'll see how to maximise Excel's functions and capabilities.
Most organisations rely heavily on Microsoft Excel to consolidate, analyse, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organisation. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making.
Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. You'll become adept at consolidating and importing data from other sources, and you'll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Courses are delivered to you through expertly executed lessons, online instruction and interaction with like-minded students. Our courses are designed to deliver all of the benefits of studying in a classroom whilst giving you the flexibility to study at a time and place to suit your needs. You can access your classroom 24/7 from any device with an internet connection.
New sessions of each course start monthly and last for six weeks. You’ll gain access to two lessons a week (for a total of 12 lessons) helping you pace your learning. There are no set times for you to study, you can log in and out within the 8 week access period at any time and complete the course at your own pace. Your expert tutor will guide and facilitate your course, answering any questions you have and providing guidance and feedback. You’ll complete comprehensive lessons, quizzes and assignments before submitting your final exam at the end of the course to achieve your certificate.
Session start dates are listed below. Has the start date already passed? Don’t worry, you can join a class up to 2 weeks after the start date!
- 18 May
- 15 June
- 13 July
- 17 August
Who's the instructor?
- Lesson 1- Customizing Excel
- Lesson 2- Table Management
- Lesson 3- Data Validation
- Lesson 4- Custom Controls
- Lesson 5- Conditional Formatting
- Lesson 6- Consolidating and Outlining
- Lesson 7- Excel Functions and Nesting
- Lesson 8- Import External Data
- Lesson 9- Data Tables
- Lesson 10- What-If Analysis Tools
- Lesson 11- Advanced PivotTables
- Lesson 12- Analysis ToolPak, Advanced Filter, Array Formulas, and More!
What do others think?
The Learning Environment
From the moment that you enrol in Microsoft Excel 2007 Advanced you will become an integral part of our learning community. You will experience the perks of classroom studies such as chatting by the water cooler or sharing your opinion on a specific task, all in your own home.
Tutor support during your learning is flawless, friendly and encouraging. You will learn from your professional tutor who is not only knowledgeable and highly skilled but is a passionate industry expert. Our ethos is that if you succeed, we succeed. As with any studies, learning can be intense, yet you will soon realise that your hard work and commitment will be both personally and professionally rewarding.
Ready to get started?Enrol Now
Why Choose Vibe Learning?
Learn Your Way
We understand that everyone works at their own pace and no two students are the same. That's why when you study with Vibe Learning we provide you with all the study guidelines, tools and support you need but leave you to set the pace. You are free to complete your assessments when and where you want.
We don't break the bank
With Vibe Learning we believe that education should be accessible to anyone who wants to learn. That's why we offer some of the most competitive prices in the industry. Investing in your future is a smart choice and doesn’t have to break the bank. Whether you choose our money saving upfront prices or flexible payment plans, studying is accessible to you.
You'll get the personal attention you deserve
We are real people, providing real support every step of the way. When you study with Vibe Learning, you'll benefit from learning from professional, knowledgeable and most of all passionate industry experts.
Reap the rewards sooner rather than later
We offer a range of options from short 6 week courses through to extensive 12 month courses. Whatever your personal or professional goals, studying online with Vibe Learning provides a rewarding life changing experience which is well within your reach.
Learn real life skills
We don’t profess to know everything about every industry. That's why, when we write a course we work with industry experts who do know everything! Before delivering a course we make sure that the following boxes have big green ticks in them;
- The course is industry Current
- The course is Relevant to our students
- The course is Engaging and delivers outcomes