エクセル - 中級

現在の状態

未登録

価格

Upgrade to Enroll

始める

このコースを受講する

コースコース内容

Section 1 - Excel - Intermediate

1 - Excel Intermediate Introduction

2 - Intermediate Shortcut Keys

Section 2 - Lists

3 - What are Lists

4 - Sorting a List

5 - Sorting - Multiple Criteria

6 - Custom Sort

7 - What are Filters

8 - Format a List as a Table

Section 3 - DataBase Functions

9 - Introduction to DataBase Functions

10 - DSum Function

11 - DSum Function - Single Criteria

12 - DSum Function - Multiple Criteria

14 - DCount Function

Section 4 - Data Validation

16 - Data Validation - List

17 - Data Validation - Decimal

18 - Input and Error Messages

Section 5 - Importing and Exporting

19 - Importing Data from Text Files

20 - Importing Data from MS Access

21 - Exporting Data to a Text File

Section 6 - Creating Basic Charts

22 - Creating Basic Charts

23 - The Chart Ribbon

24 - Adding and Modifying Data on a Chart

25 - Formatting Charts

Section 7 - Pivot Tables

26 - Understanding Pivot Tables

27 - Creating Pivot Tables

28 - Pivot Table Calculations

29 - Grouping Pivot Table Data

30 - Formatting Pivot Table Data

31 - Drilling Down into Pivot Table Data

32 - Creating Pivot Charts

33 - Filtering Pivot Table Data

34 - Filtering using the Slicer

Section 8 - Working with Large Data

35 - Grouping Data

36 - Consolidating Data

Section 9 - LookUp Functions

39 - Index and Match

Section 10 - Advanced Functions

40 - FV Function

41 - PMT Function

42 - Hyperlinks

43 - Text to Columns

Section 11 - Excel Intermediate - Conclusion

44 - Excel Intermediate - Conclusion