Microsoft Excel for Business Management

LEARNING UNIT 1. THE EXCEL ENVIRONMENT AND THE RIBBON General Concepts The Excel Environment Saving and Opening Documents LEARNING UNIT 2. BASIC TASKS WHEN WORKING WITH DATA Working with Data Getting Started Entering Data Inserting, Deleting, and Moving Undo and Redo Spell Check LEARNING UNIT 3. BASIC AND CONDITIONAL FORMATTING Data Presentation Heading Formats Background Conditional Formatting Styles and Themes Protecting a Worksheet LEARNING UNIT 4. WORKING WITH FORMULAS I Introduction to Formulas What Is a Formula? Automatic Calculations Editing Formulas Names and Titles LEARNING UNIT 5. WORKING WITH FORMULAS II Introduction to Functions What Is a Function? Entering Functions Categories of Functions LEARNING UNIT 6. PRINTING AND SHARING SPREADSHEETS Printing or Publishing Printing Publishing LEARNING UNIT 7. GRAPHING DATA Creating a Chart Customizing the Chart LEARNING UNIT 8. WORKING WITH DATA SPREAD ACROSS MULTIPLE SHEETS Data Across Multiple Sheets Invoice Template 3D References Managing Worksheets in a Workbook References to Other Workbooks LEARNING UNIT 9. LISTS AND DATA TABLES Entering Data Sorting and Grouping Data Filtering Data Data Tables LEARNING UNIT 10. HOW TO RECORD AND USE MACROS Introduction to macros What is a macro? Recording sequences of actions Assigning a macro to a button Defining new functions Macros and security LEARNING UNIT 11. INTRODUCTION TO DATA VISUALIZATION What Is Data Visualization? The Importance of Data Visualization and Related Tools Data Visualization: Basic Principles LEARNING UNIT 12. POWER BI Introduction to Power BI Installing Power BI Data Modeling Data Visualization Dashboards Sharing Data