When working with large chunks of data, we sometimes need to sort the data to figure out where we need to focus our attention. This could mean that we need to quickly sort our data by more than one column, allowing us to make decisions on which path to take, without having to create new Excel template in that moment.
There are a number of ways to sort data in Excel, but using the Sort command (located on the Data tab of the ribbon) is the easiest, as the sort order you see is the sort order you get. The nice thing about the dialog box used for the Sort command is that it is easy to add, delete, or rearrange sort levels. Other methods of sorting data, ones in which you do not use the Sort dialog box, can cause issues, can be more problematic, especially if you try to undo and redo the sorting at a later time.
Having column headers makes the whole process easier, but sometimes raw data downloaded from a database does not give us column headers. The good news is that it does not keep you from sorting your data, as there is an option checkbox for data without headers, but you must know which columns to sort when this happens.
Want to learn more ways that Excel can make your work easier? Check out what MCT has available for you in our Excel course series:
[ Ссылка ]...
Some of the things that make us different:
Our training classes are live and instructor led - Our instructors are in the room with you, leading the class, and are available to answer questions face-to-face. We do not use blended training or mentored learning, in which an instructor video conferences into the room or proctors eLearning.
For computer classes, we provide the computers for you to use during the class. All you need to bring is yourself. We supply the rest!
We provide hard copy training manuals so you can take notes during class, and take them with you for future reference. Many of our classes also come with a Quick Tip sheet, for quick reference of the more commonly used topics from the class.
Free retakes – need a refresher on the topics you learned in class? You can retake your class up to 6 months from your original class date you attended.
Free workshops – many of our computer classes qualify for free workshop time, where you can get instructor assistance with your own projects. Its free consulting to help you apply what you learned to your own work.
Small class sizes – we don’t believe in cramming 100+ people into a hotel conference room. All of our classrooms max out at 12 to 16 students. So you can get more individual attention.
Check out our website for more information on our training programs:
[ Ссылка ]
Not in the Denver or Phoenix markets? Prefer to train your employees at your facility instead of at one of our training centers? We can bring our skills and expertise to your organization. Contact our sales office for more information on our private training options:
[ Ссылка ]...
training@mcstech.net
(303) 900-0850
(602) 955-7787
Training that is relevant to your job - We teach you the stuff you can actually use. Twice the knowledge in half the time. Learn more. Retain more. Use more.
Ещё видео!