Shelly Cashman Series® Microsoft® Office 365® & Excel® 2019 Comprehensive

Steven M. Freund serves as a lead instructor of various Microsoft® Office, computer concepts, programming and internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series® since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, MOZILLA FIREFOX, WINDOWS® INTERNET EXPLORER, WINDOWS® OFFICE and DREAMWEAVER books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida. Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S.

• Excel Module 1: Creating a Worksheet and a Chart.Excel Module 2: Formulas, Functions, and Formatting. Excel Module 3: Working with Large Worksheets, Charting, and What-If Analysis.Excel Module 4: Financial Functions, Data Tables, and Amortization Schedules.Excel Module 5: Working with Multiple Worksheets and Workbooks.Excel Module 6: Creating, Sorting, and Querying a Table.Excel Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images, and Screenshots.Excel Module 8: Working with Trendlines, Pivot Table Reports, PivotChart Reports, and Slicers.Excel Module 9: Formula Auditing, Data Validation, and Complex Problem Solving. Excel Module 10: Data Analysis with Power Tools and Creating Macros.Excel Module 11: User Interfaces, Visual Basic for Applications (VBA), and Collaboration Features in Excel.