Module 1: Using Pivot Tables
- Creating Pivot Tables
- Inserting Slicers
- Working with Pivot Tables
- Inserting Pivot Charts
- More Pivot Table Functionality
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
- Consolidating Data
- Goal Seek
Module 4: Working with Others
- Protecting Worksheets and Workbooks
- Tracking Changes
- Marking a Workbook as Final
Mobile 5: Recording and Using Macros
- Recording Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Module 6: Random Useful Items
- Sparklines
- Preparing a Workbook for Internationalization and Accessibility
- Importing and Exporting Files
Module 7: Microsoft Excel 2013 New Features
Module 8: Microsoft Excel 2013 New Features
- Using Slicers to Filter Data
- Creating a PivotTable Timeline
- Creating a Standalone PivotChart
- Workspaces in Excel 2013
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:
- Familiarity with using a personal computer, mouse, and keyboard.
- Comfortable in the Windows environment.
- Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.
- Basic Excel 2013 skills.
- Basic understanding of security concepts such as authentication and authorization.
- An understanding of the fundamental principles of using printers.
Dalje usavršavanje:
LOOKUP FUNCTIONS (MS50559)