Preview Microsoft Excel (Hindi

Working With Cells

2.1 Enter & Edit Data In Cells

2.2 Cut, Copy & Paste In Cells

2.3 Clip Board In Cells

Quiz

Working With Cells

Formatting Cells

3.1 Bold, Italic & Underline

3.2 Background & Font Color

3.3 Increase & Decrease Font Size

3.4 Font Type & Size

3.5 Borders

3.6 Advanced Font Options

Quiz

Formatting Cells

Alignment

4.1 Merge & Unmerge

4.2 Alignment Of Text

4.3 Text Direction

4.4 Indentation

4.5 Wrap Text

4.6 Advanced Alignment Options

Quiz

Alignment

Number Formatting

5.1 Number Format

5.2 Currency Format

5.3 Percent Format

5.4 Date Format

5.5 Custom Format Date

5.6 Custom Format Number

5.7 Usage Of Format Painter

Quiz

Number Formatting

Conditional Formatting

6.1 Highlight Cell Rules-Numbers

6.2 Highlight Cell Rules-Text

6.3 Highlight Cell Rules-Dates

6.4 Highlight Cell Rules-Duplicate Values

6.5 Data Bars

6.6 Color Scale

6.7 Icon Sets

6.8 Top & Bottom Rules

Quiz

Conditional Formatting

Cell Group

7.1 Insert & Delete Rows

7.2 Insert & Delete Columns

7.3 Row Height & Column Width

7.4 Autofit Column Width

7.5 Insert, Delete & Copy Sheet

7.6 Sheet Rename & Color

7.7 Hide & Unhide Sheets

7.8 Hide & Unhide, Column & Rows

Quiz

Cell Group

Editing Group

8.1 Fill

8.2.0 Fill Series

8.2.1 Fill Series

8.3 Custom list

8.4 Functions

8.5 Clear

8.6 Find & Replace

8.7 Go To

Quiz

Editing Group

Tricks and Tips

9.1 Speak Cells

9.2 Backend Settings

9.3 Ribbon & QAT

9.4 Ctrl & Shift Keys

9.5 Shortcuts

9.6 Find Your Exact Age

9.7 Format Multiple Sheets

Quiz

Tips & Tricks

Sort and Filter

10.1 Basic Sorting

10.2 Multilayer Sorting

10.3 Sorting By Color

10.4 Custom Sorting

10.5 Basic Filter

10.6 Filter By Color

10.7 Advanced Filter

10.8 Advanced Filter With AND & OR Criteria

Quiz

Sort & Filter

Table

11.1 Creating A Table

11.2 Table Style & Table Option

11.3 Total Row In Tables

11.4 Remove Duplicates

11.5 Resize & Rename Table

11.6 Slicers

11.7 Convert To Range

Quiz

Tables

Hyperlink

12.1 Hyperlink

12.2 Link To WebPage

12.3 Link Within Same File

12.4 Create A New Hyperlink

12.5 Screen Tip

12.6 Hyperlink To Object

Quiz

Hyperlink

Protection & Hiding Techniques

13.1 Sheet Protection

13.2 Protect Structure Of Workbook

13.3 Protect A File

13.4 Cell Protection

13.5 Protect & Hide Formula

13.6 Settings While Protection

Quiz

Protection & Hiding Techniques

Working with Functions

14.1 Formula vs Function

14.2 Function Help

Working with Functions

Maths Function

15.1 Basic Maths

15.2 Count, Counta & CountBlank

15.3 Round Function

15.4 Round Up & Round Down

15.5 Ceiling & Floor

Quiz

Maths Function

Text Functions

16.1 Upper, Lower & Proper Case

16.2 Left, Right & Trim

16.3 Substitute & Replace

16.4 Find & Search

16.5 Concatenate Function

Quiz

Text Functions

Date Functions

17.1 Day, Month, Quarter & Year

17.2 Add & Subtract Days

17.3 Add & Subtract Years & Months

17.4 Weekday & Weeknum Function

17.5 Today & Now Function

Quiz

Date Functions

Flash Fill

18.1 Flash Fill Text

18.2 Flash Fill Date

18.3 Flash Fill Numbers

18.4 Flash Fill Text To Columns

Quiz

Flash Fill

Logical Functions

19.1 IF Function

19.2 IF With AND Function Part - 1

19.3 IF With Or Function

19.4 Nested IF Function

19.5 IF With AND Part - 2

19.6 IF Error Function

Quiz

Logical Functions

Name Manager

20.1 Name Range

20.2 Name Range In Function

20.3 Create Name Range To Multiple Columns

Quiz

Name Manager

Statistical Function

21.1 Sum, SumIf & SumIfs

21.2 Count, CountIf & CountIfs

21.3 Average, AverageIf & AverageIfs

21.4 Min, MinIf & MinIfs

21.5 Max, MaxIf & MaxIfs

21.6 Small & Large Function

Quiz

Statistical Functions

Data Validation

22.1 Data Validation Basics

22.2 Drop Down List

22.3 Name Range

22.4 Input Message & Error Alert

22.5 Dependent Drop Down

Quiz

Data validation

Absolute & Relative Reference

23.2 Absolute Referencing

23.1 Relative Reference

23.3 Mixed Cell References

Quiz

Absolute & Relative Reference

Lookup Functions

24.1 VLookup Basics

24.2 Vlookup Approximation

24.3 Vlookup Rule

24.4 Data Validation

24.5 Hlookup Function

24.6 Vlookup With Trim

24.7 Match Function

24.8 Index Function

24.9 Index & Match Function

24.10 Full Record

Quiz

LookUp Functions

Charts & Graphs

25.1 Column Charts All

25.2 Chart Design

25.3 Adding Chart Elements

25.4 Column Chart

25.5 Bar Chart

25.6 Stacked Column Chart

25.7 Pie Chart & Donut Chart

25.8 Line & Area Chart

25.9 Line Vs Column Chart

25.10 Tree Map

25.11 Sunburst Chart

25.12 Maps

25.13 Scattered Plot

Quiz

Charts & Graphs

Subtotal & Groups

26.1 Group Rows

26.2 Group Columns

26.3 Subtotal

26.4 Without Sort

Quiz

Subtotal & Groups

Pivot Tables

27. 1 Introduction To Pivot Table

27.2 Sort & Filter In Pivot Table

27.3 Conditional Formating In Pivot Table

27.4 Aggregation In Pivot Table

27.5 Hierarchy In Pivot Table

27.6 Grouping Of Text, Dates & Numbers In Pivot Table

27.7 Style & Style Options In Pivot Table

27.8 Layout Of Pivot Table

27.9 Create Report Filter Pages In Pivot Table

27. 10 Add Slicers & Timeline In Pivot Table

27. 11 Pivot Table Settings

Quiz

Pivot Table

Pivot Chart

28. 1 Introduction To Pivot Charts

28. 2 Formatting A Pivot Chart

28. 3 Slicers & Timeline In Pivot Chart

28. 4 Changing Chart Type In Pivot Chart

Quiz

Pivot Chart

Insert Objects

29. 1 Insert Images

29. 2 Format Images

29. 3 Insert Shape

29. 4 Format Shapes

29. 5 Insert Video

29. 6 Insert PPT & PDF

29. 7 Insert Sparklines

Quiz

Insert Objects

Sheet Formatting

30.1 Split

30. 2 Freeze Panes

30. 3 Hide & Unhide Sheet

30. 4 Comments

30. 5 Custom Views

30. 6 Zoom

Quiz

Sheet Formatting

Preview - Microsoft Excel (Hindi - English)