Call Us!
Sales: (604) 239-4283
|
Get Support
|
info@compunet.ca
IT Support For Vancouver Law Firms IT Services For Vancouver Law Firms Vancouver Legal IT Services
  • Managed It Services
  • Cybersecurity
  • Cloud Solutions
Close
Legal IT Support in Vancouver
  • Architecture
    • IT Management
    • Cloud Solutions
    • Software Support
    • Cybersecurity Solutions
  • Law Firms
    • Technology Management
    • Digital Transformation
    • Software Support
    • Cloud Services
    • IT Security
    • Cybersecurity Management
    • Ransomware Prevention
  • Accounting
    • Managed IT Services
    • Cloud Services
    • Ransomware Removal
    • Ransomware Protection
  • Engineering
    • Managed IT
    • Cloud
    • IT Security
    • Ransomware Removal
  • Cybersecurity Services
    • Microsoft MFA
    • Microsoft 365 Secure
    • Microsoft Office Protect
    • Network Security
    • Endpoint Protection
    • Dark Web Protection
  • About Us
    • How We Work
    • Why Choose Us
    • Case Studies
    • Our Blog
    • Is This You?
    • Five-Star Feedback
    • Careers
    • Referral Program
  • Where We Serve
    • Greater Vancouver
    • Burnaby
    • Langley
    • Surrey
    • North Vancouver
    • New Westminster
  • Contact Us
    105-135 East 15th Street
    North Vancouver, BC V7L 2P7
    (604) 986-8170 info@compunet.ca
    Get Support

Do You Excel at Excel? — Ten Steps To Help You Do So.

If you aren’t using Excel you’re missing out one of the most versatile applications in the Microsoft Office Suite.  You can use Excel spreadsheets to simplify an extensive variety of tasks —To organize, plan, calculate, and more. Specialists with an in-depth knowledge of Excel use it to develop customized proposals, contracts and other documents.  Artists […]

Start A Conversation

If you aren’t using Excel you’re missing out one of the most versatile applications in the Microsoft Office Suite.  You can use Excel spreadsheets to simplify an extensive variety of tasks —To organize, plan, calculate, and more.

Specialists with an in-depth knowledge of Excel use it to develop customized proposals, contracts and other documents.  Artists even use Excel to produce digital art.

In addition, Excel spreadsheets can be used in conjunction with programs like Access. Excel possesses many capabilities that aren’t apparent to most users.

The following are some tips that can save you time, and help you use Excel.

1.  Easily jump to the start or end of a column.

If you are deep into a spreadsheet, and you want to move to the first or last cell of a column, use CTRL + ↑ to jump to the top cell, or CTRL + ↓ to drop to the last cell.

2.  SUM() with ALT + =

  • This function adds a column or row of numbers.  Simply click in the first empty cell of a column.
  • After this, enter ALT + = (equals key) to add the numbers in every cell above.

3.  Adjust The Width of One or More Columns

Click on the column’s header, —Move your cursor to the right side of the header, and “double click” when you see the + sign.

4.  Add To, or Delete Columns 

Managing columns and rows can be a tedious task. You can save time by using CTRL + ‘-‘ (minus key).  This deletes the column, and CTRL + SHIFT + ‘=’ (equal key) adds a new column.

5.  Display Formulas with CTRL + `

When troubleshooting, display the formula in a cell by using Ctrl + ` ( ` is furthest to the left on the row with the number keys).

6.  Format Numbers

To format a number as currency, use CRTL + SHIFT + 4 (+4 is the same at the $ symbol). Do the same when formatting a number as a percent, — use CRTL + SHIFT+ 5 (+5 is the % symbol).

7.  Move Between Worksheets

To jump to a worksheet, on the right enter CTRL + PGDN.  Conversely, enter CTRL + PGUP  to move to the worksheet to the left.

8.  Replicate a Formula in Multiple Cells

You can easily reproduce the same formula again and again, and populate all of the cells in a column with the same formula while adjusting them to use the data specific to each row.

Simply create the formula in the first cell. Then move your cursor to the lower right corner of that cell and, when it turns into a + sign, “double-click” to copy the same formula into the remaining cells in that column. The cells in the column will exhibit the results of the formula using the data in that row.

9.  Reproduce Patterns and Dates

You can do this by entering information in two rows to establish a pattern.  Simply highlight these rows and drag down the cells to populate rows. This works with any symbol or items displayed in the cells.

10.  Copy a Format Into Multiple Cells

Simply “double click” Format Painter. This tool lets you duplicate a format in other cells. You can also use use this feature to copy the format into multiple cells.

For more information about Excel, and how you can use it to save time and improve your day-to-day efficiencies, contact Compunet InfoTech at (604) 986-8170 , or email us at: info@compunet.ca

Schedule Your No Obligation Initial Consultation Now

Complete this short form and schedule your no obligation 10-minute introductory phone call with Compunet Information. A member of our team will reach out immediately.

Latest Blog Posts

Should Your Vancouver Law Firm Marie Kondo Its Data?
Should Your Vancouver Law Firm Marie Kondo Its Data?
Read More
KeePass Security Exploit
KeePass Security Exploit
Read More
What is the Canadian Equivalent of HIPAA?
What is the Canadian Equivalent of HIPAA?
Read More
Read The Compunet Blog

Architecture

  • IT Management
  • Cloud Solutions
  • Software Support
  • Cybersecurity Solutions

Legal

  • Technology Management
  • Digital Transformation
  • Software Support
  • Cloud Services
  • IT Security
  • Cybersecurity Management
  • Ransomware Prevention

Accounting

  • Managed IT Services
  • Cloud Services
  • Ransomware Removal
  • Ransomware Protection

Engineering

  • Managed IT
  • Cloud
  • IT Security
  • Ransomware Removal

Cybersecurity Services

  • Microsoft MFA
  • Microsoft 365 Secure
  • Microsoft Office Protect
  • Network Security
  • Endpoint Protection
  • Dark Web Protection
Compunet infonech

Compunet InfoTech offers Managed IT Support & Hosted IT Services For Vancouver & Surrounding Areas. Serving Vancouver, Burnaby, Richmond, Surrey, Coquitlam and New Westminster.

105-135 East 15th Street
North Vancouver, BC V7L 2P7

(604) 986-8170
info@compunet.ca

  • About Us
  • Why Choose Us?
  • Media Center
  • Vancouver IT Consulting News
  • Testimonials
  • Greater Vancouver
  • Burnaby
  • North Vancouver
  • Langley
  • Surrey
  • New Westminster

© 2023 Compunet InfoTech. All Rights Reserved.

Sitemap | Privacy Policy | Website Accessibility
Attention North Vancouver Businesses: Are You Worried About Your IT Services Provider?

Get A Free Second Opinion Today from Compunet.

Our comprehensive assessment includes:

  • A thorough analysis of your current IT company’s performance
  • A customized action plan to tackle all operational issues
  • A detailed budget and project plan for seamless execution

Don’t let IT issues hold back your business. Gain the clarity you need to get your IT on the right track. With our no-obligation, risk-free assessment, you have nothing to lose. Contact Compunet now.

Interested?
Schedule Your Initial Consultation with Compunet Today.

Schedule Your Initial Consultation With The Compunet Team.

Fill in your information below to get started today.