Fri 18 Nov 2016

Article 43 - Optimize, Troubleshoot and Improve Performance in Excel (non VBA)

By |Friday, November 18th, 2016|Categories: Articles|Tags: , , , , , , , |0 Comments

Below points will help you in following to optimize your excel sheet

  1. Reduce time taken to calculate / recalculate
  2. Reduce time taken to open / close workbook
  3. Reduce file size

Below points may not be valid in many circumstances so you will have to see the suitability of a recommendation but most of the time, these will be valid. Also, in this article we would not concentrate on “WHY” but “WHAT”.

(more…)

Mon 14 Sep 2015

Solution - Challenge 23 – Make Bar Chart to Show Performance

By |Monday, September 14th, 2015|Categories: Solutions|Tags: , , , , |0 Comments

-- The solution workbook related to this challenge solution can be downloaded from Solution - Challenge 23 – Make Bar Chart to Show Performance --

Below is a possible solution to the challenge Challenge 23 – Make Bar Chart to Show Performance

1. Download the workbook from Salesman Performance Challenge
2. Select range A1:C7
3. Insert > Chart > Choose the appropriate bar chart. You will get the chart like below -

(more…)

Sat 15 Aug 2015

Challenge 23 - Make Bar Chart to Show Performance

By |Saturday, August 15th, 2015|Categories: Challenges|Tags: , , , , |1 Comment

This time challenge is to create a bar chart like below to show the Target Planned and Target Achievement.

Related Excel you can download here Salesman Performance Challenge

Salesman Performance

You may post your solution in comments section.

Note - Solution to this challenge will be published after 1 month i.e. on 14-Sep-15.