logo-img
+919829370077 perfectbusiness2019@gmail.com Plot no 15 jamuna colony sikar road Jaipur-302023
+919829370077 perfectbusiness2019@gmail.com Plot no 15 jamuna colony sikar road Jaipur-302023

Course Details

Ms Excel Training

(0 reviews )
course-meta
Created by
TechBusinessIndia

Total Enrolled

1

Last Update

09-05-2023

09-05-2023

Microsoft Office

Description

Excel overview lecture-1
How to fill up data in excel
sum,avrg,mini,maxi formula
usage of IF formula
usage of conditional formting
Excel Interface Overview Lecture-2 
Home Tab Font Section Formatting Options 
Home Tab Alignment Section Formatting Options 
Home Tab Number Section Formatting Options 
Home Tab Edit Section Filter Option Lecture-1 
Home Tab Editing Section Text Filter 
Home Tab Editing Section Number and Date FIlter 
Home Tab Editing Section Question Mark and Star Filter Usage 
Home Tab Clipboard Section Format Painter 
Home Tab Editing Section Sort and Filter 
Usage Of Nested IF Formula 
Count Counta and countIF Formual in Excel 
Usage Of Sum And Sum IF Formula in Excel 
Usage Of CountIFS Formula in Excel 
Usage of Large and Small Formula in Excel 
Usage Of Rank Formula in Excel 
Usage Of Upper Lower and Proper Formula in Excel 
Usage Of Trim Formula in Excel 
Usage Of Vlookup Formula For Exact Match
Usage Of Vlookup Formual Approximate Match
Usage of Hlookup Formula in Excel
Usage Of Weekday Formula in Excel 
Usage Of Day Month and Year Formula in Excel
Insert Tab Chart Section Column Chart
Column Chart Features in Depth
Insert Tab Table Section Create Table

To know How to Purcahse Course Click the Link Below:

What you'll learn

  • Ms Excel Systematic Training

Requirements

  • • Google Account
  • • Internet Connection
  • • Dedication for Learning

Curriculum

  • Excel overview lecture-1
  • How to fill up data in excel
  • usage of conditional formting
  • Excel Interface Overview Lecture-2

  • Home Tab Font Section Formatting Options
  • Home Tab Alignment Section Formatting Options
  • Home Tab Number Section Formatting Options
  • Home Tab Edit Section Filter Option Lecture-1
  • Home Tab Editing Section Text Filter
  • Home Tab Editing Section Number and Date FIlter
  • Home Tab Editing Section Question Mark and Star Filter Usage
  • Home Tab Clipboard Section Format Painter
  • Home Tab Editing Section Sort and Filter

  • sum,avrg,mini,maxi formula
  • usage of IF formula
  • Usage Of Nested IF Formula
  • Count Counta and countIF Formual in Excel
  • Usage Of Sum And Sum IF Formula in Excel
  • Usage Of CountIFS Formula in Excel
  • Usage Of Weekday Formula in Excel
  • Usage Of Trim Formula in Excel
  • Usage of Large and Small Formula in Excel
  • Usage Of Rank Formula in Excel
  • Usage Of Upper Lower and Proper Formula in Excel
  • Usage Of Vlookup Formula For Exact Match
  • Usage Of Vlookup Formual Approximate Match
  • Usage of Hlookup Formula in Excel
  • Usage Of PMT Formula in Excel

  • Create Pivot Table Process Lecture-1
  • Creating Pivot Table Process Lecture-2
  • Creating Pivot Table Process Lecture-3
  • Pivot Table Analyze Tab Actions Sections Detailed Features
  • Pivot Table Analyze Tab Data Section Refresh Feature
  • Usage Of Conditional Formatting With Pivot Table
  • How To Convert Created Table To Normal Format

  • Different Types Of Column Chart
  • Insert Tab Chart Section Column Chart
  • Column Chart Features in Depth

Student Feedback

0

0 Reviews
0%
0%
0%
0%
0%
Rs 4100 Rs 399
  • Level
    Intermediate
  • Category
    Microsoft Office
  • Laguage
    Hindi, English
  • Access
    LifeTime