Often when I look at an Excel file, it just has way too much information. Rows upon rows of data. How do I make heads or tails of it? Lately, I have been using tables and slicers to assist in the sorting and filtering of my data. The great thing about tables and slicers is that I can quickly get down to the granularity level that I need. I also don't need to create as many tabs as I can filter the data. Please follow the steps below to create your first table and slicer. As always, reach out if you have any questions. Always Advancing,
Ralph
0 Comments
We often use excel to organize and communicate the data. Unfortunately, this sometimes takes manually copying and pasting from one file to another. And often the data is not quite in the format we need and my format is all messed up. Excel (and many other office products) have many special pasting features that allow you to format the data just as you would like. These options are found simply by right clicking on the area you want to paste the data, and then clicking on "Paste Special.."(Also using Ctrl+Alt+V). Try out values and transpose. They have saved me hours over the years. As always if you have any questions, please reach out.
Stay Special, Ralph When using Excel have you ever needed a long heading to appear in two lines within a single cell? It just overlaps the cell next to it. You might already know that can use "Wrap Text", but have you ever wanted to control where the "wrap" occurs? Another way to wrap text in a single cell is to create a "line break" in a cell by pressing "Alt + Enter" to start a new line. You can create as many lines as you want. See the example below. Excel has many other great keyboard shortcuts to make our lives a little easier. Below is a list of some that you can test and adapt for your own use. Hopefully, the shortcuts help you to work more efficiently and effectively!
As always, if you have any questions or comments please feel free to reach me out. Keep Excelling! Ralph Kreider Have you ever been working in excel file with multiple tabs, and you have to reference multiple tabs for a report. Most of us, just constantly flip back and forth between two or three tabs, spending more jumping between tabs than actually digesting the data in the excel file. Well there is a really simple way to reduce this switching back and forth by opening the same excel file in multiple windows. Simply click view > New Window This will open a new window of the same excel that can be dragged over to another screen. You know that you have multiple windows open because there is a "1" or "2" next to the file name. Another cool feature is that when you close the file (file > close) and reopen it, Excel remembers you are using multiple windows. Note: this is not a new instance of excel. Therefore if you update data or a formula that is referenced on another tab, it will update throughout all windows.
As always reach out if you have a questions, Keep Advancing, Ralph |
AuthorRalph Kreider strives to help make the construction industry more effective. Archives
June 2018
Categories
All
|