Microsoft Excel - Fundamentals
5.0 (1 rating)
163 students enrolled
Wishlisted Wishlist

# Microsoft Excel - Fundamentals

Learn about Excel Environment,Worksheets,Functions,Sorting,Formatting,Reports,Charts,Printing,Security and Sharing.
5.0 (1 rating)
163 students enrolled
Last updated 2/2014
English
Current price: \$10 Original price: \$50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
• 3.5 hours on-demand video
• Access on mobile and TV
• Certificate of Completion
What Will I Learn?
• In this course, you will learn basic concepts of Microsoft Excel
• Enhance Worksheets Using Themes
• How to work with several Excel Functions
• How to secure and share Excel data
• How to Sort and Filter Data in Excel
• Working with Reports & Charts
• Present Excel data Using Charts
View Curriculum
Requirements
• Windows PC, Good Internet Connectivity and Basic database knowledge
Description

==============================================================

EXTREMELY USEFUL TO UNDERSTAND THE BASIC CONCEPTS OF EXCEL

===============================================================

At the end of this course, you will get the knowledge of...

Excel Environment, Excel Worksheet, Working with Excel Functions, Excel Security & Sharing Features, Dynamic Formatting in Excel, Sorting and Filtering Data in Excel, Using conditional Aggregate Functions in Excel, Working with Reports & Charts, Presenting Data Using Charts in Excel.

Who is the target audience?
• Beginners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
03:25:50
+
Overview of the Basics
9 Lectures 54:02
Preview 11:21

Absolute and Relative Cells
05:27

Working with the Excel Environment
03:55

08:27

Enhance Worksheets Using Themes
03:39

03:22

05:08

Auto Fill Features
06:41

Printing the Worksheet
06:02

Quiz
12 questions
+
Working with Functions
5 Lectures 49:19
Writing conditional expressions (using IF)
08:41

Using logical functions (AND, OR)
08:23

Using Date Functions
10:56

Using Text Function
14:22

Using Time Functions
06:57

Quiz
5 questions
+
Security & Sharing Features
3 Lectures 18:03
Protecting and un-protecting worksheets and cells
07:27

Hiding formulas
04:35

06:01

Quiz
3 questions
+
Dynamic Formatting
2 Lectures 19:36
Applying auto formatting option to worksheets
08:38

Applying conditional formatting to cells
10:58

Quiz
2 questions
+
Sorting and Filtering Data
2 Lectures 11:46
Sorting tables
05:21

Filtering data for selected view (Auto Filter)
06:25

Quiz
2 questions
+
Using conditional Aggregate Functions
1 Lecture 05:18
Database Functions
05:18
+
Working with Reports & Charts
6 Lectures 33:55
Creating subtotals
04:42

Multiple-level subtotals
04:20

Creating Pivot tables
06:59

Formatting and customizing Pivot tables
07:18

Using advanced options of Pivot tables
07:09

Pivot charts
03:27

Quiz
2 questions
+
Presenting Data Using Charts
3 Lectures 13:51
Creating a Chart
03:16

Modify Charts
05:42

Create a Chart Template
04:53

Quiz
2 questions