Accounting in Excel: Tips and Tricks for Success | Michael McVinney
Contact Michael McVinney, a NY licensed Real Estate Broker. Michael McVinney is also licensed in PA.
Bemus Point NY condos for sale,Ashville NY condos for sale,Lakewood NY condos for sale,Mayville NY condos for sale,Jamestown NY condos for sale,Falconer NY condos for sale,Ellicotville NY condos for sale,Fredonia NY condos for sale,Chautauqua NY condos for sale,Lakefront condos for sale,Bemus Point NY fsbo,Ashville NY fsbo,Lakewood NY fsbo,Mayville NY fsbo,Jamestown NY fsbo,Falconer NY fsbo,Ellicotville NY fsbo,Fredonia NY fsbo,Chautauqua NY fsbo,Lakefront fsbo,Bemus Point NY home for sale,Ashville NY home for sale,Lakewood NY home for sale,Mayville NY home for sale,Jamestown NY home for sale,Falconer NY home for sale,Ellicotville NY home for sale,Fredonia NY home for sale,Chautauqua NY home for sale,Lakefront home for sale,Bemus Point NY real estate license,Ashville NY real estate license,Lakewood NY real estate license,Mayville NY real estate license,Jamestown NY real estate license,Falconer NY real estate license,Ellicotville NY real estate license,Fredonia NY real estate license,Chautauqua NY real estate license,Lakefront real estate license,Bemus Point NY real estate agent,Ashville NY real estate agent,Lakewood NY real estate agent,Mayville NY real estate agent,Jamestown NY real estate agent,Falconer NY real estate agent,Ellicotville NY real estate agent,Fredonia NY real estate agent,Chautauqua NY real estate agent,Lakefront real estate agent,Bemus Point NY realty,Ashville NY realty,Lakewood NY realty,Mayville NY realty,Jamestown NY realty,Falconer NY realty,Ellicotville NY realty,Fredonia NY realty,Chautauqua NY realty,Lakefront realty,Bemus Point NY for sale,Ashville NY for sale,Lakewood NY for sale,Mayville NY for sale,Jamestown NY for sale,Falconer NY for sale,Ellicotville NY for sale,Fredonia NY for sale,Chautauqua NY for sale,Lakefront for sale,Bemus Point NY homes for sale by owner,Ashville NY homes for sale by owner,Lakewood NY homes for sale by owner,Mayville NY homes for sale by owner,Jamestown NY homes for sale by owner,Falconer NY homes for sale by owner,Ellicotville NY homes for sale by owner,Fredonia NY homes for sale by owner,Chautauqua NY homes for sale by owner,Lakefront homes for sale by owner,Bemus Point NY foreclosed homes,Ashville NY foreclosed homes,Lakewood NY foreclosed homes,Mayville NY foreclosed homes,Jamestown NY foreclosed homes,Falconer NY foreclosed homes,Ellicotville NY foreclosed homes,Fredonia NY foreclosed homes,Chautauqua NY foreclosed homes,Lakefront foreclosed homes,Bemus Point NY real estate school,Ashville NY real estate school,Lakewood NY real estate school,Mayville NY real estate school,Jamestown NY real estate school,Falconer NY real estate school,Ellicotville NY real estate school,Fredonia NY real estate school,Chautauqua NY real estate school,Lakefront real estate school,Bemus Point NY mls listing,Ashville NY mls listing,Lakewood NY mls listing,Mayville NY mls listing,Jamestown NY mls listing,Falconer NY mls listing,Ellicotville NY mls listing,Fredonia NY mls listing,Chautauqua NY mls listing,Lakefront mls listing,Bemus Point NY buying a house,Ashville NY buying a house,Lakewood NY buying a house,Mayville NY buying a house,Jamestown NY buying a house,Falconer NY buying a house,Ellicotville NY buying a house,Fredonia NY buying a house,Chautauqua NY buying a house,Lakefront buying a house,Bemus Point NY townhomes for sale,Ashville NY townhomes for sale,Lakewood NY townhomes for sale,Mayville NY townhomes for sale,Jamestown NY townhomes for sale,Falconer NY townhomes for sale,Ellicotville NY townhomes for sale,Fredonia NY townhomes for sale,Chautauqua NY townhomes for sale,Lakefront townhomes for sale,Bemus Point NY homesearch,Ashville NY homesearch,Lakewood NY homesearch,Mayville NY homesearch,Jamestown NY homesearch,Falconer NY homesearch,Ellicotville NY homesearch,Fredonia NY homesearch,Chautauqua NY homesearch,Lakefront homesearch,Bemus Point NY houses for sale by owner,Ashville NY houses for sale by owner,Lakewood NY houses for sale by owner,Mayville NY houses for sale by owner,Jamestown NY houses for sale by owner,Falconer NY houses for sale by owner,Ellicotville NY houses for sale by owner,Fredonia NY houses for sale by owner,Chautauqua NY houses for sale by owner,Lakefront houses for sale by owner, contact Michael McVinney, Real Estate Broker Michael McVinney, NY Real Estate Broker, NY Real Estate Agent, NY Realtor, Michael McVinney
post-template-default,single,single-post,postid-18128,single-format-standard,bridge-core-1.0.6,ajax_fade,page_not_loaded,,qode-title-hidden,side_area_uncovered_from_content,qode-child-theme-ver-1.0.0,qode-theme-ver-18.2,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.0.5,vc_responsive

Accounting in Excel: Tips and Tricks for Success

This post originally appeared on tBL Marketplace Partner LeaseQuery’s blog Your Lease Queries, Answered and is republished with permission. Find out how to syndicate your content with theBrokerList.

Why Excel?

If you’ve ever tried to format your spreadsheets in Excel, you know that it can be time-consuming. Businesses of all sizes and across industries rely on it to collate their data and to see the bigger picture. Though we know that Excel is limited when it comes to lease accounting, we still know that many accountants use it in tandem with a lease accounting software, especially to export reports.

We interviewed a few of our in-house accountants to get an idea of how they use Excel. These tips can help you move faster in the program and handle your reporting with ease. Most of the tips below use hotkeys, which are keyboard shortcuts that help you do the things you need in Excel quicker.

The fundamentals

Andrew McCown, Sr. Manager of Technical Accounting stated his best tip was Alt + CTRL + V, V (for values) + Enter = Paste, which allows you to paste only copied values, not formulas. Another shortcut he uses to copy data or functions down a specific column is to “double click the little black box in the corner of a cell with formulas to automatically copy them down the column.”

Jason Parker, one of our Technical Accounting Managers, uses hotkeys whenever he uses Excel: “I’m a big hotkeys guy.”

What hotkey tips does he recommend? “Pressing the ‘Alt’ key will allow you to select the different header tabs within Excel by touching the appropriate letter key. For example, Alt + H brings up the ‘Home’ tab keys.
Alt + H + B will bring up the ‘borders’ feature, and Alt + H + B + T will produce the thick black underline in the selected cell.”

Additionally, Jason recommends using Alt + H + 1 to bold something, Alt + H + 2 for italics, and Alt + H + 3 to underline.

Griffin Larkin, another Technical Accounting Manager, offers “easy tips” to help you navigate Excel using hotkeys:

  • CTRL + down arrow (or any arrow) will highlight the entire column or row of data.
  • CTRL + C = copy
  • CTRL + V = paste
  • CTRL + X = cut
  • CTRL + Z = undo last function
  • CTRL + Y= redo last function

Getting it in formation

If you’ve ever spent time attempting to format your spreadsheets in Excel, you know that it can be time-consuming. Rachel Reed, another member of our Technical Accounting team, has a few tips to help with formatting in Excel. “Pressing the ‘Alt’ key, then H will bring you to the home menu, then you can navigate through the commands… some of my favorites for formatting:”

  • Alt + H + H + N removes the background color of a cell
  • Alt H + F + P format painter- will take whatever format you have on that cell (colors, text size, font, etc.) and copies it so you can apply to other cells
  • Holding Alt and + then enter will sum the numbers in the column above
  • Control shift and then an arrow will highlight either the row or the column
  • Alt + A + T will apply a filter

Ryan Stowe & David Dobson, two of our Lease Accounting Managers, collaborated on their answers. To keep your spreadsheets looking good, they recommend:

  • Alt + H + O + I = autofit column width
  • Alt + H + O + A = autofit column height
  • Ctrl + space = highlight column
  • Shift + Space = highlight row
  • Alt + E + S = paste special menu
  • Index + Match Functions = to match and return items from a range of items
  • Indirect Function = use cell value in a formula
    Ctrl + G = go to specific cells
  • Named ranges = reference cell ranges by name rather than address
  • F4 = toggle between locked cells

When you need to multitask

Often, our accountants are working on multiple Excel spreadsheets at once, or are using multiple applications to get the job done. Amanda Payne, another member of our Technical Accounting team, has a few go-to tips when she needs to work on multiple amortization schedules at once.

  • Ctrl + Page Up/Page Down = allows you to move from sheet to sheet within the Excel file
  • Alt + W + F + F = allows you to freeze all cells above the cursor
  • Alt + I + R = lets you add a new row by selecting the row below where you want to add the new row
  • Alt + I + C = lets you add a new column by selecting a column to the right of where you want to add the new column
  • Alt + H + B + U = this creates the summation line (a single line at the top of the cell and double line at the bottom of the cell)
  • Alt + H + B + N = clears all borders from a cell

If you need to toggle between your spreadsheets and the internet, Amanda recommends using Alt + Tab, which allows you to move to different applications open on the screen.

Bringing it together

Companies across industries rely on Excel to collate their data and perform basic tasks. We know that when it comes to tracking your leases, Excel may not be the most robust system to use. However, most lease accounting systems allow for integration with Excel where you can export your amortization schedules, reporting, and more. These tips should help you manage your Excel spreadsheets and keep them looking streamlined and professional. For more tips and help, contact the LeaseQuery team today to learn more or check out our Lease Accounting Tools page, where we have several free Excel calculators and spreadsheets to make your lease accounting easier.

Talk to One of Our Expert Lease Accountants Today

RSS Feed provided by theBrokerList Blog – theBrokerList for commercial real estate brokers (cre) and Accounting in Excel: Tips and Tricks for Success was written by Lease Query.