Microsoft Excel, Fundamentals

1004 South Pine Street,Spartanburg SC 29302

20 April, 2021

Description

This hands-on class covers the core features and shortcuts needed to create and update professional-looking worksheets. It is designed for anyone who wishes to gain a foundational understanding of Excel whether they are truly new to its use or simply wish to “fill in the gaps” of their knowledge. Special emphasis will be given to taking the mystery out of formulas and functions. Class format will provide time for the instructor to recommend best practices, explain new concepts, introduce shortcuts, and answer questions. Participants will have time to practice apply new skills to realworld scenarios without feeling rushed or frustrated. TOPICS Navigating and performing common tasks in Excel, such asopening, viewing, editing, saving, and printing worksheetsUsing best practices and shortcuts in ExcelQuickly selecting cells, ranges, columns, rows, sheets & multiplesLocating common and hidden commands in the RibbonCustomizing the Quick Access Toolbar on the flyBuilding worksheets from scratchUnderstanding how math is done in an Excel spreadsheetConverting written formulas into Excel formatApplying the Order of Operations to multi-step equationsIdentifying Excel functions and deciphering their syntaxApplying the 6 most common functions to various scenariosReusing a single formula across multiple rows or columns withoutintroducing addressing errorsModifying worksheet data and structure quickly and easilyUsing the Paste Special command to transform dataControlling the appearance of worksheets through formattingManaging three-dimensional, multi-sheet/tab workbooksPrinting workbook contentsINSTRUCTOR Barb Hansen ATTENDANCE Registered participants who fail to attend a class ('no-shows') will be charged full class cost. The 'no-show' fee may not be used as a credit for another EN class, or other type of event or service. A 'late notice' charge (50% of the class fee) will be charged for cancellations made less than 48 hours before the scheduled class starting time. The 'late notice' charge may not be used as a credit for another EN class. or other type of event or service.