/CourseBundles(67055)/4560905-Microsoft_Excel_for_Professionals.jpg)
Course Overview
Schedule of Classes
Course Curriculum
1 Subject
Microsoft Excel for Professionals
92 Learning Materials
Getting Started
Course Introduction
Video
00:01:27
New Workbook
Video
00:08:34
Excel Interface
Video
00:05:30
Data Management
Practice Data for Data Management
ZIP
Basic Data Entry Operation
Video
00:15:15
Clipboard Operations
Video
00:18:28
Custom Fonts
Video
00:07:59
Custom Borders
Video
00:09:00
Custom Colors
Video
00:04:29
Text Alignments
Video
00:03:08
Text Indentation
Video
00:02:41
Text Orientation
Video
00:02:39
Make Text Visible inside Cell
Video
00:05:32
Merging Cells
Video
00:09:09
Data Types
Video
00:14:35
Insert Operations
Video
00:04:04
Delete Operation
Video
00:04:51
Format Cell Size
Video
00:05:56
Content Visibility
Video
00:06:29
Organize Sheets
Video
00:08:33
Hyper Link
Video
00:06:05
Math Formula and Functions
Data for Math Formula and Functions
ZIP
Basic Math Operations
Video
00:11:00
Input and Calculation Styles
Video
00:02:19
Generate Numbers
Video
00:08:06
Rounding Functions
Video
00:15:08
Absolute Value and Sign
Video
00:01:45
Basic Aggregate Functions
Video
00:07:36
Data Extraction Functions
Practice data for Data Extraction
ZIP
Basic Text Extraction Functions
Video
00:00:00
Text Extraction Before and After Delimeter
Video
00:00:00
Splitting Text Data
Video
00:00:00
Text Position and Size
Video
00:00:00
Data Transformation Functions
Practice Data
ZIP
Text Concatenation
Video
00:07:21
Modifying Text Cases
Video
00:01:48
Replace and Substitute Functions
Video
00:06:19
Trim Function
Video
00:03:07
Date and Time Functions
Practice Data
ZIP
Date and Time Creation
Video
00:06:17
Date and Time Conversion
Video
00:01:55
Date and Time Extaction
Video
00:05:32
Date Difference and Intervals
Video
00:06:40
Date Addition and Adjustments
Video
00:04:04
Lookup and Reference Functions
Practice Data
ZIP
Core Lookup Functions
Video
00:23:05
Match and Index
Video
00:13:50
Comparison and Conditionals
Practice Data
ZIP
Comparison Operators
Video
00:05:49
Comparison Functions
Video
00:09:00
Logical Tests
Video
00:12:12
Handling Multiple Conditions - Sequential
Video
00:15:26
Handling Multiple Conditions - Parallel
Video
00:24:23
Tables
Practice Data
ZIP
Table Design
Video
00:14:53
Sort and Filters
Video
00:21:01
Slicers
Video
00:11:11
Conditional Formatting
Practice Data
ZIP
Highlight Cell By Rules
Video
00:08:12
Ranking Rules
Video
00:04:21
Selection Based Rules
Video
00:04:18
Manage Rules
Video
00:07:32
Data Analysis with Pivot Tables
Practice Data
ZIP
Creating a Pivot Table
Video
00:10:07
Pivot Table Design
Video
00:06:08
Timeline Control
Video
00:04:32
Refresh and Change Data Source
Video
00:03:18
Pivot Table Actions
Video
00:02:23
Show & Hide Pivot Table Components
Video
00:01:38
Data Visualization with Pivot Charts
Practice Data
ZIP
Chart Elements
Video
00:15:51
Chart Layouts
Video
00:01:56
Chart Style
Video
00:01:47
Presenting Categories Comparison
Video
00:09:19
Presenting Categories Composition
Video
00:04:20
Presenting Data Trend
Video
00:07:58
Data Review
Practice Data
ZIP
Proofing
Video
00:04:54
Optimize Performance
Video
00:01:19
Accessibility
Video
00:03:27
Translate Contents
Video
00:02:19
Comments & Notes
Video
00:05:52
Data Protection
Video
00:15:07
Page Layout
Practice Data
ZIP
Page Margins
Video
00:02:50
Page Orientation and Size
Video
00:04:51
Print Area
Video
00:02:21
Apply Page Breaks
Video
00:01:53
Page Background
Video
00:01:05
Setting Title on Each Page
Video
00:01:36
Scale to Fit
Video
00:02:22
Sheet Options
Video
00:02:30
Course Instructor
By clicking on Continue, I accept the Terms & Conditions,
Privacy Policy & Refund Policy