| HOT TOPICS: | |
|---|---|
| Shortcuts | Formulas |
| FAQ | Excel Hacks |
| Downloads | Troubleshooting |
| Testimonials | More Courses.. |
Here we will learn about Function and its uses. We will also learn types of function and their syntax to write. Also learn function library and how to use it.
Here we learn that what is formulas in Excel and how to Create and Editing these formulas for different operations in Excels.
| Beginners: | |
|---|---|
| Introduction | Basic Excel |
| Excel interface | Data entry |
| cells & Rows | More... |
| Intermediate: | |
|---|---|
| Worksheets & Workbooks | Array |
| Ranges & References | Index-Match |
| Built-in Functions | More... |
| Advanced: | |
|---|---|
| Macros | VBA |
| Pivot tables | Data Mining |
| Forecasting & prediction | More... |
| Data Analytics: | |
|---|---|
| Power Query | Charts & graphs |
| Data validation | Conditional formatting |
| Data Visualization | More... |
| Formulas: | |
|---|---|
| V/H/X-Lookup | Index/Match |
| Operators | Date & time |
| IF/IFS/IFERROR | More... |
More
