Being.Shadaan (ExcelWorld)

Use below code to in EXCEL by creating a VBA Code VBA CODE 1 Private Sub CmdSaveThisWorkBook_Click() Application.DisplayAlerts = False         ThisWorkbook.SaveAs Filename:=Range("C4").Value & ":\" & Range("C3").Value & "(" & Format(Now(), "DD-MMM-YYYY hh mm AMPM") & ")" & ".xls", FileFormat:=56 Application.DisplayAlerts = True End Sub VBA CODE 2 Option Explicit Sub saveWork() Dim name As String Worksheets("Sheet1").Select Range("A1").Select  'change range here name = Range("A1").Value  'change range here ActiveWorkbook.SaveAs Filename:="E:\" & name, FileFormat:=50 'change path here '            Format "xls": FileFormatValue = 56 '            Format "xlsx": FileFormatValue = 51 '            Format "xlsm": FileFormatValue = 52 '            Format "xlsb": Fi...

Exact() Function The Excel Exact function tests if two supplied text strings or values are exactly equal and if so, returns TRUE; Otherwise, the function returns FALSE. The function is case-sensitive. Syntax The syntax for the EXACT function in Microsoft Excel is: EXACT( text1, text2 ) Parameters or Arguments text1 and text2 The two string values to compare. Exact Function Examples In the following spreadsheet, the Excel Exact function is used to compare four different pairs of text strings. Formulas: A B C 1 Text Text =EXACT( A1, B1 ) 2 Text text =EXACT( A2, B2 ) 3 5321.222 5321.222 =EXACT( A3, B3 ) 4 0.5 12:00 =EXACT( A4, B4 ) Results: A B C 1 Text Text TRUE 2 Text text FALSE 3 5321.222 5321.222 TRUE 4 0.5 12:00 TRUE Note that, in the above examples: -            As the Ex...

Excel Error Messages If Excel detects that your Excel Formula or Function contains an error, it will return an error message (e.g. #VALUE!, #N/A). The error message that you are presented with, provides information about the type and cause of the Excel formula error. It can therefore assist you with identifying and fixing the problem. The notes below provide a quick reference guide of what each of the different error messages means. ##### When you see ##### displayed in your cell, it can look a little scary. The good news is that this simply means the column isn't wide enough to display the value you've inputted. And that's any easy fix! How to Resolve This Error:   Click on the right border of the column header and increase the column width. Also you can double-click the right border of the header to automatically fit the widest cell in that column. #DIV/0 Excel displays the #DIV/0! error when a formula tries to divide a nu...

Conditional Formatting   Introduction Video: Conditional Formatting Let's say you have a worksheet with thousands of rows of data. It would be extremely difficult to see patterns and trends just from examining the raw information. Similar to charts and sparklines,  conditional formatting  provides another way to visualize data and make worksheets easier to understand. Optional: Download our  practice workbook . Understanding conditional formatting Conditional formatting allows you to automatically apply formatting—such as  colors ,  icons , and  data bars —to one or more cells based on the  cell   value . To do this, you'll need to create a  conditional formatting   rule . For example, a conditional formatting rule might be:  If the value is less than $2000, color the cell red.  By applying this rule, you'd be able to quickly see which cells contain values less than $2000. To crea...

Power Pivot (add-in) - an Introduction PowerPivot is an add-in for Microsoft Excel that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance. Power Pivot is a feature of Microsoft Excel. It is available as an add-in in Excel 2010 and 2013, and is included natively in Excel 2016. PowerPivot extends a local instance of Microsoft Analysis Services Tabular that is embedded directly into an Excel Workbook. This allows a user to build a ROLAP model in PowerPivot, and use pivot tables to explore the model once it is built. This allows Excel to act as a Self-Service BI platform, implementing professional expression languages to query the model and calculate advanced measures...

References Cell reference is nothing but referring to the position of a cell which is available in the same sheet or different sheet or even different workbook. In Excel, each row and column has its own name. Each row is identified by its row number and each column is identified by alphabet. In same way, each cell in Excel has its own name. Such as A1, F26 or W345 - consisting of the column letter and row number that intersect at the cell's location. When listing a cell reference, the column letter is always listed first. One advantage to using cell references in spreadsheet formulas is that, normally, if the data located in the referenced cells changes, the formula or chart automatically updates to reflect the change. If a workbook has been set not to automatically update when changes are made to a worksheet, a manual update can be carried out by pressing the  F9  key on the keyboard. Formulae Refer to = A5 Cell A5 =A1:F4 Cells A1 throu...