Always at your service to provide the highest level of quality support to our customers.
Anthony Firth Client Engineer
“I’m passionate about building and fostering relationships, and finding solutions for success.”
Michael Koenig Client Account Manager
“Enabling IT to become an effective and valuable partner by delivering premier customer service and quality IT solutions achieving business goals.”
Jake Parrott Business Development Manager
“Serving the client through IT solutions is my passion. A happy client is a happy me.”
Jason RichardsonClient Engineer
“Striving to provide friendly and quality service to our customers”
Ted Rorabaugh Client Engineer
“I help clients stabilize and grow their IT infrastructure so they can focus on growing their core business.”
Josh Wilshire Systems Engineer Team Lead
“Providing courteous, quality IT service for our customers.”
Rich Yoest Rapid Response Team Supervisor
“Striving to be your trusted adviser and IT teammate in accomplishing all your business goals”
Brandan Bishop Client Account Manager
“I strive to provide the highest level of quality service to our customers.”
Tommy Williams Sr. Hardware Engineer
“I’m driven by the steadfast belief that technology must serve as a business enabler. This mantra has driven 21
Years of successful partnerships.”
Stephen Riddick VP Sales & Marketing
“CSP doesn’t succeed unless your company succeeds.”
Stephen Allen Inventory Manager
“Through my intuition and genuine concern to help others I have built long-lasting relationships with our customers, co-workers and business partners.”
Scott Forbes VP Support Services
“Every day, I work with clients to help plan the future of their businesses.”
Michael Bowman vCIO
“Your IT problems become our IT solutions.”
Mark McLemore Project Engineer
“Managing internal and external operations to ensure that CSP provides quality and reliable customer service .”
Margie Figueroa Business Manager
“Helping customers get the most out of their IT Infrastructure.”
Marc Gillet Project Engineer
“Providing quality internal and externals financial support to our customers and accounting support to CSP.”
Katie Steiglitz Accounting Administrator
“Your satisfaction is our #1 priority.”
Heather Moore Project Manager
“Some call me the CEO. I call myself the Cheerleader for an awesome team!”
William B. Riddick Founder & CEO
“CSP is here to assist you with your IT needs.”
Beth Wylie Inside Sales Manager
Thinking ofHiring A New IT Company?
On What Questions You Need To Ask Before Signing Any Agreement.
Keep values separate and in their own cells. Never put values in your formulas. Anytime you’re trying to make changes to your formula, it will be a lot more difficult if you’ve included values. This is more complex than having formulas that reference and link to cells.
Do this from the top ribbon, CLICK on the column itself and change the width from the popup, or
DOUBLE CLICK the column that takes the column to the largest column width possible.
ANCHORING VALUES IN FORMULAS
Say you want Price X Units Sold. In your spreadsheet, you have a column specifying your ACCOUNT, UNITS SOLD, REVENUE:
Select the REVENUE column and clear out any content
Go to NO FILL, NO BORDERS
Click on the CELL you want to use as the ANCHOR and HIT F4
This will anchor the cell
No matter what you do in other cells, this will stay consistent.
POPULATE CELLS With FORMULAS
You can DRAG the bottom right of the formula, DOUBLE CLICK and it will automatically populate the cells with the data you put in the formula.
If you have hundreds or thousands of lines of data, how do you get to the bottom of your spreadsheet without scrolling and scrolling?
Hit CONTROL and ARROW DOWN (on the bottom right of your keyboard) and it will take you to the bottom of your spreadsheet.
When you want to go back to the top hit CONTROL and ARROW UP.
CONTROL and PERIOD will let you jump back and forth between the top and bottom.
Cell + Cell + is the long way to do this.
EQUAL SUM Feature: Type in SUM, drag over the data you want to sum and it will calculate this.
AUTO SUM Feature in the top ribbon: Put the Mouse underneath the data hit ENTER and the Sum will appear in the cell.
SEE HIDDEN DATA
Select your cells and go to WRAP TEXT in the top ribbon and leverage the NAVIGATION WINDOW. The data you couldn’t see will now appear.
Go to PROPER and enter the account name you want.
( ) + TRIM will take away spaces you don’t want.
To Get Data Back:
COPY and PASTE Values rather than Formulas.
COPY values >PASTE SPECIAL and paste the VALUE, or
RIGHT CLICK the MOUSE, HOLD and DRAG DATA where you want.
QUICKLY COPY TEXT
ENTER TEXT, e.g. “January” DOUBLE CLICK and Excel is smart enough to populate cells with the rest of the months.
ENTER UN-IDENTICAL INFORMATION INTO NON-ADJACENT CELLS
SELECT which cells you want to enter data in
CONTROL+ENTER the number of clients you added, and all the cells you selected will populate.
DATE YOUR WORK
SELECT the cell you want
= TODAY or
= NOW to always show the current date
For more information on Excel Tips or IT Services and Support contact: