Online Certificate in Microsoft Excel

Looking for an Excel course for beginners to experts? This online course has something for everyone, covering beginner, intermediate and advanced lessons in Excel.

In 15 engaging lessons you will learn basic techniques including how to use financial,engineering,math, statistical,Database,logic and text functions, organize data by sorting and filtering, effectively present your data in several chart formats and more. You will also learn advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

After successfully completing this course you will be able to:

  • Distinguish different spreadsheet applications
  • Discover the different features of a spreadsheet application
  • Apply different spreadsheet functions, formulas, to more efficiently manipulate spreadsheet data
  • Prepare different types of spreadsheets according to various business requirements
  • Analyze and interpret data using advance data tools in spreadsheets
  • Design worksheets for important financial applications such as budgeting, Leasing, Depreciation and Project Appraisal
  • Apply macros for different contexts
  • 1. What are the types of spreadsheet 0/0

    No items in this section
  • 2. Getting to know Excel 0/0

    No items in this section
  • 3. Formatting Worksheet 0/0

    No items in this section
  • 4. Date & Time Functions 0/0

    No items in this section
  • 5. Mathematical Functions 0/0

    No items in this section
  • 6. Text Functions 0/0

    No items in this section
  • 7. Database Functions 0/0

    No items in this section
  • 8. Data Validation in Excel 0/0

    No items in this section
  • 9. Print in Excel 0/0

    No items in this section
  • 10. Preparing to Deploy 0/0

    No items in this section
  • 11. Trend Analysis and Forecasting using Excel 0/0

    No items in this section
  • 12. Special Features 0/0

    No items in this section
  • 13. Leasing Project Appraisal & Depreciation 0/0

    No items in this section
  • 14. Record, Edit and Run a Macro 0/0

    No items in this section
  • 15. Transferring Data from Excel to Other Packages 0/0

    No items in this section

Leave a Reply

Your email address will not be published. Required fields are marked *