Microsoft Excel - Fundamentals

Learn about Excel Environment,Worksheets,Functions,Sorting,Formatting,Reports,Charts,Printing,Security and Sharing.
0.0 (0 ratings)
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.
159 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 31
  • Length 3.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course 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.

What are the requirements?

  • Windows PC, Good Internet Connectivity and Basic database knowledge

What am I going to get from this course?

  • 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

What is the target audience?

  • Beginners
  • Graduates

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Overview of the Basics
Quick Access Toolbar and common options in Excel
Preview
11:21
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
Section 2: Working with Functions
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
Section 3: Security & Sharing Features
Protecting and un-protecting worksheets and cells
07:27
Hiding formulas
04:35
Saving files with passwords
06:01
Quiz
3 questions
Section 4: Dynamic Formatting
Applying auto formatting option to worksheets
08:38
Applying conditional formatting to cells
10:58
Quiz
2 questions
Section 5: Sorting and Filtering Data
Sorting tables
05:21
Filtering data for selected view (Auto Filter)
06:25
Quiz
2 questions
Section 6: Using conditional Aggregate Functions
Database Functions
05:18
Section 7: Working with Reports & Charts
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
Section 8: Presenting Data Using Charts
Creating a Chart
03:16
Modify Charts
05:42
Create a Chart Template
04:53
Quiz
2 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Parallel Branch Inc, 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.

Ready to start learning?
Take This Course