Microsoft Excel | IT Education Network

Microsoft Excel Course Instructor

IT Education Network

IT Education Network

IT Education Network channel for beginners and experts. IT Education Network channel helps those potential people who are not able to access educational institutions because of financial or distance issues. IT Education network provides home-based advanced level learning for them. IT Education Network channel helps you to become a skills professional and earn as a freelancer.
IT Education Network channel is a subsidiary group of Blue Byte Technology Solutions. Blue Byte Technology Solutions i

Course Details

No Of Lessons 86
Duration 3h 33m
Language English
No Of Students 29
No Prerequisite
(4)
Get course free

Sign in the course to get a certificate

Microsoft Excel Course Lessons

1 | MS Excel Tutorial - 01 - MS Excel Tutorial Introduction 00:01:56
2 | MS Excel Tutorial - 02 - Useful keyboard shortcuts and tips 00:09:36
3 | MS Excel Tutorial - 03 - Customizing the quick access toolbar 00:02:31
4 | MS Excel Tutorial - 04 - Customizing the ribbon 00:02:38
5 | MS Excel Tutorial - 05 - Using keyboard to access ribbon 00:01:31
6 | MS Excel Tutorial - 06 - The best techniques for inserting deleting data 00:03:04
7 | MS Excel Tutorial - 07 - Undo redo and repeat 00:02:40
8 | MS Excel Tutorial - 08 - 4 ways to protect excel workbooks worksheets 00:07:59
9 | MS Excel Tutorial - 09 - Navigate between workbooks quickly 00:02:29
10 | MS Excel Tutorial - 10 - Applying document themes in a workbook 00:01:36
11 | MS Excel Tutorial - 11 - Saving excel as a read only web page file 00:01:56
12 | MS Excel Tutorial - 12 - Navigate between worksheets quickly 00:02:31
13 | MS Excel Tutorial - 13 - How to create a hyperlink to other worksheets 00:02:55
14 | MS Excel Tutorial - 14 - How to prevent someone to unhide a worksheet 00:03:04
15 | MS Excel Tutorial - 15 - Copying and moving worksheets with various ways 00:02:51
16 | MS Excel Tutorial - 16 - Entering data to multiple worksheets at a time 00:02:24
17 | MS Excel Tutorial - 17 - How to print a 2 page worksheet on 1 page 00:01:59
18 | MS Excel Tutorial - 18 - Hiding scroll bars in a worksheet 00:01:38
19 | MS Excel Tutorial - 19 - How to set the number of worksheets 00:01:38
20 | MS Excel Tutorial - 20 - Learning different techniques for navigating within a given worksheet 00:02:33
21 | MS Excel Tutorial - 21 - How to create and save custom views of a worksheet 00:03:05
22 | MS Excel Tutorial - 22 - Solving the problem with leading zero 00:02:07
23 | MS Excel Tutorial - 23 - How to add text to a number 00:01:59
24 | MS Excel Tutorial - 24 - How to enter a lline break into one of your cells data 00:03:38
25 | MS Excel Tutorial - 25 - Using wrap text and shrink cell tools to have the size of the cells right 00:02:34
26 | MS Excel Tutorial - 26 - Creating a conditional format based on a value 00:03:02
27 | MS Excel Tutorial - 27 - Blocking a user to interact outside a specific range 00:02:21
28 | MS Excel Tutorial - 28 - How to hide the status bar 00:02:15
29 | MS Excel Tutorial - 29 - Changing values without formulas 00:02:22
30 | MS Excel Tutorial - 30 - How to highlight formula cells using conditional formatting 00:02:28
31 | MS Excel Tutorial - 31 - How to color rows using conditional formatting 00:02:47
32 | MS Excel Tutorial - 32 - How to format numbers using key stroke shortcuts 00:01:46
33 | MS Excel Tutorial - 33 - How to modify or create a cell style 00:03:02
34 | MS Excel Tutorial - 34 - Duplicate records and how to get rid of these 00:01:49
35 | MS Excel Tutorial - 35 - Creating bulleted list 00:02:48
36 | MS Excel Tutorial - 36 - Format painter tips 00:02:26
37 | MS Excel Tutorial - 37 - How to insert a watermark 00:02:19
38 | MS Excel Tutorial - 38 - Making your comments stand out 00:02:26
39 | MS Excel Tutorial - 39 - Creating a custom list 00:03:13
40 | MS Excel Tutorial - 40 - The paste special feature 00:02:44
41 | MS Excel Tutorial - 41 - Using fill handle to enter sequences of values 00:02:29
42 | MS Excel Tutorial - 42 - How to use flashfill to fill values in a range rapidly 00:02:01
43 | MS Excel Tutorial - 43 - How to select data using various keystroke shortcuts 00:02:25
44 | MS Excel Tutorial - 44 - How to set a specific print area 00:01:28
45 | MS Excel Tutorial - 45 - Entering data quickly and efficiently 00:03:15
46 | MS Excel Tutorial - 46 - Copying and moving data with various ways 00:01:57
47 | MS Excel Tutorial - 47 - Using pick from drop down list and enter data quickly 00:01:34
48 | MS Excel Tutorial - 48 - Using autocorrect to enter data fast 00:01:44
49 | MS Excel Tutorial - 49 - How to freeze titles and split screens 00:02:45
50 | MS Excel Tutorial - 50 - How to create a data entry form 00:02:33
51 | MS Excel Tutorial - 51 - Filling non adjacent cells with the current entry 00:02:17
52 | MS Excel Tutorial - 52 - Highlighting blank cells and sorting columns with them 00:03:05
53 | MS Excel Tutorial - 53 - Filling random values into every cell in a selection 00:01:58
54 | MS Excel Tutorial - 54 - How to generate random decimal numbers between 0 and 1 00:01:21
55 | MS Excel Tutorial - 55 - How to use count if and data validation to prevent-duplications 00:02:50
56 | MS Excel Tutorial - 56 - How to add comments inside formulas 00:01:46
57 | MS Excel Tutorial - 57 - The autosum magic 00:02:11
58 | MS Excel Tutorial - 58 - Identifying and fixing error inside of an excel formula 00:02:11
59 | MS Excel Tutorial - 59 - Finding related formulas easy 00:02:10
60 | MS Excel Tutorial - 60 - How to enter the current date or time 00:01:32
61 | MS Excel Tutorial - 61 - Using the new in excel 2013 function pduration 00:01:48
62 | MS Excel Tutorial - 62 - How to round values with various ways 00:02:53
63 | MS Excel Tutorial - 63 - Converting formulas to values easy 00:01:44
64 | MS Excel Tutorial - 64 - Using named ranges in formulas 00:03:38
65 | MS Excel Tutorial - 65 - Displaying all worksheet formulas in a second 00:01:38
66 | MS Excel Tutorial - 66 - Using trim function to get rid of unwanted spaces 00:02:12
67 | MS Excel Tutorial - 67 - How to calculate a persons age 00:02:03
68 | MS Excel Tutorial - 68 - How to convert values between measurement systems 00:01:54
69 | MS Excel Tutorial - 69 - Locking and hiding formula cells 00:02:39
70 | MS Excel Tutorial - 70 - Formatting data as table with table styles 00:02:31
71 | MS Excel Tutorial - 71 - Using the table reference to create a formula 00:02:07
72 | MS Excel Tutorial - 72 - How to create separate worksheets from pivot table 00:01:31
73 | MS Excel Tutorial - 73 - Create mini charts using sparklines 00:03:21
74 | MS Excel Tutorial - 74 - Linking chart titles with cell content 00:02:36
75 | MS Excel Tutorial - 75 - How to make all the charts exactly the same size 00:01:28
76 | MS Excel Tutorial - 76 - How to deal with missing data for a chart 00:01:39
77 | MS Excel Tutorial - 77 - Creating a chart with keyboard shortcuts 00:01:52
78 | MS Excel Tutorial - 78 - How to analyze an active workbook using the inquire add in 00:02:52
79 | MS Excel Tutorial - 79 - How to compare two lists of items and identify difference between them 00:03:07
80 | MS Excel Tutorial - 80 - Using quick analysis tool to find information about data 00:02:06
81 | MS Excel Tutorial - 81 - Getting data from a pdf file 00:01:45
82 | MS Excel Tutorial - 82 - Getting data from a pdf file 00:01:47
83 | MS Excel Tutorial - 83 - Applying goal seek tool to find a target 00:02:25
84 | MS Excel Tutorial - 84 - Forecasting scenarios with scenario manager 00:03:32
85 | MS Excel Tutorial - 85 - Monitoring the value in a worksheet using watch window 00:02:09
86 | MS Excel Tutorial - 86 - Calculating running totals 00:01:41

Students Reviews

5/5 ( 4 )

75%
25%
0%
0%
0%

Some Reviews

M

Milad Atef

24-03-2024

R

Rafiullahktk

06-08-2023

y

youtube

21-07-2023

j

jina essam

23-03-2024

© Copyright reserved to the channel owners | Terms and Privacy