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
No items in this section -
2. Getting to know Excel
No items in this section -
3. Formatting Worksheet
No items in this section -
4. Date & Time Functions
No items in this section -
5. Mathematical Functions
No items in this section -
6. Text Functions
No items in this section -
7. Database Functions
No items in this section -
8. Data Validation in Excel
No items in this section -
9. Print in Excel
No items in this section -
10. Preparing to Deploy
No items in this section -
11. Trend Analysis and Forecasting using Excel
No items in this section -
12. Special Features
No items in this section -
13. Leasing Project Appraisal & Depreciation
No items in this section -
14. Record, Edit and Run a Macro
No items in this section -
15. Transferring Data from Excel to Other Packages
No items in this section
(1) Comment