Kurz PC course - training Microsoft Excel Basics

This Excel course is designed for users who want to operate a spreadsheet application.

Minimálne vstupné vedomosti: Nepredpokladajú sa žiadne konkrétne vstupné vedomosti.

Osnova školenia PC course - training Microsoft Excel Basics

• Excel fundamentals and its usage in practice
• Excel environment introduction: cell, row and column coordinates, formula tab, active cell, navigating in Excel
• Opening and saving Excel sheet
• Basic settings, most common tool bars, worksheets, build-in help
• Basic cell operations - Non Contiguous/Continuous Range in Excel
• Cell operations: copy, paste, move, insert of row and column, cell alignment
• Basic operations with worksheets – add, rename, remove
• Paste – special function and its usage
• Data types and format cells: text, number, currency, time, date, fractions, percentage
• Text and table Alignment & formatting – font selection, alignment, border, background, pattern
• Table auto-format and its settings
• Copy-format function – most common usage
• Effective and quick usage of basic functions (sum, average, count, min, max)
• Insert functions into cells with relative cell reference
• Auto filter function – simple examples, customized auto filter, wildcards in text specification
• Carts and Graphs basics
• Print – sheet settings, print preview, page setup, margins, header and footer

Výstupné vedomosti: operating in Excel; basic functions, possibilities and Excel abilities. Effective solving of sheet tasks; basics of charts and graphs and simple printing settings.

Odporúčané kurzy pre absolventov školenia PC course - training Microsoft Excel Basics

• Kurz IT Training - Microsoft Excel for advanced

Zobraziť všetky kurzy z kategórie Kurzy Excel

Neváhajte nás kontaktovať ohľadom ďalších informácií a požiadaviek na kurz PC course - training Microsoft Excel Basics: