Sandeep Mr Gypsy
Sandeep Mr Gypsy
  • Видео 72
  • Просмотров 58 601
Consolidate Data in MS Excel
This video will teach you how to consolidate data in Microsoft Excel. Consolidation is a powerful tool that allows you to combine data from multiple worksheets or same workbook into a single location. This can be helpful if you need to summarize data from different sources, or if you want to make it easier to analyze and manage your data.
Просмотров: 97

Видео

Learn XLOOKUP in Just 3 minutes
Просмотров 1265 месяцев назад
Hey everyone! In this quick video, we’ll show you how to use XLOOKUP in Excel in just 3 minutes. Whether you’re looking up values in rows or columns, XLOOKUP is a powerful function that makes it simple. Let’s dive in! What is XLOOKUP? XLOOKUP is a versatile lookup function in Excel that allows you to search for a value in one column and return a corresponding value from another column. It repla...
Splitting Data to Multiple Columns
Просмотров 946 месяцев назад
The video shows how to split data from a singe column to multiple columns. This is done by using the Text to Column function via fixed width or delimited. explained with the help of examples in Malayalam
Print Excel Sheets with Headings in every Page
Просмотров 586 месяцев назад
This video depicts on how to keep the headings in each of the sheets while printing a large document in MS Excel which is to be printed in multiple pages. This vide also shows how to keep all the rows & columns in a single sheet while printing
Usage of SUMIF/SUMIFS Formula in MS Excel
Просмотров 11710 месяцев назад
This video will help to learn on how and where to use the SUMIF & SUMIFS formulas in MS Excel. This video is done by using live example to make the learners understand it clearly This is done with Malayalam voice over
Learn the Count Formula in MS Excel with Ease
Просмотров 16111 месяцев назад
This video is all about various COUNT formulas which are used for different instances. this is explained in Malayalam with live example with a comparison to the pivot table
How & When to Use IF & IFS for Data Analysis
Просмотров 70Год назад
This video teaches you when to use the If & Ifs formula in MS Excel. These functions are used when there are multiple iterations. This can be easily understood from this Malayalam class
Gantt Chart - Graphical Representation of Timelines
Просмотров 110Год назад
A Gantt chart is a bar chart that illustrates a project schedule. A Gantt chart is a commonly used graphical depiction of a project schedule. It's a type of bar chart showing the start and finish dates of a project's elements such as resources, planning, and dependencies. In this video the same is explained well in Malayalam with an example of project timelines
Shortcut to find Day, Month & year from Date in MS Excel
Просмотров 121Год назад
This video depicts on how to find the Day, Month & year from the Date in MS Excel. This is the best shortcut in MS Excel to quickly find the segregation of these three using a simple formula. TEXT is used to segregate the same. The video is made with examples in the Malayalam Voice over
Making of DROP DOWN option in MS Excel
Просмотров 242Год назад
This video depicts how to make Drop Down Option in a MS Excel file. Drop Down helps to decrease the errors of typing. it is used when finite data has to be made in that cell. Its very simple but very useful one
Pie Charts - How & When to Use for Data Presentation
Просмотров 127Год назад
The video depicts How to use & when to use the Pie Charts for the Data Presentation. How the data to be formated for the same What kind of analysis we can get it from such charts How to design it You will get all the answers for the above from this video. The video is done by making a using an example in Malayalam
Data Presentation Using Charts - Part 2
Просмотров 1172 года назад
The Video Depicts how to present the Data in MS Excel using the charts. In the series of charts, in this episode you can learn how to use the Column Chart for a data in multiple columns. It also shows that how to change the design, text colour etc. Very useful when you need to graphically shows the data of same kind for multiple years or days
Data Presentation Using Column Chart 1
Просмотров 1372 года назад
The Video Depicts how to present the Data in MS Excel using the charts. In the series of charts, in this episode you can learn how to use the Column Chart for a simple data. It also shows that how to change the design, text colour etc
Finding Duplicates using Shortcut
Просмотров 2342 года назад
Finding Duplicates using Shortcut
Highlight Cells (Colour/Arrows/Dots) using Shortcut
Просмотров 3392 года назад
Highlight Cells (Colour/Arrows/Dots) using Shortcut
Shortcut to find the Days to Expiry in MS Excel
Просмотров 1802 года назад
Shortcut to find the Days to Expiry in MS Excel
How to Find Expiry Date using MS Excel Shortcut
Просмотров 2382 года назад
How to Find Expiry Date using MS Excel Shortcut
Excel Shortcut for Aligning & Cleanup of Data in a Cell
Просмотров 2792 года назад
Excel Shortcut for Aligning & Cleanup of Data in a Cell
Combining Data from multiple cells - Concatenate - Excel Shortcuts for Data Analytics
Просмотров 3222 года назад
Combining Data from multiple cells - Concatenate - Excel Shortcuts for Data Analytics
Find Largest Number - Excel Shortcuts for Data Analytics
Просмотров 3603 года назад
Find Largest Number - Excel Shortcuts for Data Analytics
Find Length - Excel Shortcuts for Data Analytics
Просмотров 3263 года назад
Find Length - Excel Shortcuts for Data Analytics
Roundingoff Numbers in Multiples - Excel Shortcuts for Data Analytics
Просмотров 3053 года назад
Roundingoff Numbers in Multiples - Excel Shortcuts for Data Analytics
ROUNDing OFF DECIMALS - Excel Shortcuts for Data Analytics
Просмотров 2243 года назад
ROUNDing OFF DECIMALS - Excel Shortcuts for Data Analytics
Find Age using MS Excel (Y/M/D)- Shortcuts for Data Analysis
Просмотров 2373 года назад
Find Age using MS Excel (Y/M/D)- Shortcuts for Data Analysis
REFORMAT Data - MS Excel Shortcuts for Data Analytics
Просмотров 3173 года назад
REFORMAT Data - MS Excel Shortcuts for Data Analytics
Rank Formula in Malayalam - Excel Shortcuts for Data Analytics
Просмотров 9943 года назад
Rank Formula in Malayalam - Excel Shortcuts for Data Analytics
Pay Property Tax Online & Download Ownership Certificate - പ്രോപ്പർട്ടി ടാക്സ് ഓൺലൈനിൽ
Просмотров 4143 года назад
Pay Property Tax Online & Download Ownership Certificate - പ്രോപ്പർട്ടി ടാക്സ് ഓൺലൈനിൽ
Remove Duplicates - Shortcuts for Data Analytics
Просмотров 1823 года назад
Remove Duplicates - Shortcuts for Data Analytics
FREEZE the Headings in MS Excel (Malayalam)
Просмотров 5503 года назад
FREEZE the Headings in MS Excel (Malayalam)
Inserting Pictures in MS Excel
Просмотров 2163 года назад
Inserting Pictures in MS Excel

Комментарии