Which Excel file extension should I use?

Written by kazamraza no comments
Classified in : Miscellaneous Tags : none

Following are some important file types:

XLSX XLSM XLSB XLS CSV

The most common file format is XLSX. The advance users of Excel also use XLSM and XLSB to record and save Macros in Workbook.

Excel file formats

Format

Extension

Description

Excel Workbook

.xlsx

The default XML-based file format for Excel 2010 and Excel 2007. Cannot store Microsoft Visual Basic for Applications (VBA) macro code or Microsoft Office Excel 4.0 macro sheets (.xlm).

Excel Macro-Enabled Workbook (code)

.xlsm

The XML-based and macro-enabled file format for Excel 2016, Excel 2013, Excel 2010, and Excel 2007. Stores VBA macro code or Excel 4.0 macro sheets (.xlm).

Excel Binary Workbook

.xlsb

The binary file format (BIFF12) for Excel 2010 and Excel 2007.

Excel 97- Excel 2003 Workbook

.xls

The Excel 97 - Excel 2003 Binary file format (BIFF8).

XML Data

.xml

XML Data format.

Excel Add-In

.xlam

The XML-based and macro-enabled Add-In format for Excel 2010 and Excel 2007. An Add-In is a supplemental program that is designed to run additional code. Supports the use of VBA projects and Excel 4.0 macro sheets (.xlm).

Excel 97-2003 Add-In

.xla

The Excel 97-2003 Add-In, a supplemental program that is designed to run additional code. Supports the use of VBA projects.

CSV (comma delimited) .csv Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves only the active sheet.

If you receive a file with extention .xls, it means it is Excel 97 - Excel 2003 file format, you can save as this file into new excel file format, i.e, .xlsx. In this way latest functionality is available and file size has also been reduced.

Differences Between Parameters and Arguments

Written by kazamraza no comments

These are used interchangeably, however,A parameter is a variable in a method definition. When a method is called, the arguments are the data you pass into the method's parameters. When a variable is passed to a subroutine or function it is called an argument. The value used in place of the parameter when we make the procedure call is called an argument.

Read more Differences Between Parameters and Arguments

What is text string in Excel

Written by kazamraza no comments
Classified in : Miscellaneous Tags : none

The word text string has been frequently used while writing excel formulas. A text string means, also known as a string or simply as text, a group of characters that are used as data. Text strings are most often comprised of words, numbers, special characters, the dash symbol, or the number sign.

Remember, text strings are left-aligned in a cell while the number data is right-aligned. In some cases, you may notice that number data is left-aligned. IWhen an error is identified, a small green triangle on top left corner in the cell appears, hby selection this cell, here you can see an option/tool tip that give you a short description of the error, clcik on the tool tip to convert this cell value into number.

Read more What is text string in Excel

What is Advance Excel?

Written by kazamraza no comments
Classified in : Miscellaneous Tags : none

Excel is one of the most popular spreadsheet software used by professionals in the world. In my trainings many people ask me what is advance excel? and they come to attend my training only to see that what are the advance tools in excel that make it advance? I am always happy to answer all type of strange questions that my trainees ask me.

Read more What is Advance Excel?

Professional Trainings

Written by kazamraza no comments
Classified in : Miscellaneous Tags : none

EXCEL TRAINING COURSES

  • Advance Excel and VBA
  • Excel Pivot Table and Pivot Charts
  • Excel Dashboards & Reports
  • Excel Programming with VBA
  • Financial Modeling in Excel
  • Financial Model for Business Startup (Feasibility Study Model)
  • Excel for Auditors
  • Advance Excel for ACCA Professionals

 

Read more Professional Trainings