Excel Tips and Tricks, Part 2

This class will present a series of tips and shortcuts that will help you work more efficiently and complete more complex tasks with Microsoft Excel. You’ll learn how to assign range names to groups of cells and how to use range names in formulas and functions.
You'll practice working with multiple spreadsheets in a workbook, including navigating large workbooks, grouping sheets for quick editing and formatting, and creating 3-D formulas that span several sheets. You'll learn how to lock and protect a sheet and how to add comments for review.
The class will also cover converting lists to tables, concatenating and separating text, and creating a drop-down list for data entry. The class will then focus on several useful Excel functions: Payment, If, Iferror, Vlookup, Round, CountIf and SumIf. Finally, you'll learn how to record a simple macro to automate repetitive tasks, and how to assign it to a button the Quick Access Toolbar. A complete list of keyboard shortcuts is also included.

Review: Quick Tips Quick Access Toolbar Using AutoFill Selecting Cells and Ranges Using Absolute References Format Painter Using Range Names Naming Multiple Ranges Working with Multiple Sheets Navigating Multiple Sheets Grouping Sheets for Editing and Formatting 3-D Formulas Editing a Spreadsheet Adding Comments Locking and Protecting Tables Formatting a List as a Table Formulas in Tables

Working with Text Text to Columns Concatenate Text Flash Fill Data Validation Validation Options Adding a Drop-Down List Functions PMT IF IFERROR VLOOKUP ROUND COUNTIF / SUMIF AND / OR Macros Recording a Simple Macro Keyboard Shortcuts

rtcuts

Pre-registration is required; space is limited.

To Register:  https://goo.gl/forms/pX8YUuC25YdMsLjD2