+ View more
Course overview
The word history has its origin in the Greek word “Historia” which means to ask, enquiry or search
for truth and report finding, there are many definitions of history which includes.
Curriculum for this course
81 Lessons
02:50:43 Hours
File Management
8 Lessons
00:15:53 Hours
-
Open Excel
Preview 00:01:45
-
Test video
00:03:00
-
Saving
Preview 00:02:23
-
Cell Navigation
00:03:45
-
Close workbook
00:00:00
-
Recover unsaved documents
00:00:00
-
Excel Window
00:05:00
-
Switching full screen
00:00:00
Data Entry
8 Lessons
00:17:30 Hours
-
Insert Data Into cell
00:02:00
-
Insert number into cell
00:03:00
-
Auto complete
00:02:45
-
Pick up dropdown list
00:01:30
-
Flash fill
00:03:00
-
Select range
00:01:30
-
Range data Entry
00:01:45
-
Auto fill
00:02:00
Creating Formulas
6 Lessons
00:14:20 Hours
-
Ranged Formula Syntax
00:05:00
-
Simple Formula
00:03:45
-
Using AutoSum
00:02:30
-
Options in Insert Functions
00:01:20
-
Editing range formula
00:01:45
-
AutoCalculate
00:00:00
Copying & Pasting Formulas
3 Lessons
00:08:45 Hours
-
Copy Formula
00:03:30
-
Cutting, Copying, and Pasting Data
00:02:30
-
Undo and Redo
00:02:45
Columns & Rows
2 Lessons
00:03:45 Hours
-
Selecting Columns & Rows
00:02:00
-
Hiding and Unhiding Columns and Rows
00:01:45
Formatting Worksheets
5 Lessons
00:08:00 Hours
-
Working Formats
00:02:30
-
Formatting Cell
00:02:45
-
The Format Cells Dialog Box
00:00:00
-
Format Painter
00:01:45
-
Clear Formats
00:01:00
Worksheet Tools
6 Lessons
00:08:00 Hours
-
Inserting and Deleting Worksheets
00:01:45
-
Naming Range with Table header
00:00:00
-
Selecting Multiple Worksheets
00:00:00
-
Navigating Worksheets
00:02:00
-
Renaming and Coloring Worksheet Tabs
00:02:15
-
Moving Worksheets
00:02:00
Setting Worksheet Layout
1 Lessons
00:02:00 Hours
-
Page Preview
00:02:00
Helping Yourself
1 Lessons
00:03:15 Hours
-
Using help button
00:03:15
Creating 3D Formulas
1 Lessons
00:01:15 Hours
-
3D formulas
00:01:15
Named Ranges
3 Lessons
00:09:15 Hours
-
Naming ranges
00:03:30
-
Using range name by function
00:03:00
-
Rename and Delete range name
00:02:45
Conditional Formatting and Cell Styles
3 Lessons
00:04:15 Hours
-
Conditional formatting
00:02:15
-
Find conditional formatting
00:01:00
-
Removing conditional format
00:01:00
Paste Special
2 Lessons
00:04:00 Hours
-
Special Paste
00:02:00
-
Paste link
00:02:00
Sharing Workbooks
1 Lessons
00:02:15 Hours
-
Add comments
00:02:15
Auditing Worksheets
5 Lessons
00:09:30 Hours
-
Trace Precedent and Dependence
00:01:30
-
Knowing formula
00:03:15
-
Evaluate the formula
00:02:00
-
Watch Window
00:00:00
-
Cell Validation
00:02:45
Outlining Worksheets
2 Lessons
00:03:45 Hours
-
Using outline
00:01:45
-
Applying outline
00:02:00
Tables
4 Lessons
00:05:15 Hours
-
Creating Table
00:02:00
-
Insert Data into the table
00:00:45
-
Insert new record
00:01:00
-
Insert Row and column
00:01:30
Sorting Data
3 Lessons
00:09:15 Hours
-
Filter and Sorting
00:02:45
-
Filter and Sorting
00:02:45
-
Custom Order
00:03:45
Filtering Data
5 Lessons
00:07:45 Hours
-
Sorting by top 10
00:01:15
-
Auto custom filter
00:00:00
-
Advanced Filter
00:02:30
-
Applying Multiple Options
00:02:30
-
Filter Copy
00:01:30
What-If Analysis and Forecasts
3 Lessons
00:11:15 Hours
-
What if analysis - Table
00:04:45
-
Goal seek
00:02:45
-
Scenario Manager
00:03:45
Table-Related Functions
2 Lessons
00:04:00 Hours
-
VLoopUp
00:04:00
-
If Function
00:00:00
Sparklines
1 Lessons
00:03:15 Hours
-
Sparkline
00:03:15
Creating Charts In Excel
4 Lessons
00:07:45 Hours
-
Insert Chart
00:02:45
-
Change Chart size
00:01:15
-
Change color and Delete Chart
00:00:00
-
Chart Element
00:03:45
Formatting Charts in Excel
2 Lessons
00:06:30 Hours
-
Change Chart Style
00:03:00
-
Using as template Chart
00:03:30
+ View more
Other related courses
About instructor
Student feedback
Write a public review