Administrative Microsoft® Excel

Administrative Microsoft® Excel will demonstrate to the power user how to edit spreadsheets for both individual and group use. Featured topics included validating data, applying various levels of protection, sharing workbooks for collaboration, and working with formula links. The user will also be exposed to various auditing and analysis tools including features such as Goal Seek, Solver, creating Scenarios, and using the FORECAST function.

Objective: Upon completion of this course the Excel power user will be able to modify worksheet files so that multiple users can both enter and access data without disrupting delicate workbook structure. Additionally, they will be exposed worksheet auditing and use various analysis tools.

  • Data Validation
  • Protection
    1. File Access
    2. Write Reservation
    3. Sheet Protection
    4. Cell-level Protection
    5. Workbook Protection
  • Sharing Workbooks
  • Linking
    1. Internal worksheet links
    2. External workbook links
  • Consolidating data
  • Formula Auditing
  • Data Scenarios and Forecasting
    1. Using Goal Seek
    2. Using Solver
    3. The FORECAST Function

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

Course Information
  • Course Level:Advanced
  • Prerequisite:Microsoft® Excel Basic working knowledge
  • Credit:2 CPE Hours
  • Fee:$99
  • Length:2 hours
  • Delivery:Virtual Instructor-Led Live/Group Internet-Based
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelIntermediate
  • Advanced PreparationDownload and install class files a minimum of 3 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to info@knowledgesourceinc.com or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses