Microsoft Excel 2007 Advanced Course

Course Description

Knowing how to use the advanced features of Microsoft Excel 2007 opens a completely new experience in using this spreadsheet program. The novice user tends to use Excel 2007 as holding place for report data. You may know how to insert data and move columns around, but rarely go into the deeper functions that Excel 2007 offers. 



This course will teach you the most common advanced features of Microsoft Excel 2007. The goal of this course is to get you familiar with these functions in a safe learning environment. Once it is completed, your familiarity and confidence in using the advanced feature of Excel 2007 will increase, making Excel 2007 a more useful tool for you at work or at home. 

Learning Outcomes

By the end of this course, you will be able to:
•    Open and close Excel
•    Differentiate between worksheets, workbooks, rows, columns, and cells
•    Enter labels and values
•    Set up your page
•    Copy formulas
•    Use absolute referencing appropriately
•    Use basic Excel functions, including SUM, AVERAGE, MAX, and MIN
•    Use Selection Statistics
•    Format text and numbers
•    Change the workbook theme



Course Features

Request Course Information

I am interested in Microsoft Excel 2007 Advanced Course

MODULES
Module One: Getting Started
Module Two: SmartArt
Module Three: Inserting Objects
Module Four: Creating Charts
Module Five: Creating Pivot Tables
Module Six: Working with Pivot Tables
Module Seven: Creating Pivot Charts
Module Eight: Solving Formula Errors
Module Nine: Using What-If Analysis
Module Ten: Managing Your Data
Module Eleven: Grouping and Outlining Data
Module Twelve: Wrapping Up

Subscribe to the Free Plan and take this course for Free for 7 days or Subscribe to any of our premium plans and access all courses

Free - 7 DAYS $0.00
Access over 80 courses Access Videos Access Case Studies - 7 Days Free Access - Access Assessments - No commitment required - START NOW
Premium - 1 DAY $35.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 1 Day Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 - - START NOW
Premium - 7 DAYS $50.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 7 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
MOST POPULAR Premium - 1 MONTH $100.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 31 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
Premium - 3 MONTHS $180.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 93 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
BEST VALUE Premium - 1 YEAR $400.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies Mini-MBA Certificate included 365 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
Testimonials
"I have a first degree in Geology and Mining and an M Phil in Environmental Management. I have worked as an administrator most of my life and needed certification in the field. Thank you for a wonderful training experience in the CIB Advanced Human Resource Certificate Program. Not only have you given me a certificate but most importantly opened my eyes to things I never knew, at my own pace and convenience. Looking forward to acquiring more certifications. #IAmSpreadingTheWord”

Vivian Ozoekwe Assistant General Manager, Havilah Group (Nigeria)

"Thank you CIB for a wonderful and thought provoking course that has made me look at my own business in a new light. This course has helped me improve my knowledge and more importantly how I can apply this in my day to day work environment".

Mohammed A. AlabbadHuman Development & HR Specialist (USA)

"I rate the Chicago Institute of Business Mini-MBA Program 100%. I have learnt lots of things ranging from Project Management to Business Acumen, down to the world of accounting and the Empire of Morals. Thank you for this opportunity".

Olusanya OluwagbemigaZoo Keeper (Nigeria)

“The courses has been very enjoyable, easy to conceptualize. The contents are well placed and the notes are well summarized. The knowledge I gained was very useful in my organization’s Enterprise Resource Planning (ERP) project of which I was a key member. I recommend CIB courses to others across the globe. Looking forward to doing more courses with CIB”.

Geofrey OumaIT Software Developer/ERP Project IT Lead (Kenya)