7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
LOGIN
HOME / COURSE / MICROSOFT OFFICE / EXCEL / VIDEO COURSE / FREE COURSE / MICROSOFT OFFICE 2007 EXCEL ADVANCED
Microsoft O ce 2007 Excel Advanced ( 7 REVIEWS ) 557 STUDENTS
HOME
CURRICULUM
REVIEWS
Welcome back! Can I help you with anything?
Description: This Microsoft O ce 2007 Excel Advanced builds on knowledge gained in the Introduction and Intermediate courses. In Advanced Microsoft O ce Excel 2007, you will explore the many data analysis tools available in Excel, such as formula auditing, goal seek, Scenario Manager and subtotals. Additionally, during this course you will use advanced functions, learn how to apply conditional formatting, lter and manage your data lists, create and https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
1/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
manipulate PivotTables and PivotCharts and record basic macros. You will also learn to use key advanced nancial, logical, text, statistical and math, and lookup functions, audit formulas for errors, analyze data using subtotals, goal seek and the scenario manager, use custom and conditional formatting, manage data with tables, ltering and sorting, create, edit and format PivotTables and PivotCharts, import and export date to and from a workbook, create and use macros. So, by taking this course you will have a complete understanding of the higher functions of Excel.
Who is this Course for? Microsoft O ce 2007 Excel Advanced is perfect for anyone trying to learn potential professional skills. As there is no experience and quali cation required for this course, it is available for all students from any academic background.
Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the quali cation. Good understanding of English language, numeracy and ICT are required to attend this course.
Assessment: This course does not involve any MCQ exams. Students need to answer 3 assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Each answer needs to be 200 words (1 Page). Once the answers are submitted, the tutor will check and assess the work. Advanced Functions
Lookups and Data Tables
Advanced List Management
PivotTables and PivotCharts
Welcome back! Can I help you with anything?
Exporting and Importing
Analytical Options
Macros and Custom Functions
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
2/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Conditional Formatting and SmartArt
Course Certification
4.9 7 ratings
5 STARS
0
4 STARS
0
3 STARS
0
2 STARS
0
1 STARS
0
NO REVIEWS FOUND FOR THIS COURSE.
Welcome back! Can I help you with anything?
OTHER STUDENTS ALSO BOUGHT
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
3/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Old Age Psychology
£449.00 £49.00
385
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
4/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Advanced Microsoft Data Analysis
£489.00 £89.00
577
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
5/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Data Analysis In Excel
£461.00 £29.00
724
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
6/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Microsoft Office 2007 PowerPoint Advanced
FREE
881
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
7/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
MS Azure - Deploying Websites
£489.00 £59.00
453
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
8/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Microsoft Azure Automation and Log Anayltics
£489.00 £59.00 535
TAKE THIS COURSE
FREE
1 YEAR ADVANCED COURSE CERTIFICATE NUMBER OF UNITS NUMBER OF QUIZZES https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
Welcome back! Can I help you with anything?
26 0 9/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
1 HOUR, 11 MINUTES
Gift thi s course
557 STUDENTS ENROLLED
VIDEO COURSES Adult Psychology Course
( 7 REVIEWS )
388 STUDENTS
Advanced Diploma in Psychology Level 4
Welcome back! Can I help you with anything?
( 8 REVIEWS )
744 STUDENTS
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
10/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
An Introduction to PCs Using Windows 8
( 7 REVIEWS )
586 STUDENTS
An Introduction to Windows Vista for End Users
( 8 REVIEWS )
459 STUDENTS
Animation Designing Certi cate Course
( 7 REVIEWS )
520 STUDENTS
BEST RATED COURSE Deprivation of Liberty Care Training (DOLS)
( 7 REVIEWS )
Welcome back! Can I help you with anything? 373 STUDENTS
Adobe InDesign CC Advanced
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
11/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
( 9 REVIEWS )
454 STUDENTS
Worm Farming Course
( 1 REVIEWS )
368 STUDENTS
VIDEO COURSES Adult Psychology Course BY ADMIN
Advanced Diploma in Psychology Level 4 BY ANDREW JONES
An Introduction to PCs Using Windows 8 BY NEAL SMITH
Welcome back! Can I help you with anything?
An Introduction to Windows Vista for End Users BY COURSE GATE
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
12/13
7/22/2019
Microsoft Office 2007 Excel Advanced - Course Gate
Animation Designing Certi cate Course BY CAMERON DALLPORT
CERTIFICATE CODE
Enter Certi cate Code
VALID ATE
IMPORTANT LINKS
About Blog Terms & Conditions Privacy Policy Contact
© COURSE GATE EDUKITE LTD, REG NO: 11378092
Welcome back! Can I help you with anything?
https://coursegate.co.uk/course/microsoft-office-2007-excel-advanced/
13/13