Advanced Excel 2021

LEARNING UNIT 1. BASIC CONCEPTS Interface Elements Entering and Editing Data Formatting Working with Multiple Sheets Creating Charts Customization Help: An Important Resource LEARNING UNIT 2. DATA EDITING AND FORMULAS Data Types Entering Data Cell References Formatting LEARNING UNIT 3. TABLES AND DATA LISTS Initial Data Totaling and Summarizing Filtering and Grouping Data Pivot Tables Data Tables LEARNING UNIT 4. DATA ANALYSIS Configuring Analysis Tools Tables with Variables Functions for Forecasting Scenario simulation Goal seeking The Solver tool Other data analysis tools TEACHING UNIT 5. DATABASES Retrieving data Editing databases Database functions XML mapping LEARNING UNIT 6. CHARTS AND DIAGRAMS Creating charts Inserting mini-charts Customizing maximum and minimum values Inserting shapes Images Graphic elements and interactivity SmartArt LEARNING UNIT 7. PUBLISHING DATA Printing worksheets Publishing Excel workbooks LEARNING UNIT 8. LOGICAL FUNCTIONS Relationships and logical values Decision-making Nesting expressions and decisions Conditional operations Selecting Values from a List LEARNING UNIT 9. DATA SEARCH Manipulating References Searching for and Selecting Data Transposing Tables LEARNING UNIT 10. OTHER FUNCTIONS OF INTEREST Text Manipulation Working with Dates Miscellaneous Information TEACHING UNIT 11. ACCESSING EXTERNAL FUNCTIONS Recording External Functions Calling Functions Excel 4.0-Style Macros Workbooks with Macros LESSON 12. MACROS AND FUNCTIONS Recording and playing back macros Managing macros Defining functions LESSON 13. INTRODUCTION TO VBA The Visual Basic Editor The Code Editor The Immediate Window A Practical Example LEARNING UNIT 14. VARIABLES AND EXPRESSIONS Variables Expressions LEARNING UNIT 15. CONTROL STRUCTURES. THE EXCEL OBJECT MODEL Conditional Values Conditional Statements Loop Structures Core Excel Objects Other Excel Objects LESSON 16. DATA MANIPULATION Selecting a Data Table Manipulating Data Inserting New Data The Complete Solution LESSON 17. DIALOG BOXES Predefined dialog boxes Custom dialog boxes A More Attractive and User-Friendly Macro Launching the Dialog Box LEARNING UNIT 18. GROUP WORK Sharing a Workbook Comments on Data Track Changes Review Tools LEARNING UNIT 19. DOCUMENTS AND SECURITY Restricting Access to a Document Digital Security TEACHING UNIT 20. CUSTOMIZING EXCEL Settings for workbooks and worksheets Environment options The Ribbon Creating custom tabs and groups