Excel 2007: Advanced

During this excellent Excel 2007: Advanced course is intended to take your knowledge of Excel to the next level! If you’re an intermediate user of Excel 2007, or if you’ve just updated to Excel 2007, then this course contains all the information you need, and it will help you to get up to speed with all the advanced features and functions of Excel 2007. Learners of this Excel 2007: Advanced course will be taught by an expert instructor who has years of experience and tons of insider tips and tricks to share with you. Be guided through all the more advanced features of Excel 2007, like creating pivot tables and macros, and understand how to streamline your next data analysis project.
 

This Excel 2007: Advanced course will be the ideal solution and the easiest course you will experience. We will offer you the opportunity to study 24/7 wherever you are in the world. This course is opened to anyone with an interest in the topic and give you access to world-class learning led by 1Training International.
 

Learn for less with 1Training discount courses online! You’ll love 1Training’s excellent quality, competitive prices, and first class learner support. With this excellent discount course you can expect professional qualification, which will enable you to enhance your CV in no time, and for less!
 

What skills am I going to get from this course?
Learn how to sort and filter data faster in Excel 2007. You can even sort or filter by colour.
Master pivot tables to summarise a million rows of transactional data into a flexible summary without writing a single formula.
Reduce repetitive tasks to a single mouse click by creating a macro. Plus, find out why most recorded macros don’t work and the one setting to change to allow many recorded macros to work.
See how to use the three new charting ribbon tabs to quickly format a chart or how to use the dialog boxes to coax charts out of Excel that don’t look like Excel charts. You’ll discover how to make charts in your company’s colours with one keystroke.
Create a report for every customer or department with a couple of mouse clicks. Learn five ways to summarise data and when to use each method


Course Duration:
Learners will have 365 days access to their chosen course. The course is self-paced so you decide how fast or slow the training goes. If you need to extend your course access duration, it can be done at any time by extending your subscription.
 

Course Curriculum
Summarizing Data
Working With Pivot Tables
Charting In Excel
Getting Visual
Creating Powerful Formulas
Recording Macros
Tips & Tricks


How will I be assessed?
You will have one assignment.
You only need to pay £19 for assessment when you submit your assignment.


What Certification am I going to receive?
Those who successfully pass this course will be awarded a Excel 2007: Advanced Certificate. Anyone eligible for certification will receive a FREE e-certificate (PDF format), and printed certificate.