Advanced excel online training

Advanced Excel Online Training

(Advanced Excel Online Training- Become a professional with our self paced online course)

Categories of functions covered in this course:

  1. Basic Excel Calculation & Function
  2. Excel Short Cuts
  3. Conditional Functions
  4. Text and Lookup Function
  5. Finance, Database Functions
  6. Maths & Stats
  7. Date & Time
  8. What IF analysis
  9. Array Functions
  10. Additional Features in 2010
  11. Spinner, Scroll Bar, List Box, Combo Box

Tools and Commands covered in this course:

  1. Conditional Formatting
  2. Paste Special
  3. Go To Special, Sorting, Adv Filter
  4. Error Tracking, Evaluate Formula
  5. Name Manager, Import from web
  6. Text to Column, Data Validation
  7. Consolidate, Goal Seek, SubTotal
  8. What IF Analysis, Scenario Analysis
  9. Workbook & WorkSheet Protection
  10. Pivot tables, Analysis Tool Pack

 

261 total views, 2 views today

Related Post

Welcome to IbInstitute!