エクセル - 初級

現在の状態

未登録

価格

Upgrade to Enroll

始める

このコースを受講する

コースコース内容

Section 1 - Excel Beginner

1 - Introduction

Section 2 - Excel Fundamentals

2 - Launching Excel

3 - Start Up Screen

4 - The Excel Interface

5 - The Quick Access Toolbar

7 - Creating New Excel Workbooks

8 - Saving Excel Files

9 - Opening Excel Files

10 - Beginner Shortcut Keys

Section 3 - Entering and Editing Text

11 - Entering Text

12 - Working with Numbers

13 - An Introduction to Dates

14 - Find and Replace

15 - Sorting Data

16 - Working with Cell References

17 - Relative Versus Absolute Cell Reference in Formulas

18 - Understanding the Order of Operation

Section 4 - Basic Excel Functions

19 - The structure of an Excel Function

20 - Working with the Sum Function

21 - Working with Min and Max

22 - Working with Averages

23 - Working with Count and Count A

Section 5 - Modifying an Excel Worksheet

24 - Moving and Copying Data

25 - Inserting and Deleting Rows and Columns

26 - Changing the Width and Height of Cells

27 - Hiding and Unhiding Rows, Columns and Sheets

28 - Renaming Worksheets

29 - Deleting Worksheets

30 - Moving and Copying Worksheets

Section 6 - Formatting Data

31 - Adding Borders to Cells

32 - Formatting Percentages

33 - Merging and Centering Cells

34 - A Quick look at Styles

35 - Basic Conditional Formatting

Section 7 - Images, Shapes and Smart Art

36 - Inserting Images and Shapes

37 - Working with SmartArt

Section 8 - Printing in Excel

38 - Print Preview

39 - Margins, Scaling and Orientation

Section 9 - Templates

41 - Intro to Excel Templates

42 - Opening an Existing Template

43 - Creating a Custom Template

Section 10 - Excel Beginner - Conclusion

44 - Conclusion