Resume of Jeff Stritar

Jeffrey D. Stritar, CPA

1824 Olive Road

Homewood, Illinois 60430

Home: (708) 799-1429 Cell: (708) 921-5412

Web: http://resume.jeff.stritar.com

E-Mail: jeff@stritar.com

Home >>> Recent Classes, Seminars and Training

As a life long learner, I take pride in enhancing my skill sets. The following listing is a partial presentation of recent classes, seminars and training I have undertaken.

Accounting
	Fiduciary Responsibilities - Seminar discussing the legal and moral obligations of a fiduciary.
Human Resources
	OSHA Record Keeping - Seminar discussing OSHA requirements for records to be maintained and reporting requirements.
Information Technology
	Excel Certification Class - Getting Started with Excel 2007 Course Objectives Spreadsheets and Excel 2007 match basic Excel 2007 features with their functions recognize how to use the Help feature in a given scenario Create and Navigate Workbooks in Excel 2007 create a new Excel workbook in a given scenario open an existing Excel workbook in a given scenario navigate through an Excel workbook Enter Data and Text in Excel 2007 enter data in an Excel worksheet in given scenario Save Work in Excel 2007 save a new workbook distinguish between the common file formats used to save work in Excel 2007 Creating and Saving a Workbook in Excel 2007
	Excel Certification Class - Manipulating and Formatting Data and Worksheets within Excel 2007 Course Objectives Copy and Move Data in Excel 2007 copy or move data in given scenarios Modify Rows and Columns in Excel 2007 add, delete, or resize rows and columns in a given scenario modify rows and columns to view specific sections of the worksheet Insert and Modify Worksheets in Excel 2007 format workbooks in given scenarios insert and delete a worksheet rename a worksheet and format the tab color copy or move worksheets Working with Data and Workbooks in Excel 2007 Copying and Moving Data and Worksheets Format Data in Excel 2007 apply basic data formatting format a data range as a table change the position of data in a cell in a given scenario identify the functions of Alignment commands Format Data as a Table in Excel 2007 work with tables in Excel 2007 format a data range as a table modify an Excel table Format Numbers in Excel 2007 apply number formats in a given scenario identify the number formatting options available in Excel 2007 Conditional Formatting in Excel 2007 apply basic conditional formatting rules in a given scenario recognize situations when conditional formatting is suitable Formatting Data in Excel 2007 Formatting Data and Workbooks in Excel 2007
	Excel Certification Class - Reviewing and Printing in Excel 2007 Course Objectives Excel 2007 Review Features use Excel 2007 review tools in a given situation work with comments use the track changes tool Reviewing a Workbook in Excel 2007 Prepare an Excel 2007 Worksheet for Printing customize page setup using the Page Layout View adjust page breaks using the Page Break Preview Print Options in Excel 2007 print a worksheet in a given scenario Changing Page Setup and Printing in Excel 2007
	Excel Certification Class - Formulas and Functions in Excel 2007 Course Objectives Basics of Formulas and References in Excel 2007 identify the elements of a formula identify the default order in which calculations occur match absolute, relative, mixed, and 3-D references with examples Insert Formulas in Excel 2007 insert an Excel 2007 formula use names to clarify formulas edit formulas Entering a Formula with References in Excel 2007 Perform AutoCalculate Functions in Excel 2007 use the AutoCalculate feature to perform basic functions Logical, Financial, and Date Functions in Excel 2007 use a logical function use a financial function use a date function Inserting Functions in Excel 2007 Using Formulas and Functions in Excel 2007
	Excel Certification Class - Charts, Pictures. Themes and Styles in Excel 2007 Course Objectives Using Charts in Excel 2007 insert an Excel 2007 chart identify the main elements of a chart Updating Charts in Excel 2007 change Excel 2007 charts change the data range included in the chart move a chart to a new worksheet Adding Charts to Workbooks in Excel 2007 Insert Illustrations in Excel 2007 insert illustrations in Excel 2007 Use Excel 2007 Themes and Styles apply a theme apply a cell style Adding Visual Elements to Excel 2007 Applying Styles and Themes in Excel 2007
	Excel Certification Class - Advance Formatting in Excel 2007 Course Objectives Format Charts in Excel 2007 format chart elements in Excel 2007 identify Chart Tools commands for customizing chart elements save and apply a chart template Modify Pictures in Excel 2007 use the Adjust formatting commands to modify a picture recognize the commands for formatting a picture's style format a picture's size and properties Modifying Charts and Pictures Create and Edit Excel 2007 Custom Number Formats create a custom number format identify codes for custom number formats Use Advanced Conditional Formatting in Excel 2007 create a new conditional formatting rule recognize how conditional formatting cell precedence works find cells that have conditional formats Creating Custom and Conditional Formats in Excel 2007 Using Advanced Formatting in Excel 2007
	Excel Certification Class - Advanced Data Management in Excel 2007 Lesson Objectives Sorting and Filtering Data in Excel 2007 sort data filter data in a range or table Subtotal, Group, and Outline Data in Excel 2007 group and outline data insert subtotals in a worksheet display different levels of data using outlines Subtotaling, Filtering, and Grouping Data in Excel 2007 Organizing Worksheet Data Validate Data in Excel 2007 specify the data that is allowed in a particular range recognize which error alert to use in given examples Audit and Correct Formulas in Excel 2007 locate and correct formula errors use the Watch Window to audit formulas Formula Auditing and Data Validation in Excel 2007
	Excel Certification Class - Advanced Customization in Excel 2007 Course Objectives Creating Templates in Excel 2007 create an Excel template Customizing Themes and Styles in Excel 2007 create new cell styles in Excel 2007 customize Excel 2007 themes Customizing Workbook Settings in Excel 2007 customize workbook settings change the workbook properties Customizing Excel 2007 Workbooks Record and Run an Excel 2007 Macro record and run a macro match macro security settings with their effects Work with Excel Macros edit and delete macros assign a button to a macro and add it to the Quick Access Toolbar Recording a Macro in Excel 2007
	Excel Certification Class - Analyzing Data in Excel 2007 Course Objectives PivotTable Reports in Excel 2007 create a PivotTable report rearrange PivotTable data Excel 2007's PivotTable Tools customize PivotTable reports modify the look and feel of a PivotTable report PivotChart Reports in Excel 2007 create a PivotChart report modify a PivotChart report Calculations in Excel 2007 PivotTables Reports perform calculations in PivotTables reports recognize when to use each calculation type Creating PivotTable Reports in Excel 2007 Creating PivotChart Reports for Data Analysis Work with Goal Seek and Solver in Excel 2007 use Goal Seek to perform data analysis use Solver to perform data analysis Create Scenarios in Excel 2007 create scenarios for what-if analysis use the Scenario Manager to modify scenarios Create a Data Table and Project Values in Excel 2007 create a one-variable data table for data analysis create a two-variable data table for data analysis project values in a series Use Advanced Functions in Excel 2007 perform advanced functions match advanced functions with examples of when you would use them consolidate data from different workbooks using a Summary function Performing Advanced Data Analysis in Excel 2007
	Excel Certification Class - Protecting and Sharing Workbooks in Excel 2007 Course Objectives Worksheet and Workbook Protection in Excel 2007 protect a workbook in a given example apply worksheet protection in a given example Authenticate Workbooks with Excel 2007 identify the features of digital signatures in Excel 2007 Protecting Workbooks in Excel 2007 Share Workbooks in Excel 2007 share workbooks on a network location merge shared workbooks Publish Excel 2007 Workbooks to SharePoint publish a workbook to a SharePoint library perform basic actions using SharePoint Sharing Workbooks Among Multiple Users in Excel 2007
	Excel Certification Class - Exchanging Data with Excel 2007 Course Objectives Link, Import, and Embed Data in Excel 2007 create links to data identify how to import data embed a file in a workbook Create Database Queries in Excel 2007 create database queries in Excel 2007 import an entire Access table Import Excel 2007 Data into Other Applications import Excel data into Access copy Excel data to Word import Excel data into Outlook Working with Data from Other Applications in Excel 2007 Retrieving External Data with Excel 2007 Introduction to XML in Excel 2007 identify how XML works in Excel recognize the components of a basic XML system Work with XML Data in Excel 2007 create an XML map and map elements to it import XML data export XML data into mapped cells Using XML Data in Excel 2007

Prepared by Jeff Stritar

Updated Decmber 3, 2010