New users have asked me, what is the difference using formulas to calculate a total, or using the AutoSum function. Convenience! Read more »
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-12-14 12:34:25. Republished by Blog Post Promoter
It’s pretty straight-forward using the =Max() function to get the highest value in a range of cells or the =Min() function for the lowest value in a range of cells. But what if you need to get the 3rd largest or the 2nd lowest values in a range of cells? Read more »
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-12-14 12:34:25. Republished by Blog Post Promoter
Opening an Excel workbook displays Sheet1 as the first sheet ready for data. You put another page of information on Sheet2, and add more information to Sheet3. You realize after several sessions that you do more work in Sheet2 than Sheet1. You would like the workbook to open and display Sheet2 ahead of Sheet1 and Sheet3. What do you do. Read more »
Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.
Post Footer automatically generated by Add Post Footer Plugin for wordpress.
Originally posted 2010-12-14 12:34:25. Republished by Blog Post Promoter