Next Live Training Date:

11-15 May, 8-12 June

Excel Automatic Sort

Excel automatic sort is an important tool… with Excel you’re going to have to sort out data many times, be it a few entries or hundreds of entries.

Let’s look at what you should do, remembering that for any help, there is always us at AuditExcel, so you certainly don’t need to feel frustrated or feel like giving up. Automatic sort in Excel is very handy and saves you time.

Numeric values:

Numeric values, including things like date and time are sorted from lowest to highest.
Excel automatic sort doesn’t consider the format of the cell, only its contents. Date and time are sorted by their numeric values.

Text:

Text is sorted first by ASCII characters, such as *, (,),  and then by letters of the alphabet. Uppercase text is sorted before lowercase text. To sort using case sensitivity: from the Data menu, select Sort, then Options, and then select the Case Sensitive option.

By downloading Excel Training, you can watch video clips within the example spreadsheet and you can try Excel automatic sort as you watch… there is training material to be purchased, and there are consultants with expert advice.  With Audit Excel you can’t go wrong; trust in us… we’ll sort you out!

Handy Tips & Tricks

Repeat a calculation in excel using Data Tables

Repeat a calculation in excel using Data Tables A common requirement in business is to repeat a calculation in excel many times. Depending on how you built the spreadsheet this could be as easy as just copying the formulas down or … Continue reading

Ctrl END arrow versus CTRL arrow

Ctrl END arrow versus CTRL arrow As a rule we prefer to navigate through a big spreadsheet using the CTRL and arrow buttons. If you are not aware of it, if you click on the first cell in a range, … Continue reading

...Not only did I learn a lot about Access on this course, but I also gained quite a few useful Excel skills. The fact that Jonny is an accountant meant that he understood the daily challenges with data in a finance role...

– Excel with access- Hannover Re

Video Library & Tutorials //

View Entire Video Gallery ››

Tables in Excel for PowerPivot use

Tables in Excel for PowerPivot use

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Some of our Featured Clients