Excel – Shree Guru Kripa Software Solution

How to set Chart component? Using MS Excel 2019 and WPS Spread Sheet

By Dr. Abhishek Mishra June 7, 2021Chart, ExcelNo Comments

--Contents-- 00:00 Info 00:15 Prarthna (Good Health for People Around the World) 00:29 Intro 02:17 Axes 03:15 Axes Title 04:10 Chart Title 04:41 Data Labels 05:12 Data Table 05:45 Gridlines…

How to use Various type of Chart? Using MS Excel 2019

By Dr. Abhishek Mishra June 6, 2021Chart, ExcelNo Comments

--Contents-- 00:00 Intro 00:12 Prarthna (Good Health for People Around the World) 02:36 Column Chart 03:40 Line Chart 04:22 Pie Chart 04:49 Bar Chart 05:38 Area Chart 06:03 X Y…

Creating Chart in MS Excel 2019

By Dr. Abhishek Mishra June 5, 2021ExcelNo Comments

--Contents-- 00:00 Intro 00:11 Prarthna (Good Health for People Around the World) 01:36 Create data 02:43 Create Border 04:00 Select Data 05:44 Chose Graph/Chart Type https://www.youtube.com/watch?v=Wky8dCm1bDI

Use Vlookup for Creating Report Card in MS Excel and Spread Sheet By Dr. Abhishek Mishra, part 2

By Dr. Abhishek Mishra June 3, 2021Excel, VlookupNo Comments

00:00 Intro 00:19 Prarthna (Good Health for People Around the World) 00:58 Create Table/Array for Vlookup 02:06 Identify Roll Number 02:33 Use Vlookup for Report Card https://www.youtube.com/watch?v=kMWKwKKffdo

Report Card Design in MS Excel and Spread Sheet By Dr. Abhishek Mishra, part 1

By Dr. Abhishek Mishra June 1, 2021ExcelNo Comments

------------------------------Contents------------------------------ 00:00 Intro (How are you?) 00:07 Prarthna (Good Health for People Around the World) 00:20 Report Card Intro 00:31 Start Creating Report Card 00:52 Creating Report Card Header 01:10…

Functions in MS Excel 2019

By Dr. Abhishek Mishra May 29, 2021ExcelNo Comments

1. Max 2. Min 3. Even 4. Odd 5. Fact 6. Power https://www.youtube.com/watch?v=RttRXsqb8Ks

Function Counta, Countblank, Average and Product (Multiple) in MS Excel 2019

By Dr. Abhishek Mishra May 28, 2021ExcelNo Comments

https://www.youtube.com/watch?v=aHQO7aSuB3w

Sum, Sumif, Count and Countif , in MS Excel 2019 Function

By Dr. Abhishek Mishra May 27, 2021ExcelNo Comments

https://www.youtube.com/watch?v=O2fuFjregKE

Formula and Function in MS Excel 2019

By Dr. Abhishek Mishra May 26, 2021ExcelNo Comments

https://www.youtube.com/watch?v=aCYLuYEeYoQ

Alignment Group in MS Excel 2019

By Dr. Abhishek Mishra May 25, 2021ExcelNo Comments

1. Top 2. Middle 3. Bottom 4. Left 5. Right 6. Center 7. Orientation 8. Decrease Indent 9. Increase Indent 10. Wrap Text 11. Merge & Center https://www.youtube.com/watch?v=JrDYjfzvUF8