One of the many Data Tools in Microsoft Excel is the Office Data Connection (ODC) designed to facilitate the re-use of external data connections. Using this tool one can easily create financial reports that can be updated/refreshed with the click of a few buttons. Excel has three built-in ODC files. All three are web queries: 1) MSN Currency Rates, 2) MSN Major Indices, and 3) MSN Stock quotes. To set-up these built-in ODC files in Excel 2007 open a blank workbook and simply click Data, Get External Data,
About Me
- andrewjordancpa.com
- Andrew J. Jordan, CPA, MSF is a licensed Certified Public Accountant. He achieved a successful career as a CPA, Financial Manager and Consultant for a variety of large and small businesses. Andrew is experienced in creating value for companies in industries ranging from staffing and professional services, retail automotive dealerships, manufacturing and real estate. He also has over 25 years experience assisting individuals and businesses with income tax planning and compliance. Andrew holds a Bachelor of Science degree in Business Administration from Wayne State University in Detroit, MI and a Master of Science in Finance from Walsh College in Troy, MI. His graduate education included significant elective study in Taxation. His services include: Accounting, Tax and Advisory Services. Visit andrewjordancpa.com for more information.
