If you have never created Spreadsheets from Scratch then this course is for you. Enter labels, data and Simple Formulas and learn how to efficiently Format, Edit and Print existing spreadsheets. Rounding out the course, participants will create a chart comparing two months of a budgeted expenses. Finally participants will see how quickly Excel can Sort, Filter and Create Subtotals from a list of data.
Working with large worksheets, multiple worksheets and linking worksheets are topics covered. Formulas using Excel’s built-in functions and named cells will be entered. To round out the course participants will learn how to protect data, worksheets and workbooks from unwanted changes as well as how to Track Changes to an existing worksheet. Added features of this course will cover Autoformat, Conditional Formatting, adding Comments and using Hyperlinks to navigate multiple worksheets.
Advanced users of Microsoft Excel will learn to use Excel’s productivity tools such as Goal Seek, Trace Errors, create Macros, build Pivot Tables, produce Scenarios, and use Consolidation to combine data from multiple workbooks. Participants will also learn to customize toolbars and set Excel’s Options.
Participants will explore more advanced Data Base Features of the Excel program including: using a Data Form to enter data, Data Validation, Custom Sorts & Advanced Filters as well as how to Import and Export data in the Excel program. Learn how to use & download existing Templates then create your own Forms using Drop Lists, Check Boxes, Radio buttons, & Spinners. Then learn how to incorporate formulas into the form then Format it and save it as a Template.
Learn how to create more Detailed Charts appropriate for any presentation. Add text, graphic elements, titles, trend lines, then create layered charts and use advanced formatting options to further enhance your charts.