excel skills for interpreting your data for finance presenter: mary martin
TRANSCRIPT
![Page 1: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/1.jpg)
Excel Skills for Interpreting Your Data for Finance
Presenter: Mary Martin
![Page 2: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/2.jpg)
Welcome
![Page 3: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/3.jpg)
3
• Using Excel with Finance Reports
• Creating and working with PivotTables
• Final Questions
Agenda:
![Page 4: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/4.jpg)
Using Excel with Finance Reports
![Page 5: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/5.jpg)
5
Using Excel with Finance Reports
• I have an Excel spreadsheet with Finance information for my department.
– How can organize the information on the spreadsheet to get the answers I need?
![Page 6: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/6.jpg)
6
Using Excel with Finance Reports
• To sort your information (by Emp Type for this example)
Click on any single cell within the range to be sorted
Click the Data tab and select Sort
Select Emp Type from the Sort by drop-down list
Click OK
![Page 7: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/7.jpg)
7
Using Excel with Finance Reports
• To get a count of a specific itemNote: Begin by sorting your report by job code description
Highlight all rows for a specific Item
The count displays at the bottom of the Excel file
![Page 8: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/8.jpg)
8
Using Excel with Finance Reports
• To subtotal your informationNote: Begin by sorting your report (by EMP Type for this example)
Click the Data tab and select Subtotal
Complete the Subtotal box as shown here, then click OK.
The system inserts a subtotal for each job code description
![Page 9: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/9.jpg)
9
Using Excel with Finance Reports
![Page 10: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/10.jpg)
Creating and Working with PivotTables
![Page 11: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/11.jpg)
11
Creating and Working with PivotTables
• PivotTables can be used to reorganize and summarize information from an Excel spreadsheet– The information should be in a list– There can be no gaps or blank rows– There can be no extra information around the list
![Page 12: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/12.jpg)
12
Creating and Working with PivotTables
![Page 13: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/13.jpg)
13
Creating and Working with PivotTables
• Sign on to Lynda.com using your Onyen– http://software.sites.unc.edu/lynda
• Brush up on your Excel skills– For example, learn more about pivot tables
• The courses are broken down into chapters consisting of several short tutorials (5 minutes or less)– Lynda.com keeps track of the courses you are working on, which
makes it easy to break your learning into multiple sessions
![Page 14: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/14.jpg)
14
Find slides, parking lot questions and other materials on ccinfo.unc.edu
For After the Conference
![Page 15: Excel Skills for Interpreting Your Data for Finance Presenter: Mary Martin](https://reader036.vdocuments.us/reader036/viewer/2022070413/5697bfbb1a28abf838ca0e04/html5/thumbnails/15.jpg)
Final Questions