Microsoft Excel - Fundamentals
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
162 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Fundamentals to your Wishlist.

Add to Wishlist

Microsoft Excel - Fundamentals

Learn about Excel Environment,Worksheets,Functions,Sorting,Formatting,Reports,Charts,Printing,Security and Sharing.
5.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
162 students enrolled
Last updated 2/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
In this course, you will learn basic concepts of Microsoft Excel
How to access Toolbar and common options in 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
  • Graduates
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 03:25:50
+
Overview of the Basics
9 Lectures 54:02

Absolute and Relative Cells
05:27

Working with the Excel Environment
03:55

About Excel Worksheet
08:27

Enhance Worksheets Using Themes
03:39

Working with Comments
03:22

Access External Resources Using Hyperlinks
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

Saving files with passwords
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
About the Instructor
Parallel Branch Inc
3.8 Average rating
938 Reviews
9,949 Students
32 Courses
Academy Of Technical Courses, Grow Your Skills Today

We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.

In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.