Microsoft Excel 2010 Expert Course

Course Description

You will learn how to use the more in-​depth fea­tures of Excel 2010. This course is designed to for the advanced users of Excel 2010. This course incor­po­rates a hands-​on approach to learn­ing. They will get a chance to prac­tice some of the advanced fea­tures right on a com­puter.

Excel is the world’s pre­mier spread­sheet soft­ware. You can use Excel to ana­lyze num­bers, keep track of data, and graph­i­cally rep­re­sent your infor­ma­tion. With Excel 2010, you can man­age more data than ever, with increased work­sheet and work­book sizes. Excel also makes your job eas­ier by pro­vid­ing an easy to use inter­face, and an array of pow­er­ful tools to help you turn your data into usable infor­ma­tion — and bet­ter infor­ma­tion leads to bet­ter deci­sion making!

Learning Outcomes

By the end of this course, you will be able to:
  • Mark Work­book as Final
  • Encrypt with a Pass­word and Restrict Permissions
  • Pro­tect the Cur­rent Sheet or the Work­book Structure
  • Add a Dig­i­tal Signature
  • Man­age Versions
  • Share Work­books
  • Edit a Shared Workbook
  • Track Changes
  • Set Cal­cu­la­tion Options
  • Use Array Formulas
  • Change a Macro
  • Use a data form
  • Use Trend Lines
  • Add a Sec­ondary Axis
  • Use Chart Templates
  • Work with Piv­ot­Table Tools

Course Features

Request Course Information

I am interested in Microsoft Excel 2010 Expert Course

MODULES
Module One: Getting Started
Module Two: Working with Permissions and Options
Module Three: Sharing Workbooks
Module Four: Performing Advanced Formula and Function Tasks
Module Five: Working with Array Formulas
Module Six: Working with Functions
Module Seven: Working with Macros
Module Eight: Working with Forms
Module Nine: Applying Advanced Chart Features
Module Ten: Working with PivotTables and PivotCharts
Module Eleven: Using the Automated Analysis Tools Add-In
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)

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