About Course
Mastering Basic to Advanced Excel: With AI takes you from the fundamentals to expert-level skills in Excel, integrating AI tools for smarter data management. Perfect for boosting efficiency, this course ensures you’re equipped with cutting-edge techniques and practical knowledge to excel in any data-driven environment
Author – By Ankush Kumar
Course Content
1. How to Open Excel and Introduction to Excel Sheet
-
Click to Start
08:18
2. How to Enter Data in an Excel Sheet
3. Using Drag to Fill Data with Custom Lists in Excel
4. Creating and Formatting a Timetable in Excel
5. Basic Calculations: Addition, Subtraction, Multiplication, Division
6. Calculating Percentages in Excel
7. Automated Invoice Creation with Formulas
8. Using SUM, MIN, MAX, TODAY, and NOW Formulas
9. Text Functions: UPPER, LOWER, PROPER, and LEN
10. Using the CONCATENATE Function
11. Text Extraction: LEFT, RIGHT, and MID Functions
12. Counting Data: COUNT, COUNTA, and COUNTBLANK Functions
13. Using AVERAGE, POWER, SQRT, and RANDBETWEEN Functions
14. Using VLOOKUP for Various Scenarios
15. Understanding the IF Function in Excel
16. Basic Filtering and Conditional Formatting in Excel
17. Features of the Home Tab in Excel
18. Data Validation in Excel
19. Page Layout and Print Setup in Excel
20. Using Charts, Shapes, Hyperlinks, and Text Boxes in Excel
21. Using Nested IF Functions in Excel
22. Using IF with AND/OR Functions in Excel
23. Using MATCH and INDEX Functions in Excel
24. Using the PMT Function and Data Table in Excel
25. Cell Range Protection and Passwords in Excel
26. Types of Cell References in Excel
27. Using Goal Seek and Scenario Manager in Excel
28. Using Advanced Filter in Excel
29. Introduction to Pivot Tables in Excel
30. Pivot Tables: Advanced Techniques
31. Custom Number Formatting in Excel
32. Using SUMPRODUCT and Sparklines in Excel
33. Dynamic Data Validation in Excel
34. Basic Date Functions in Excel
35. Using DATEDIF Function in Excel
36. Calculation Functions in Excel
37. Using Database Functions in Excel
38. Advanced Data Validation in Excel
39. Using Paste Special: Complete Guide
40. Using Text Formulas in Excel
41. Using RANK, LARGE, and SMALL Functions in Excel
42. Using Financial Functions in Excel
43. Using Rounding Functions in Excel
44. Using Information Functions in Excel
45. Complete Guide to Freezing Panes in Excel
46. Using the FILTER Formula in Excel
47. Introduction to Macros in Excel
48. Using HLOOKUP in Excel
49. Exploring the Review Tab in Excel
50. Exploring the View Tab in Excel
51. Using SpellNumber with AI in Excel
52. Highlighting Active Row and Column with Advanced Conditional Formatting
53. Creating a To-Do List in Excel with Time Stamp
54. Rearranging Raw Data in Excel
55. Advanced Conditional Formatting in Excel
56. Using AVERAGEIF, AVERAGEIFS, MINIFS, MAXIFS, and IFS Functions in Excel
57. Using COUNTIF and SUMIF Functions in Excel
58. COUNTIFS and SUMIFS: Advanced Techniques
59. Text Functions in Excel
60. Using SUBTOTAL and Data Consolidation in Excel
61. Using Lookup Functions in Excel
62. Using Logical Functions in Excel
63. Exploring the Formula Tab in Excel
64. Using Flash Fill in Excel
65. Excel with AI: Enhancing Your Data Analysis
66. Data Consolidation and Advanced Sorting in Excel
67. Exploring the Data Tab in Excel
68. Date Functions: Part 1 in Excel
69. Date Functions: Part 2 in Excel
70. Creating Dependent Data Validation Lists in Excel
71. Exploring New Functions in Excel 365
72. Complete Tutorial on XLOOKUP in Excel
73. XLOOKUP with 10 Examples in Excel
Earn a certificate
Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.
Student Ratings & Reviews
No Review Yet
