Calendar module icon

Calendar

View All Calendars is the default. Choose Select a Calendar to view a specific calendar. Subscribe to calendar notifications by clicking on the Notify Me® button, and you will automatically be alerted about the latest events in our community.

Date:
April 7, 2020
Time:
8:00 AM - 5:00 PM
Location:
Tech Services Training Room
Address:
Park in the City Hall Parking Lot
Plano, TX, TX 75074
Facebook Twitter Email

MS 2016 Excel Level Two- (City of Plano Employees Only)

Tuesday, April 7, 2020

This intermediate level Excel course provides lab intensive activities including financial functions, data tables, amortization schedules, and hyperlinks; creating, sorting and querying a worksheet database; and creating templates and working with multiple worksheets and workbooks. Course Outcomes: The trainee will be able to: • Apply the PMT function to determine a monthly payment • Apply the PV function to determine the amount due on a loan at the end of a year • Add a hyperlink to a web page • Use names to reference cells • Analyze data by goal seeking, creating a data table and creating an amortization schedule • Create subtotals • Find, extract and delete records that pass a test • Apply database and lookup functions • Build and copy a template, multiple worksheets and 3-D cell references • Customize formats, styles and charts • Use WordArt • Add notes to cell • Add a header/footer • Create and modify lines and objects • Change page setup characteristics • Find a