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 2016

 

  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 2016

 

  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 2016

 

  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