5 Reasons why your Excel filter may not be working
Best Excel Keyboard Shortcuts for Beginners | Tips and Tricks
Learn the BEST Excel keyboard shortcuts. Perfect for Beginners and for those who want to save time and work smarter. It doesn&#;t matter if I&#;m delivering a Stage 1 or a Stage 3 Excel training course &#; when I&#;m demonstrating to the class I whip around the screen, format, select and modify and update using shortcut
Insert subtotal rows into sorted data
Learn how to insert subtotal rows into sorted data without having to spend time doing it manually. Recently I ran a training session for an Accounts Manager and her staff. They spent a lot of time pulling data out of their in-house computer system, sorting it by customer and then inserting a new row at every change
Sort an Excel list into numerical, date or alphabetical order
Sort an Excel list into numerical, date or alphabetical order to organise your data into a more useful arrangement. Once you know how to use the Sort command you can organise information so that it&#;s easier to interpret. For example, if you receive a list of purchases made by many different clients on different days of
Sum only visible rows when Filtering data in Excel
A common question I get asked when I&#;m teaching people how to filter data is &#;how do I sum only the visible rows when filtering data in Excel&#;? It&#;s very common for people to try creating a SUM total at the bottom of a list and then filter the data hoping that the total will change
Filter data in Excel
Learning how to filter data in Excel enables you to find and work with just a subset of a larger list or database. Filtering displays only the rows that contain a certain value or that meet a set criteria, while hiding other rows that don&#;t. Once you have filtered your data you can then work with
Excel – How do I change a Pivot Table back to the classic (version and earlier) display?
Learn how to change a Pivot Table back to the classic display of version and earlier. If you were familiar with Pivot tables in Excel versions prior to Excel you will be very used to the classic display of working with the blue lines of the Pivot Table and the ability to drag and
-
-
-