Module 1: Using Pivot Tables
- Creating Pivot Tables
- More PivotTable Functionality
- Inserting Slicers
- Multi-Select Option in Slicers
- PivotTable Enhancements
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
- Working with Pivot Tables
Module 2: Auditing Worksheets
- Tracing Precedents
- Tracing Dependents
- Showing Formulas
Mobile 3: Data Tools
- Converting Text to Columns
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Using Data Validation
- Consolidating Data
- Goal Seek
- Using Goal Seek
Module 4: Working with Others
- Protecting Worksheets and Workbooks
- Password Protecting a Workbook
- Password Protecting a Worksheet
- Password Protecting Ranges in a Worksheet
- Marking a Workbook as Final
Mobile 5: Recording and Using Macros
- Recording Macros
- Recording a Macro
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
- Adding a Macro to the Quick Access Toolbar
Module 6: Random Useful Items
- Sparklines
- Inserting and Customizing Sparklines
- Using Microsoft Translator
- Preparing a Workbook for Internationalization and Accessibility
- Importing and Exporting Files
- Importing Text Files
- Copying Data from Excel to Word
- Copying Charts from Excel to Word
Module 7: Cloud
- Using the Cloud
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama u toku trajanja kursa
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
Poželjno predznanje:
Before attending this course, students must have:
- Basic and Intermediate Excel experience.
Dalje usavršavanje:
LOOKUP FUNCTIONS (MS50559)