Excel - zaawansowany

Current Status

Not Enrolled

Cena

Żeby uzyskać dostęp należy wykupić rozszerzony plan

Rozpocznij

Zapisz się na szkolenie

Kurs zawartość

Section 1 - Excel - Advanced

1 - Excel Advanced Introduction

2 - Advanced Shortcut Keys

Section 2 - Working with Multiple Workbooks

3 - Tracing Precedents

4 - Tracing Dependants

5 - Watch Window

6 - Show Formulas

Section 3 - Protecting Worksheets and Workbooks

7 - Protecting Cells in a Worksheet

8 - Protecting the Workbook Structure

9 - Encryption with Passwords

Section 4 - Conditional Formulas

10 - Name Ranges

11 - Simple IF Function

14 - Nested Formulas

15 - CountIF and CountIFs

16 - SumIF and SumIFs

Section 5 - Advanced Functions

17 - Advanced VLookUp

18 - IF and IS Error - Part 1

19 - IF and IS Error - Part 2

20 - Advanced Index Match

21 - Dates - Part 1

22 - Dates - Part 2

23 - Replace and Substitute - Part 1

24 - Replace and Substitute - Part 2

Section 6 - Text Based Functions

25 - Left, Right and Mid Function

26 - Search Function

27 - Concatenate and Search

28 - Indirect - Static

29 - Indirect - Dynamic

Section 7 - What IF Tools

31 - Data Tables

Section 8 - Excel Advanced - Conclusion

34 - Excel Advanced - Conclusion

Section 9 - Bonus # 1 - Advanced Pivot Tables

35 - Building a Mini Dashboard