Entri Blog
No Result
View All Result
Saturday, June 10, 2023
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
    • Python Programming Course
    • Practical Accounting Course
    • Quantity Surveying Course
  • Others
    • GATE
    • MAT
    • KMAT
    • UPSC
Try out Spoken English!
Entri Blog
  • State PSC
    • Kerala PSC
    • TNPSC
    • APPSC
    • TSPSC
    • BPSC
    • Karnataka PSC
    • MPPSC
    • UPPSC
  • Banking
    • IBPS PO Notification
    • IBPS Clerk Notification
    • SBI PO Notification
    • SBI Clerk Notification
    • SBI SO Notification
    • SBI Apprentice Notification
    • Canara Bank PO Notification
    • Indian Bank PO Notification
    • RBI Assistant Notification
    • RBI Office Attendant Notification
    • IBPS RRB Notification
    • IBPS RRB Office Assistant Notification
  • Govt Exams
    • Railway
    • SSC
  • Skilling
    • Coding
    • Spoken English
    • Stock Marketing
  • TET
    • APTET
    • CTET
    • DSSSB
    • Karnataka TET
    • Kerala TET
    • KVS
    • MPTET
    • SUPER TET
    • TNTET
    • TSTET
    • UPTET
  • Courses
    • Data Science Course
      • Data Science Malayalam
    • Full Stack Developer Course
      • Full Stack Development Malayalam
      • Full Stack Development Hindi
      • Full Stack Development Tamil
      • Full Stack Development Telugu
      • Full Stack Development Kannada
    • Stock Market Course
      • Stock Market Course in Malayalam
      • Stock Market Course in Tamil
      • Options Trading Course
    • Spoken English Course
      • Spoken English Course in Malayalam
      • Spoken English Course in Hindi
      • Spoken English Course in Telugu
      • Spoken English Course in Tamil
      • Spoken English Course in Kannada
    • Python Programming Course
    • Practical Accounting Course
    • Quantity Surveying Course
  • Others
    • GATE
    • MAT
    • KMAT
    • UPSC
No Result
View All Result
Entri Blog
Spoken English
banner top article banner top article
Home Articles

Microsoft Excel Malayalam Tutorial

by Zubaida Naheeda
May 23, 2023
in Articles, Entri Skilling
Microsoft Excel Malayalam Tutorial
Share on FacebookShare on WhatsAppShare on Telegram

Table of Contents

  • Why To Use Excel?
  • Where All Excel Is Used?
  • Financial And Accounting Uses 
  • About MS Excel Malayalam Tutorial Course
  • MS Excel Course Syllabus

Excel is a spreadsheet program developed by Microsoft. Excel organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS. The first version of excel was came out in 1985 and has gone through several changes over the years.

Microsoft Excel is a spreadsheet program used to collect, analyze, and display qualitative and quantitative data. Excel spreadsheets can be used for everything from simple calculations and sorted lists to complex analysis using a range of formulas. Excel is typically used to organize data and perform financial analysis. It is used across all business purposes and at companies from small to large.

To Learn More About MS Excel Enroll To Entri App!!

Why To Use Excel?

  • It is the most popular spreadsheet program in the world
  • It is easy to learn and to get started.
  • The skill ceiling is high, which means that you can do more advanced things as you become better
  • It can be used with both work and in everyday life, such as to create a family budget
  • It has a huge community support
  • It is continuously supported by Microsoft
  • Templates and frameworks can be reused by yourself and others, lowering creation costs

Where All Excel Is Used?

Microsoft Excel is used by small and large companies to collect and  organize data to perform financial analysis. The main uses of MS Excel includes:

  • Data entry
  • Data management
  • Accounting
  • Financial analysis
  • Charting and graphing
  • Programming
  • Time management
  • Task management
  • Financial modeling
  • Customer relationship management (CRM)

Financial And Accounting Uses 

It is a fact that many of the organizations perform their entire accounting functions by using Excel spread sheet. While Excel is defined as a “data” management tool, the data that is most commonly managed is financial. So we can define excel as an ultimate financial software. The most important thing about excel is its openness and robustness. By using Excel we can manage large data and save time consume.

In this article, we are providing the details about the Microsoft Excel Malayalam tutorial Course like which all  topics we are covering. Here we are providing basic to advance course of Microsoft excel 2019 in Malayalam by a well  experienced tutor.

There is no need of a basic knowledge in Excel to join our course. we are starting from the basics.

About MS Excel Malayalam Tutorial Course

Microsoft Excel is one of the most impactful and widespread tools in the finance world. It is not necessary to have any prior experience with spreadsheet programs or programming. If you are a beginner to this course our entri app offers a beginner to advanced level of online tutorial classes in Malayalam language to take your skills to the next level. Aspirants can watch a glimpse of our course here.

MS Excel Course Syllabus

MS Excel Course Complete Syllabus 

 Section 1: Introduction
Getting to Know Excel
The Work Surface
Navigation
Interface
Formatting
Tabs and Ribbons
Document Windows
First File
Navigation Tips
Office Button and Save
Basic Math

Section2: Entering, Editing and Formatting Data

Introduction
Fonts, Fills,
Cut, Copy, and Paste
Alignment
Paste Special
Entering Data
Cell Styles
Comments
Replacing values
Undo and Redo
Moving, Finding,
Cell Referencing
Function Anatomy
Math Functions
Basic Statistics
Logic Functions
Section 3
Introduction
Custom and Special Formats
Currency Format
Format Painter
Formatting Dates

Section 4: Managing Worksheets

Introduction
Temporal Functions
External Links
Adding, Deleting and Hiding Worksheets
Grouping Worksheets
Intermediate Formula Knowledge
Moving, Copying, Deleting
Naming and Moving Worksheets
Copying Worksheets
Hiding Grouped Worksheets

Section 5: Modifying Rows and Columns

Introduction
Modifying Cell Width and Height
Inserting Multiple Columns & Rows
Hiding and Unhiding Rows and Columns
Inserting and Deleting Columns and Rows
Inserting & Deleting Cells

Section 6: Understanding Formulas

Introduction
Using Relative and Absolute References
Searching for Formulas
Copying Formulas
Common Formulas
Using Operations
Creating Formulas
AutoSum

Section 7: Changing Views

Introduction
Formula Auditing
Workbook Views
Viewing Multiple Windows
Minimize The Ribbon
Freeze Panes
Conditional Math
Split Windows
Worksheet Backgrounds
Watermarks
Show/Hide
Zoom Features

Section 8: AutoFill and Custom Lists

Introduction
AutoFill Non-Adjacent Cells
AutoFill on Multiple Sheets
Series Formatting
Creating Custom Lists
AutoFill a Series

Section 9: Conditional Formatting

Introduction
Color Scales
Custom Formatting Rule
Highlight Cells Rules
Top/Bottom Rules
Data Bars

Section 10: Tables

Introduction
Summaries With Pivot Table
Insert a Table and Style Options
Add Rows and Columns
Perform a Function in a Table

Section  11: Data Tools

Introduction
Text To Columns
Goal Seek
Data Validation
Drop-Down Lists
Removing Duplicates
Scenario Manager

Section 12: Referencing Formulas

Introduction
Consolidating Data – With or Without Links
Trace the Precedents and Dependents
Using the Watch Window
Multiple Sheet References

Section 13: Ranges and Dates

Introduction
Date Formulas
Cell Names
Named Ranges
Formulas with Cell Names

Section  14: Lookups

Introduction
VLOOKUP
VLOOKUP Exact Match
HLOOKUP
HLOOKUP Exact Match

Section 15: Conditional Logic

Introduction
SUMIF
IF Statement
Nested IF
AND
OR
NOT
IFERROR
AVERAGEIF
COUNTIF & COUNTIFS
SUMIFS
AVERAGEIFS

Section 16: Text Formulas

Introduction
Case Formulas
Fix Number Fields
Trim Spaces
Substitute Text
Section17: Introduction to Charts
Introduction
Picture Fill
Chart Types
Instant Chart
Update Chart
Column Chart
Adjust Chart Size
Line Chart
Scatter Chart

Section 18: Formatting Charts

Introduction
Axis Options
Chart Title
Legends
Data Labels
Chart Styles
Chart Layouts
Add Labels

Section 19: Adding Graphics to Spreadsheets

Introduction
Insert Pictures
Modifying Pictures
Insert Shapes
Insert SmartArt
Apply Themes
Arrange

Section 20: Outline, Sort, Filter, and Subtotal

Introduction
Group and Ungroup
Sort Data
Sort Multiple Levels
Filter Data
Advanced Filter
Conditional Sorting and Filtering
Sorting with Custom Lists
Subtotal
PivotTables
Introduction
Creating PivotTables
Choosing Fields
PivotTable Layout
Filtering PivotTables
Modifying PivotTable Data
Pivot Charts
Protecting Data
Workbook Passwords
Protecting Workbooks
Unlocking Cells
Collaboration
Document Properties
Inserting Hyperlinks
Sharing a Workbook
Track Changes
Accept/Reject Changes
Mark as Final
Printing
Page Orientation
Page Breaks
Print Area
Margins
Print Titles
Headers and Footers
Scaling
Sheet Options
 Saving a Workbook
Save As Previous Version
Auto Recover Save Options
Templates
Save As PDF
Save As Web Page
Macro-Enabled Workbook

Section 21: Macros

Macro Security
Recording a Macro
Assign a Macro to a Button or Shape
Run a Macro upon Opening a Workbook
How to Inspect and Modify a Macro

Related Articles

Analysis and Interpretation of Financial Statements

Exploratory Data Analysis Techniques: Know the Difference

Exploratory Data Analysis in Machine Learning – EDA Steps, Importance

Best Data Science Skills for Data Science Career

 

Big Data Analytics – Importance, Applications and Examples

Top 10 Benefits of Big Data

×









    Share67SendShare
    Zubaida Naheeda

    Zubaida Naheeda

    Related Posts

    Kerala PSC Executive Assistant/Stenographer Admit Card 2023 Out: Link, PDF
    Admit Card

    Kerala PSC Executive Assistant/Stenographer Admit Card 2023 Out: Link, PDF

    May 16, 2023
    Kerala PSC Tracer Admit Card 2023 Out: Check Link, PDF, Exam Date
    Articles

    Kerala PSC Tracer Admit Card 2023 Out: Check Link, PDF, Exam Date

    May 16, 2023
    Kerala PSC Surveyor Gr. II Exam Date 2023: Center, Hall Ticket
    Articles

    Kerala PSC Surveyor Exam Date 2023: Center, Hall Ticket

    May 15, 2023
    Next Post
    World Wildlife Day 2023 - Theme, Activities, Quotes, Quiz

    World Wildlife Day 2023 - Theme, Activities, Quotes, Quiz

    Discussion about this post

    Latest Posts

    • Kerala PSC VHSE Previous Question Papers 2023
    • Kerala PSC LP/UP Assistant Previous Year Question Papers: Download PDF, Link
    • Kerala PSC LGS Previous Question Papers Out: Download PDF
    • Kerala PSC Higher Secondary School Teacher Interview Date 2023 Out: Call Letter
    • Kerala PSC Assistant Gr. II Admit Card 2023: Exam Date, Download Link, PDF

    Trending Posts

    • states of india and their capitals and languages

      List of 28 States of India and their Capitals and Languages 2023 – PDF Download

      150837 shares
      Share 60332 Tweet 37708
    • List of Government Banks in India 2023: All you need to know

      62286 shares
      Share 24914 Tweet 15572
    • TNPSC Group 2 Posts and Salary Details 2022

      39785 shares
      Share 15914 Tweet 9946
    • KSDA Recruitment 2023 Apply Online for 9264 FDA SDA Posts – Qualification

      3269 shares
      Share 1308 Tweet 817
    • New Map of India with States and Capitals 2023

      29286 shares
      Share 11714 Tweet 7321

    Courses

    • Data Science Course
    • Full Stack Developer Course
    • Data Science Course in Malayalam
    • Full Stack Developer Course in Malayalam
    • Full Stack Developer Course in Hindi
    • Full Stack Developer Course in Tamil
    • Full Stack Developer Course in Telugu
    • Full Stack Developer Course in Kannada

    Company

    • Become a teacher
    • Login to Entri Web

    Quick Links

    • Articles
    • Videos
    • Entri Daily Quiz Practice
    • Current Affairs & GK
    • News Capsule – eBook
    • Preparation Tips
    • Kerala PSC Gold
    • Entri Skilling

    Popular Exam

    • IBPS Exam
    • SBI Exam
    • Railway RRB Exam
    • Kerala PSC
    • Tamil Nadu PSC
    • Telangana PSC
    • Andhra Pradesh PSC
    • MPPSC
    • UPPSC
    • Karnataka PSC
    • Staff Selection Commission Exam

    © 2021 Entri.app - Privacy Policy | Terms of Service

    No Result
    View All Result
    • State PSC
      • Kerala PSC
      • TNPSC
      • APPSC
      • TSPSC
      • BPSC
      • Karnataka PSC
      • MPPSC
      • UPPSC
    • Banking
      • IBPS PO Notification
      • IBPS Clerk Notification
      • SBI PO Notification
      • SBI Clerk Notification
      • SBI SO Notification
      • SBI Apprentice Notification
      • Canara Bank PO Notification
      • Indian Bank PO Notification
      • RBI Assistant Notification
      • RBI Office Attendant Notification
      • IBPS RRB Notification
      • IBPS RRB Office Assistant Notification
    • Govt Exams
      • Railway
      • SSC
    • Skilling
      • Coding
      • Spoken English
      • Stock Marketing
    • TET
      • APTET
      • CTET
      • DSSSB
      • Karnataka TET
      • Kerala TET
      • KVS
      • MPTET
      • SUPER TET
      • TNTET
      • TSTET
      • UPTET
    • Courses
      • Data Science Course
        • Data Science Malayalam
      • Full Stack Developer Course
        • Full Stack Development Malayalam
        • Full Stack Development Hindi
        • Full Stack Development Tamil
        • Full Stack Development Telugu
        • Full Stack Development Kannada
      • Stock Market Course
        • Stock Market Course in Malayalam
        • Stock Market Course in Tamil
        • Options Trading Course
      • Spoken English Course
        • Spoken English Course in Malayalam
        • Spoken English Course in Hindi
        • Spoken English Course in Telugu
        • Spoken English Course in Tamil
        • Spoken English Course in Kannada
      • Python Programming Course
      • Practical Accounting Course
      • Quantity Surveying Course
    • Others
      • GATE
      • MAT
      • KMAT
      • UPSC

    © 2021 Entri.app - Privacy Policy | Terms of Service