×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

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

78 Creating an Excel PivotTable

Share your inquiries now with community members Click Here
Previous Lesson Next Lesson
Sign Up and Get Free Certificate
Sign up Now

Lessons List | 127 Lesson
1 Launching Excel
00:01:42

1 Launching Excel
2 Microsoft Excel Startup Screen
00:03:16

2 Microsoft Excel Startup Screen
3 Introduction to the Excel Interface
00:07:11

3 Introduction to the Excel Interface
4 Customizing the Excel Quick Access Toolbar
00:02:57

4 Customizing the Excel Quick Access Toolbar
5 More on the Excel Interface
00:03:35

5 More on the Excel Interface
6 Entering Text to Create Spreadsheet Titles
00:08:16

6 Entering Text to Create Spreadsheet Titles
7 Working with Numeric Data in Excel
00:08:27

7 Working with Numeric Data in Excel
8 Entering Date Values in Excel
00:08:38

8 Entering Date Values in Excel
9 Working with Cell References
00:06:01

9 Working with Cell References
10 Creating Basic Formulas in Excel
00:08:33

10 Creating Basic Formulas in Excel
11 Relative Versus Absolute Cell References in Formulas
00:12:34

11 Relative Versus Absolute Cell References in Formulas
12 Understanding the Order of Operation DOWNLOAD EXERCISE FILE
00:10:37

12 Understanding the Order of Operation DOWNLOAD EXERCISE FILE
13 The structure of an Excel Function
00:10:17

13 The structure of an Excel Function
14 Working with the SUM Function
00:07:01

14 Working with the SUM Function
15 Working with the MIN and MAX Functions
00:06:19

15 Working with the MIN and MAX Functions
16 Working with the AVERAGE Function
00:02:52

16 Working with the AVERAGE Function
17 Working with the COUNT Function
00:02:52

17 Working with the COUNT Function
18 Adjacent Cells Error in Excel Calculations
00:03:40

18 Adjacent Cells Error in Excel Calculations
19 Using the AutoSum Command
00:06:49

19 Using the AutoSum Command
20 Excel s AutoSum Shortcut Key
00:02:13

20 Excel s AutoSum Shortcut Key
21 Using the AutoFill Command to Copy Formulas
00:04:25

21 Using the AutoFill Command to Copy Formulas
22 Moving and Copying Data in an Excel Worksheet
00:06:34

22 Moving and Copying Data in an Excel Worksheet
23 Inserting and Deleting Rows and Columns
00:07:14

23 Inserting and Deleting Rows and Columns
24 Changing the Width and Height of Cells
00:05:18

24 Changing the Width and Height of Cells
25 Hiding and Unhiding Excel Rows and Columns
00:05:08

25 Hiding and Unhiding Excel Rows and Columns
26 Renaming an Excel Worksheet
00:02:52

26 Renaming an Excel Worksheet
27 Deleting an Excel Worksheet
00:04:34

27 Deleting an Excel Worksheet
28 Moving and Copying an Excel Worksheet
00:05:12

28 Moving and Copying an Excel Worksheet
29 Working with Font Formatting Commands
00:03:55

29 Working with Font Formatting Commands
30 Changing the Background Color of a Cell
00:02:51

30 Changing the Background Color of a Cell
31 Adding Borders to Cells
00:03:34

31 Adding Borders to Cells
32 Formatting Data as Currency Values
00:05:22

32 Formatting Data as Currency Values
33 Formatting Percentages
00:02:18

33 Formatting Percentages
34 Using Excel s Format Painter
00:02:48

34 Using Excel s Format Painter
35 Creating Styles to Format Data
00:08:13

35 Creating Styles to Format Data
36 Merging and Centering Cells
00:02:51

36 Merging and Centering Cells
37 Using Conditional Formatting
00:04:35

37 Using Conditional Formatting
38 Inserting Images
00:04:10

38 Inserting Images
39 Inserting Excel Shapes
00:03:56

39 Inserting Excel Shapes
40 Formatting Excel Shapes
00:04:40

40 Formatting Excel Shapes
Show More Lessons

Comments

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

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


Related Courses in Computer Softwares
Excel Power Query
41 Lessons

Excel Power Query

Excel VBA
36 Lessons

Excel VBA

Excel Dashboard
21 Lessons

Excel Dashboard

Excel Course Basic to Advanced
26 Lessons

Excel Course Basic to Advanced

Excel Functions
66 Lessons

Excel Functions

Excel Charting
18 Lessons

Excel Charting

Microsoft Access
23 Lessons

Microsoft Access

Microsoft PowerPoint
52 Lessons

Microsoft PowerPoint

Microsoft Word
46 Lessons

Microsoft Word

Microsoft Excel
49 Lessons

Microsoft Excel

Digital Media Literacy
15 Lessons

Digital Media Literacy

Google Classroom
5 Lessons

Google Classroom

Google Slides
18 Lessons

Google Slides

Google Sheets Full data
15 Lessons

Google Sheets Full data

Google Docs
34 Lessons

Google Docs

Google Drive
11 Lessons

Google Drive

Course Description

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
Previous Lesson Next Lesson