Prerequisite: The student must have mastered the topics presented in the PowerPoint Introduction course or equivalent.
The objective of this course is to learn the features that will enhance the slides in your presentations and those features that will assist you during presentations, including how to:
· Create and edit Data Charts, Organization Charts or SmartArt
· Animate charts to focus audience attention
· Use drawing tools and Draw tab to enhance slides
· Edit and format drawn objects on slides
· Animate drawn objects on slides
· Add hyperlinks
· Add sound and video
· Use the Slide Master and Title Master view to edit an existing template
· Add Action Buttons to control the movement through slides
· Create sophisticated handouts by exporting to Word
MS Excel Introduction
Prerequisite: The student must have mastered the topics presented in the Windows Introduction Class or equivalent.
The objective of this course is to learn the features that help you create a basic spreadsheet with elementary formulas, including how to:
· Identify the Excel window features
· Enter and edit text and numbers in a workbook
· Enter and edit simple formulas (addition, subtraction, multiplication, division, and summing)
· Insert and delete rows and columns
· Move and copy text, numbers, and formulas
· Format the appearance of a workbook
· Save, open and begin new workbook files
· Print and preview a workbook
MS Excel Charts
Prerequisite: Prior to attending this course, please complete and master the topics covered in the Intermediate Excel course. Basic keyboarding and mouse skills are helpful.
The objective of this course is to learn how to use the chart feature in Excel, Word, and PowerPoint including how to:
· Creating a chart on a separate sheet or on a worksheet with other data or charts.
· Choose the correct chart type for the data.
· Change chart type.
· Format axis, titles, legends, data series, and data series.
· Change the data source.
· Create stacked column, line-column, column charts with no –axis, actual vs. budget, trend line, last six or twelve months (rolling data), comparative histograms, and progress towards goal charts.
· Print charts.
· Create and edit a chart in Word and PowerPoint.
· Linking Excel data to a Word or PowerPoint chart.
Intro to Dakota County GIS
Dakota County GIS is for everyone! You don’t have to be a GIS ”user” or have any previous GIS experience. Do you ever work with geographic or location based data such as clients, service areas, or property? Have you ever needed to know where something was, or whether it was near an area where you were working? Would it be useful to know if other departments were involved in projects adjacent to yours? Dakota County GIS is a web-based GIS that allows city and county staff to explore a variety of county and regional data. Dakota County GIS is available to all city and county staff, and provides access to much more than just property information. With access to 300+ datasets, it is possible to identify geographical relationships and determine whether entities around the county may have an impact on your work. Having all staff access the same GIS means that everyone is working from the same information. In this hands-on course you will learn how to access county data, look up parcel information, view air photos & Pictometry imagery, measure distances and areas, create custom site maps, generate mailing labels, and much more.