Preview [Live Classes] Microsoft Excel Beginner to Advanced Online Course

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

Preview - [Live Classes] Microsoft Excel Beginner to Advanced Online Course - English