Skip to main content

About Us

 


About Solutions for MSO

Welcome to Solutions for MSO  – A platform to learn and understand the Microsoft Applications so that it helps you in day to day work. 

Here is what you will find on Solutions for MSO:

  • Tips and Tricks for MS apps.
  • Formulas, Functions, Features of MS apps.
  • Basic to Advanced knowledge
  • FAQ's on MS apps
To learn more visit our official website - Solutions for Data Science

Comments

Popular posts from this blog

Formatting In Excel - helps you find meaning in the spreadsheet

  Formatting In Excel -  helps you find meaning in the spreadsheet  Spreadsheets are often seen as boring and pure tools of utility, but that doesn't mean that we can't bring some style and formatting to our spreadsheets Formatting helps your user find meaning in the spreadsheet without going through each and every individual cell. Cells with formatting will draw the viewer's attention to the important cells. In Excel, formatting worksheet data is easy. You can use several fast and simple ways to create professional-looking worksheets that display your data effectively. For example, you can use document themes for a uniform look throughout all of your Excel spreadsheets, styles to apply predefined formats, and other manual formatting features to highlight important data. Formatting a Data Raw Data   Using Font, Number tabs as shown in image to do a simple formatting   Formatting a Data with help of formatting tools in Excel  As shown in image , we have Prod...

Indirect Function

INDIRECT  is pretty cool for grabbing a value from a cell. Can  INDIRECT  point to a multi-cell range and be used in a  VLOOKUP  or  SUMIF  function?  You can build an  INDIRECT  function that points to a range. The range might be used as the lookup table in a  VLOOKUP  or as a range in  SUMIF  or  COUNTIF . In  Figure , the formula pulls data from the worksheets specified in row 4. The second argument in the  SUMIF  function looks for records that match a certain date from column A. Note:  Because each worksheet might have a different number of records, I chose to have each range extend to 300. This is a number that is sufficiently larger than the number of transactions on any sheet. The formula in cell B5 is: =SUMIF(INDIRECT(B$4&"!A2:A300"), $A5, INDIRECT(B$4&"!C2:C300")) Summary:  You can use  INDIRECT  to grab data from a multi-cell range.

Update All Sheets at same time in a Excel Workbook

Say you have to urgently submit a file with many sheets. For Example put a Header or write a same  data for all sheets. I will show you an amazingly powerful tool called Group mode. Say that you have 12 worksheets that are mostly identical. You need to add totals to all 12 worksheets. To enter Group mode, right-click on any worksheet tab and choose Select All Sheets. The name of the workbook in the title bar now indicates that you are in Group mode. Anything you do to the January worksheet will now happen to all the sheets in the workbook. Why is this dangerous? If you get distracted and forget that you are in Group mode, you might start entering January data and overwriting data on the 11 other worksheets! When you are done adding totals, don’t forget to right-click a sheet tab and choose Ungroup Sheets.