arrow_back
Section A - Introduction to MS Excel
1. Launching Excel: Startup Screen and User Interface, Different versions of Excel
2. Microsoft Excel Startup Screen
3. Introduction to Excel Interface, basic shortcuts, etc
4 - Customising the quick access toolbar
5. More information of the Excel interface
6 - Understanding the Structure of Excel
7 - Saving an excel document
8 - Opening an Existing Excel file
9 - 10 Common Ctrl Shortcut keys
11 - Import File - How to save time with Function Shortcuts Udemy final
Introduction to MS Excel - Quiz
Section B - Entering Data and Editing Formulas
12 - Accessing Tools with Alt Keys
13 - Entering Text to Create Spreadsheet Titles V3
14 - Working with Numeric Data in Excel (1)
15 - Creating Drop-Down Menus with Data Validation_2
16 - Entering Date Value in Excel_1
17 - Working with Cell Reference
18 - Creating Basic Formulas in Excel_1
19 - Relative Vs Absolute Cell References in Formulas
20 - Understanding the Order of Operations
21 - Writing Efficient formula with Fixed or Relative References
Entering Data and Editing Formulas (Nine Quiz)
Section C -Modifying an Excel Worksheet
22 - Moving and Copying Data in an Excel Worksheet
23 - Inserting and Deleting Rows and Columns
24 - Changing the Width and Height of Cells
25- Hiding and Unhiding Excel Rows and Columns
26. Renaming and Deleting an Excel Worksheet
27. Moving and Copying an Excel Worksheet
Section D - Printing an Excel Worksheet
29. Changing the Margins, Scaling and Orientation
30. Working with Page Layout View
31. Adding Header and Footer Content
32. Printing a Specific Range of Cells
Section E - Formula and References in Excel
33. How to enter text and edit formulas
34. Common Types of Errors in Excel formulas
35. Absolute Reference
36. Relative Reference
37. Mixed Reference
38. Use of Functions
Section F - How to Insert Shapes and Images into Excel Worksheet
39. Inserting Images
40. Inserting Excel Shapes
41. Formatting Excel Shapes
42. Working with Excel Smart Art
Section G - Creating Charts & Graphs in Excel
43. Visually representing Data
44. Creating Excel Column Chart
45. Working with Excel Chart Ribbon
46. Formatting Charts
47. Scatter Charts
48. Combo Charts
49. Pivot Chart
50. Pie Charts: How to use and Application
51. Adding and Modifying a Data on Excel Chart
Section H - Working with Basic Excel Functions
60. Introduction to Advance Functions in Excel
61. Payment Functions & Loans
63. VLOOKUP Function & GradeBooks
66. IFERROR Function & Dynamic Amortization Tables
67. Calculating A Grade Example
68. How to Collect Data by Google Forms?
Section I - Excel Functions for Professionals
69. Basic Excel Statistical Functions: COUNT, MEDIAN, MODE, PERCENTILE, STDEV, VAR, and more.
70. Extracting Values with SMALL/LARGE & RANK/PERCENTRANK
71. Randomization with RAND() & RANDBETWEEN
72. Row-Level Calculation with SUMPRODUCT
74. Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS
75. Building a Basic Dashboard with COUNTIFS & SUMIFS
76. Counting Duplicates with COUNTIF & SUMPRODUCT
77. Data Profiling with COUNT & SUMPRODUCT
Section J - Statistical Functions Commonly used in Excel
Excel Live Session 1