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
"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 am in the transition phase of my career from a technical to a management role. After studying with CIB I can safely say I am now ready to take on my new role. CIB courses are simplified and straight to the point. Instead of attending physical classes, I now study any time and anywhere. I am so grateful to be part of the institution”.

Mandla MahlanguAnalyst Developer (South Africa)

“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)

"Wow, I am excited to be a part of CIB. Your courses are wonderful and affordable! CIB is helping people get jobs with these certificates. You are light years better. That's why you are music to my ears".

Hassan O.Information Technology and Health Professional (USA)