Plan obuke:
Module 1: Creating a Microsoft Excel Workbook
- Starting Microsoft Excel
- Creating a Workbook
- Saving a Workbook
- The Status Bar
- Adding and Deleting Worksheets
- Copying and Moving Worksheets
- Changing the Order of Worksheets
- Splitting the Worksheet Window
- Closing a Workbook
Module 2: The Ribbon
- Tabs
- Groups
- Commands
Mobile 3: The Backstage View (The File Menu)
- Introduction to the Backstage View
- Opening a Workbook
- Open a Workbook
- New Workbooks and Excel Templates
- Select, Open and Save a Template Agenda
- Printing Worksheets
- Print a Worksheet
- Adding Your Name to Microsoft Excel
- Adding a Theme to Microsoft Excel
Module 4: The Quick Access Toolbar
- Adding Common Commands
- Adding Additional Commands with the Customize Dialog Box
- Adding Ribbon Commands or Groups
- Placement
- Customize the Quick Access Toolbar
Mobile 5: Entering Data in Microsoft Excel Worksheets
- Entering Text
- Adding and Deleting Cells
- Adding a Hyperlink
- Add WordArt to a Worksheet
- Using AutoComplete
- Entering Text and Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
- Entering Numbers and Dates
Module 6: Formatting Microsoft Excel Worksheets
- Selecting Ranges of Cells
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Customize a Workbook Using Tab Colors and Themes
- Adding a Watermark
- The Font Group
- Working with Font Group Commands
- The Alignment Group
- Working with Alignment Group Commands
- The Number Group
- Working with Number Group Commands
Module 7: Using Formulas in Microsoft Excel
- Math Operators and the Order of Operations
- Entering Formulas
- AutoSum (and Other Common Auto-Formulas)
- Copying Formulas and Functions
- Relative, Absolute, and Mixed Cell References
- Working with Formulas
Module 8: Working with Rows and Columns
- Inserting Rows and Columns
- Deleting Rows and Columns
- Transposing Rows and Columns
- Setting Row Height and Column Width
- Hiding and Unhiding Rows and Columns
- Freezing Panes
- Working with Rows and Columns
Module 9: Editing Worksheets
- Find
- Find and Replace
- Using Find and Replace
- Using the Clipboard
- Using Format Painter
- Managing Comments
Module 10: Finalizing Microsoft Excel Worksheets
- Setting Margins
- Setting Page Orientation
- Setting the Print Area
- Print Scaling (Fit Sheet on One Page)
- Printing Headings on Each Page/Repeating Headers and Footers
- Headers and Footers
- Preparing to Print
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
Dalje usavršavanje:
Intermediate Microsoft Excel 2019 (MS55269)
Advanced Microsoft Excel 2019 (MS55270)