Tutorial For Excel 2013

Excel中2013教程。需要使用Microsoft Excel幫助嗎？你已經找到了正確的應用

A huge list of tutorials for you!!

=================================

1 Excel 2013 Tutorial - Basic Graph

2 Excel 2013 Tutorial - Copy, Cut, Paste (paste without formatting)

3 Excel 2013 Tutorial - Order of Evaluation (Precedence)

4 Excel 2013 Tutorial - Introduction to Formulas (and Inserting and Deleting Rows and Columns)

5 Basic Tasks in Excel 2013 - Part 1

6 Basic Tasks in Excel 2013 - Part 2

7 Excel 2013 Tutorial - Basic Formatting Part 1

8 Excel 2013 Tutorial - Basic Formatting Part 2

9 Excel 2013 Tutorial - Number Formatting

10 Excel 2013 Tutorial - Personalizing the Environment Using the Backstage

11 Excel 2013 Tutorial - Force Printing on One Page and Navigating the Worksheet

12 Excel 2013 Tutorial - Auto Fill (linear and growth)

13 Excel 2013 Tutorial - More Practice with Basic Formulas (and format currency)

14 Excel 2013 Tutorial - Referencing Worksheets in Formulas (and change Tab Color)

15 Excel 2013 Tutorial - Mail Merge (Ticket Numbers)

16 Excel 2013 Tutorial - Basic Excel Word Mail Merge

17 Excel 2013 Tutorial: Protecting Cells and Worksheets

18 Excel 2013 Tutorial - How to add Password Protection

19 Excel 2013 Tutorial - How to Hide and Unhide Columns

20 Excel 2013 Tutorial - Named Ranges

21 Excel 2013 Tutorial - Format as Table

22 Excel 2013 Tutorial - Sparklines

23 Excel 2013 Tutorial - Freeze Panes (freeze one or more columns)

24 Excel 2013 Tutorial - Conditional Formatting (data bars,color scales,icon sets)

25 Excel 2013 Tutorial - Comments and Hyperlinks

26 Excel 2013 Tutorial - Text to Columns

27 Excel 2013 Tutorial - Flash Fill (new feature)

28 Excel 2013 Tutorial - COUNTIF Formula

29 Excel 2013 Tutorial - Pivot Tables

30 Excel 2013 Tutorial - Absolute vs Relative Cell Referencing

31 Excel 2013 Tutorial - VLOOKUP formula (with AutoFill)

32 Excel 2013 Tutorial - COUNTA Formula

33 Excel 2013 Tutorial - Financial Formula PMT Function (Calculate Loan Payments)

34 Excel 2013 Tutorial - ScreenShots and Sreen Clipping

35 Excel 2013 Tutorial - Image Editor

36 Excel 2013 Tutorial - Clip Art, SmartArt, and Shapes

37 Excel 2013 Tutorial - Cell Styles

38 Excel 2013 Tutorial - Basic Macro

39 Excel 2013 Tutorial - Quick Analysis (New Feature)

40 Excel Tutorial - SUMIF function

41 Excel Tutorial - AVERAGEIF Function

42 Excel Concatenate Tutorial

43 Excel Text Functions - LEFT RIGHT MID FIND Tutorial

44 Excel Go To Feature

45 Excel 2013 Tutorial MOS Practice 1.1

46 MOS Excel 1.2

47 MOS Excel 1.3a

48 MOS Excel 2013 Practice 1.3b

49 MOS Excel 2013 Practice 1.3c

50 MOS Excel 2013 Practice 1.3d

51 Excel 2013 Tutorial MOS Certification Practice 1.4a

52 Excel 2013 Tutorial MOS Practice 1.4b part 1

53 Excel 2013 Tutorial MOS Practice 1.4b part 2

54 MOS Excel 1.4c Certification Practice hiding worksheets

55 MOS Excel 2013 1.5a Certification Practice (77-882)

56 Excel 2013 Tutorial: MOS Certification 1.5b Training

57 Excel 2013 Tutorial: Inserting Data in Cells and Ranges (Certification Practice 2.1a)

58 Excel 2013 Tutorial - Inserting Data in Cells and Ranges (Certification Practice 2.1b)

59 Excel 2013 MOS Certification Tutorial 2.1c - Rotating Roster

60 Excel 2013 Tutorial - Certification Practice 2.2a

61 Excel 2013 Tutorial - MOS Certification Practice 2.2b

62 Excel 2013 Tutorial: Order and Group Cells and Ranges

63 Excel 2013 Tutorial: Sparklines (2.3b Certification Practice)

64 Excel 2013 Tutorial: Ordering and Grouping Cells and Ranges (Certification Training 2.3c)

65 Excel 2013 Tutorial: MOS Certification Practice 2.3d

66 Excel 2013 Tutorial: Manage Cells and Ranges - Certification Practice 2.3e

67 MOS Excel 2013 Tutorial: Certification Practice 3.1

68 Excel 2013 Help - MOS Certification Training 3.2

69 Excel 2013 Help: Tables (Certification Training 3.3)

70 MOS Excel 2013 Certification Practice (77-420) - Objective 4.1

71 Excel 2013 Tutorial - Certification Practice 4.2

72 Excel 2013 Certification Training 4.3a - SUMIF SUMIFS COUNTIF COUNTIFS

73 Excel 2013 Tutorial - MOS Certification Training 4.3b

And more...