PAPERLESS CONSTRUCT
  • Home
  • Need
  • 3-Steps
    • 1 - Stop Producing
    • 2 - Stop Receiving
    • 3 - Stop Collecting
  • Tech Tips
  • About
    • My Resources

Tech Tips

Get Better EveryDay

Tech Tip Tuesday - Excel - Slice It Up

3/27/2018

0 Comments

 
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

Read More
0 Comments

Tech Tip Tuesday - Excel - Be Special

3/20/2018

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.
Picture
As always if you have any questions, please reach out.

Stay Special,
Ralph

Read More
0 Comments

    Author

    Ralph Kreider strives to help make the construction industry more effective.

    Archives

    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    July 2017
    June 2017

    Categories

    All
    Bluebeam
    Excel
    Outlook
    Skype For Business
    Windows
    Word

    RSS Feed

    View my profile on LinkedIn
  • Home
  • Need
  • 3-Steps
    • 1 - Stop Producing
    • 2 - Stop Receiving
    • 3 - Stop Collecting
  • Tech Tips
  • About
    • My Resources