17Jul2015

Grouping Checkboxes in Excel

Grouping checkboxes will help to keep the checkbox values discrete. We may also need to group the checkboxes in order to move or resize them as per requirement. Grouping helps to take control on all checkboxes at a time.   Grouping checkboxes in Excel: After inserting checkboxes onto the worksheet. Select all check boxes as

• 17 Jul, 2015
• Excel for Commerce
• 0 Comments
• Excel Consultant, Excel Expert, grouping checkboxes in excel,

Read more

25Jun2015

Text to Columns in Excel

Text to Columns in Excel are used to split a single column of text into multiple columns. This feature is helpful when we import data from word, PDF or any other source. As the imported data may not be usable right away. We can split the text based on fixed width or split it at

• 25 Jun, 2015
• Excel for Commerce
• 0 Comments
• Excel Consultant, Excel Expert, Text to Columns,

Read more

01Jan2015

How to sort horizontally in Excel? (from left to right)

Sorting horizontally in Excel: Sorting horizontally in excel (from left to right) is required when we have a table/data as shown in the image below. In the below image, we want to sort horizontally based on employee name. This blog explains how to sort multiple columns horizontally from left to right. Let’s take a sample

• 1 Jan, 2015
• Excel for Commerce
• 0 Comments
• Excel Consultant, Excel Expert, Sort horizontally in Excel,

Read more

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

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

09Oct2014

Is Wrap text not working in Excel? Read the following blog by Excel Expert.

Is wrap text not working in Excel? The reason is Microsoft Excel cannot wrap merged cells automatically. We need to follow a few steps to make the wrap text work in Excel. Go ahead and read the blog to see how the issue can be resolved. Step 1: Merge the cells and enter the text In this

• 9 Oct, 2014
• Excel for Commerce
• 0 Comments
• Excel Consultant, Excel Expert, Merge cells, Wrap text,

Read more