Tutorials for Microsoft Excel

설명 Tutorials for Microsoft Excel

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.
What should I know?
Nothing! This course assumes you are a beginner to Excel.
What will you Learn?
1. Tutorial Introduction to Microsoft Excel
2. Tutorial How to Add, Subtract, Multiply, Divide in Excel
3. Tutorial Excel Data Validation, Filters, Grouping
4. Tutorial Introduction to formulas and functions in Excel
5. Tutorial Logical functions (operators) and conditions in Excel
6. Tutorial Visualizing data using charts in Excel
7. Tutorial Case Study: Managing personal finance using Microsoft Excel
8. Tutorial Connecting Microsoft Excel to External Data Sources
9. Tutorial Pivot Tables in Excel: Beginner’s Guide
10. Tutorial Creating Advanced Charts in Excel
11. Tutorial Excel in the cloud: Office 365
12. Tutorial CSV vs Excel (.xls) - What's the Difference?
13. Tutorial Excel VLOOKUP Tutorial for Beginners: Learn with Examples
14. Tutorial Excel ISBLANK Function: Learn with Example
15. Tutorial Sparkline in Excel with EXAMPLES
16. Tutorial SUMIF function in Excel: Learn with EXAMPLE
17. Tutorial Top 40 Microsoft Excel Interview Questions & Answers
18. Tutorial 20 Best Excel Courses
19. Tutorial Introduction to Macros in Excel
20. Tutorial Creating your First Visual Basic for Applications (VBA) in Excel
21. Tutorial VBA Data Types, Variables & Constant
22. Tutorial VBA Arrays
23. Tutorial VBA Excel Form Control & Activex Control
24. Tutorial VBA Arithmetic Operators
25. Tutorial VBA String Operators
26. Tutorial VBA Comparison Operators
27. Tutorial VBA Logical Operators
28. Tutorial Excel VBA Call a Subroutine
29. Tutorial Excel VBA Function Tutorial: Return, Call, Examples
30. Tutorial VBA Range Objects