Hit Counter


        

Submit your web query:

MICROSOFT EXCEL ADVANCED COURSE:

(Example of SOLVER)

What I Offer:

  1. if statement
  2. and statement
  3. or statement
  4. Nesting of logical functions.
  5. Vlookup
  6. Hlookup
  7. Index
  8. Match
  9. Auto filtering
  10. Formatting
  11. Conditional formatting
  12. Advanced filtering
  13. Using Pivot Tables
  14. Use of Paste special Commands
  • Changing rows into columns
  • Linking between cells/worksheets
  • Special paste options
  1. EXCEL Solver function
  2. Using DATA Validation
  3. Importing web data into excel
  4. Excel And Graphs: presentation and interpretation of data
  5. Estimating demand /forecasting
  6. Regression analysis with Excel
  7. Straight-line relationships  
  8. Building Simple macro
  9. Text to columns- splitting texts to columns
  10. Goal seek
  11. Scenario manager

  •  Course fee: A$200.00

  • Max duration: 08hrs (could be covered in 2day session if requires)

  • Mode: one to one or, one to many

  • Certification: No

  • Competency level: Advanced/High

  • For Booking: admin@syedkollol.com

name
email
subject
your address

  


 

all right reserved
2011-2012 
www.syedkollol.com