×

Create CV Books Summaries Online Courses Blog Communities

Login

Sign up

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

Excel from Beginner to Advanced

Computer Softwares

2022-03-05

Register in this Course

Lessons List

1 Launching Excel

2 Microsoft Excel Startup Screen

3 Introduction to the Excel Interface

4 Customizing the Excel Quick Access Toolbar

5 More on the Excel Interface

6 Entering Text to Create Spreadsheet Titles

7 Working with Numeric Data in Excel

8 Entering Date Values in Excel

9 Working with Cell References

10 Creating Basic Formulas in Excel

11 Relative Versus Absolute Cell References in Formulas

12 Understanding the Order of Operation DOWNLOAD EXERCISE FILE

13 The structure of an Excel Function

14 Working with the SUM Function

15 Working with the MIN and MAX Functions

16 Working with the AVERAGE Function

17 Working with the COUNT Function

18 Adjacent Cells Error in Excel Calculations

19 Using the AutoSum Command

20 Excel s AutoSum Shortcut Key

21 Using the AutoFill Command to Copy Formulas

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 an Excel Worksheet

27 Deleting an Excel Worksheet

28 Moving and Copying an Excel Worksheet

29 Working with Font Formatting Commands

30 Changing the Background Color of a Cell

31 Adding Borders to Cells

32 Formatting Data as Currency Values

33 Formatting Percentages

34 Using Excel s Format Painter

35 Creating Styles to Format Data

36 Merging and Centering Cells

37 Using Conditional Formatting

38 Inserting Images

39 Inserting Excel Shapes

40 Formatting Excel Shapes

41 Working with Excel SmartArt

42 Creating an Excel Column Chart

43 Working with the Excel Chart Ribbon

44 Adding and Modifying Data on an Excel Chart

45 Formatting an Excel Chart

46 Moving a Chart to another Worksheet

47 Working with Excel Pie Charts

48 Viewing your Document in Print Preview

49 Changing the Margins Scaling and Orientation

50 Working with Page Layout View

51 Adding Header and Footer Content

52 Printing a Specific Range of Cells

53 Intro to Excel Templates

54 Opening an Existing Template

55 Creating a Custom Template

56 Congratulations

57 Understanding Excel List Structure

58 Sorting a List Using Single Level Sort

59 Sorting a List Using Multi Level Sorts

60 Using Custom Sorts in an Excel List

61 Filter an Excel List Using the AutoFilter Tool

62 Creating Subtotals in a List

63 Format a List as a Table

64 Using Conditional Formatting to Find Duplicates

65 Removing Duplicates

66 Excel Function DSUM

67 Excel Function DAVERAGE

68 Excel Function DCOUNT

69 Excel Function SUBTOTAL

70 Understanding the Need for Data Validation

71 Creating a Validation List

72 Adding a Custom Validation Error

73 Dynamic Formulas by Using Validation Techniques

74 Importing Data from Text Files

75 Importing Data from Microsoft Access

76 Exporting Data to a Text File

77 Understanding Excel PivotTables

78 Creating an Excel PivotTable

79 Modifying Excel PivotTable Calculations

80 Grouping PivotTable Data

81 Formatting PivotTable Data

82 Drilling Down into PivotTable Data

83 Creating PivotCharts

84 Filtering PivotTable Data

85 Filtering with the Slicer Tool

86 Why PowerPivot

87 Activating the Excel PowerPivot AddIn

88 Creating Data Models with PowerPivot

89 Creating PivotTables based on Data Models

90 PowerPivot Calculated Fields

91 PowerPivot KPIs

92 Using the Freeze Panes Tool

93 Grouping Data Columns andor Rows

94 Print Options for Large Sets of Data

95 Linking Worksheets 3D Formulas

96 Consolidating Data from Multiple Worksheets

97 Congratulations

98 Working with Excel Name Ranges

99 Using Excel s IF Function

100 Nesting Functions

101 Using Excel s COUNTIF Function

102 Using Excel s SUMIF Function

103 Using Excel s IFERROR Function

104 Using Excel s VLOOKUP Function

105 Using Excel s HLOOKUP Function

106 Using Excel s INDEX and MATCH Functions

107 Using Excel s LEFT RIGHT and MID Functions

108 Using Excel s LEN Function

109 Using Excel s SEARCH Function

110 Using Excel s CONCATENATE Function

111 Tracing Precendents in Excel Formulas

112 Tracing Dependents in Excel Formulas

113 Working with the Watch Window

114 Showing Formulas

115 Protecting Specific Cells in a Worksheet

116 Protecting the Structure of a Workbook

117 Adding a Workbook Password

118 Working with Excel s Goal Seek Tool

119 Working with Excel s Solver Tool

120 Building Effective Data Tables in Excel

121 Creating Scenarios in Excel

122 Understanding Excel Macros

123 Activating the Developer Tab in Excel

124 Creating a Macro with the Macro Recorder

125 Editing a Macro with VBA

126 Creating Buttons to Run Macros

127 Congratulations on Competing the Microsoft Excel 103

We Appreciate Your Feedback

Excellent		0 Reviews
Good		-1 Reviews
medium		0 Reviews
Acceptable		0 Reviews
Not Good		2 Reviews

4.3

24 Reviews

Muhammad Bilal

Video unavailable<br /> This video is no longer available because the YouTube account associated with this video has been terminated. Please change this course Mind Luster 2024-09-30

Shehbaz Iqbal

Video unavailable<br /> This video is no longer available because the YouTube account associated with this video has been terminated. 2024-07-06

GHAWATE KOMAL ASHOK

Everything good 2023-08-17

Marcel Asiegbu

I must say that I'm super excited to have taken this course. Thank you for the opportunity MindLuster and thank you Kyle, you're an amazing teacher. 2023-07-04

Indra Kumar mahato

Excellent 2023-06-28

Saima Hamid Deshmukh

Excellent 2023-06-27

Riya Shrivastav

Excellent 2023-06-20

Faith Nonhlanhla Maingene

I REALLY ENJOYED IT 2023-06-13

Noorhat Khan

Fantastic Sir explained very well thank u Sir 2023-05-06

Ankit Kumar

awesome and good experience 2023-03-23

Daniyar

everything good 2023-03-15

Adepoju Suliyat Folasade

Wow. This's Amazing. Can't stop myself from clicking the next lessons all days. I'm already at lesson 55 in just three days. The tutor makes Excel learning really easy and fun! 2023-03-06

Show More Reviews

Another Computer Softwares Courses

Excel Power Query

Excel Power Query

Excel VBA

Excel Dashboard

Excel Dashboard

Excel Course Basic to Advanced

Excel Course Basic to Advanced

Excel Functions

Excel Functions

Excel Charting

Microsoft Access

Microsoft Access

Microsoft PowerPoint

Microsoft PowerPoint

Show More Course for Computer Softwares

For this, you need to be through with your MS Excel concepts and also practice... The duration to complete any kind, of course, depends on your grasping power and the ability to learn the concepts quickly. Having said that, it usually takes about three to four weeks to learn the topics in Advanced excel.

Trends

Recent