When working with Excel spreadsheets there are four steps I always go through before starting with anything.
First off what I do is apply filters. With big tables there is always some filtering needed — Under Home tab and Editing section choose Sort & Filters and then click on Filters.
Continue readingThere are 2 ways to do it. First you can go to top of the table and an arrow will appear. When you click then entire column is chosen.
Second way is to click on the table cell and table tools will appear. Choose layout tab. In table section click on Select and choose Column.
You can also assign keyboard shortcut to that command if you use it often.
Continue readingFirst unhide the columns. If you want to copy the whole table then to unhide all the columns hidden, simply select the entire worksheet and click on the column labels with your right mouse button and choose “Unhide”. When this is done, select and copy the data. Afterwards use the „Undo” command to hide all the columns that were unhiden. Now paste the previously copied data.
Continue readingMove to View tab and right on the left there’s a button labeled as Ruler. Tap and drag the slider until it’s green.
Continue readingIf for some reason you find out that the current layout is not fitting your needs, you have the opportunity to change it under Home tab in Slides section. Click on “Layout” and select another more appropriate from the menu.
Continue readingSimply drag it off the slide and it will not be visible during your show.
Continue readingSelect the cells you want to be analyzed and go under Home tab into Styles section. Choose the first button from the row called “Conditional Formatting”. From there choose “Highlight Cell Rules” and “Greater Than …” From the new menu choose the amount from which the cells are formatted and from the right sided drop-down menu select the style you wish to apply. Notice that some only apply to text or background whilst others format both of those. If you are satisfied, click on “OK”.
Continue reading