1. Latest News
  2. Submit Press Release
  1. PR Home
  2. Latest News
  3. Feeds
  4. Alerts
  5. Submit Free Press Release
  6. Journalist Account
  7. PRNewswire Distribution

Help with Microsoft Excel Macros

As a Property Management Company, Microsoft Excel is one of your most important tools.

 
PRLog - Dec. 16, 2012 - As a Property Management Company, Microsoft Excel is one of your most important tools.  Most programs including accounting software such as Intuit Quickbooks and many of the other major brands export items to Excel.  With that being the case, often times people develop different tasks that are completed inside Excel.  The bigger the tasks, often times the longer it takes to complete, and the more steps that are involved.  Using Macros inside Excel are a way to complete many of these tasks quicker and easier.

http://www.inventivepm.com

In order to use a Macro, first you have to record the steps that you want done.  First inside Microsoft Excel select tools, and then click on Macros, then select "Record New Macro".  You will need to choose a name for the Macro in case you ever need to alter it or remember what it does in the future.  Next you will select a shortcut, which is basically what you will press in order to run the Macro.  For instance, if each morning you get a sales report that is the same, you could have the shortcut be the Ctrl key plus "s".  Essentially your Macro can now automatically format your sales report in to a customized table, re-size you columns for you, and automatically sort the report as you choose.



To finish up the Macro, after you have named it and picked out a shortcut, select ok and now Excel is recording the actions you take.  Therefore if you wanted to have a function as mentioned above that will take data and auto format it, simply pull your data into your spreadsheet and go through your steps as you normally would.  Once completed, stop the recording of the Macro.  The next step is to delete all of you data to leave yourself with a blank spreadsheet and save this workbook as a Macro Enabled Workbook.

From now on, every time you get this sales report open your saved Macro Enabled Workbook, drag in your data and simply hit ctrl + "s", and now your data automatically is formatted exactly how you want.

http://www.inventivepm.com

--- End ---

Click to Share

Contact Email:
***@inventivepm.com Email Verified
Source:Inventive Property Management
Phone:336-374-8984
Zip:27021
City/Town:Winston-Salem - North Carolina - United States
Industry:Real Estate
Tags:excel, macros, help, property management, spreadsheet macros
Last Updated:Mar 11, 2013
Shortcut:prlog.org/12044087
Disclaimer:   Issuers of the press releases are solely responsible for the content of their press releases. PRLog can't be held liable for the content posted by others.   Report Abuse

Latest Press Releases By “

More...

Trending News...



  1. SiteMap
  2. Privacy Policy
  3. Terms of Service
  4. Copyright Notice
  5. About
  6. Advertise
Like PRLog?
9K2K1K
Click to Share