22Nov2014

Excel shortcuts: Tips and tricks to speed up in Excel

Learning Excel keyboard shortcuts will improve your speed and productivity in a big way. Most of the daily routines in the excel worksheets can be done using keyboard shortcuts. This blog contains nearly all the shortcuts which can be helpful while working with Excel. Excel shortcuts and tips:   How to know the Excel shortcut key
  • 22 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Excel Keyboard Shortcuts,
Read more
18Nov2014

INDIRECT function in Excel: How to dynamically refer multiple sheets?

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as follows. Formula Syntax: INDIRECT( ref_text, [a1] ) ref_text can be the range of cells or a named range. [a1] can be TRUE or FALSE. TRUE is used to indicate that ref_text is in R1C1 style
  • 18 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, indirect function in excel,
Read more
13Nov2014

Introduction to Advanced Filter in Excel

Advanced filter in Excel depends on the user defined criteria that can applied to many columns of data. Advanced Filter is used to perform complex filtering which is not possible using the basic auto filter function. To access Advanced Filter, click on DATA tab in Excel ribbon and click on Advanced in sort and filter
  • 13 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • advanced filter, Excel Consultant, Excel Expert,
Read more
11Nov2014

How to apply Conditional formatting in Excel?

Conditional formatting in Excel is used to highlight a cell or value/text in the cell, when certain conditions are met. Conditional Formatting can quickly spot trends and patterns in your data with bars, colors and icons by visually highlights important values. Conditional formatting is based on the cell rules we amend. We can do a
  • 11 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Conditional formatting in Excel, Excel Consultant, Excel Expert,
Read more