Excel 2016 Training in English.

Materiały na stronie są udostępnione do wykorzystania niekomercyjnego, jeżeli chcesz je wykorzystać do szkolenia w firmie, napisz do autora.

Kurs w języku angielskim jest w budowie, najważniejsze lekcje są już udostępnione.

Contact Author Excel 2003 Excel 2007 Excel 2013 PL

Excel for Beginners 1. Introduction 2. First Formulas 3. Copying 4. Formatting 5. Printing 6. Find and Replace 7. The Status Bar 8. Sorting 9. Conditional Formatting 10. Freeze Panes and Split 11. Graphs for Beginners 12. Filtering 13. Beginner Functions 14. Grouping and Auto Outline 15. Remove Duplicates 16. Sharing Your Workbook 17. Keyboard Shortcuts 18. Formula Auditing 19. Relative and Absolute Cell References 20. Working with Multiple Spreadsheets

Excel for Advanced 1. The Most Useful Excel Formulas 2. Lookup and Reference Functions 3. Password Protection 4. Advanced Graphs 5. Advanced Functions 6. Data Validation 7. Quick Access Toolbar 8. Customize the Ribbon 9. Custom Lists 10. Pivot Tables for Beginners 11. Advanced Pivot Tables 12. Pivot Charts 13. Form Controls 14. Professional Reports 15. Advanced Professional Reports 16. Tips and Tricks 17. The Slicer 18. Sparklines 19. Array Formulas and Functions 20. Excel Job Interview Tests

Excel for Experts 1. Graphs for Experts 2. Functions for Experts 3. Tables 4. Pivot Tables for Experts 5. Tips and Tricks 1 6. Goal Seek 7. The Solver 8. Mathematical Graphs 9. Tips and Tricks 2 10. Advanced Filtering 11. Compatibility Mode 12. Proofing 13. Matrix 14. Queries 15. File Formats 16. Analysis ToolPak

Visual Basic for Applications (VBA) 1. Recording Macros 2. Introdution to VBA 3. If Then Instruction 4. Select Case Instruction 5. MsgBox Function 6. InputBox Function 7. Macros that Start Automatically 8. "Do While" Loop 9. "Do Until" Loop 10. "For Next" Loop 11. "For Each Next" Loop 12. Creating Functions 13. Arrays 14. Nested Loops 15. Variables Declaration 16. VBA Forms 17. Next Steps for VBA