立即登記!!訂閱恩賢最新通訊

Microsoft Excel 2013 Basic Training

Course Outlines

Getting started with Excel 2013

• Starting Excel 2013

• Selecting the blank worksheet template

• The Excel 2013 cell referencing system

• Default text and number alignment

• Summing a column of numbers

• Worksheets and workbooks

• Saving a workbook to your hard disk

• Creating a new workbook

• Saving a workbook using another name

• Saving a workbook using a different file type

• Getting help within Excel 2013

• Alt key help

Alignment formatting within Excel 2013

• Horizontally aligning contents in a cell range

• Centering a title over a cell range

• Cell orientation

• Text wrapping within a cell

• Aligning cell contents vertically

• Format painter

Number formatting within Excel 2013

• Number formatting

• Decimal point display

• Applying and removing comma style formatting (to indicate thousands)

• Currency symbol

• Date styles

• Percentages

Freezing row and column titles within Excel 2013

• Freezing row and column titles

Excel 2013 formulas

• Creating formulas

• The easy way to create formulas

• Copying formulas

• Operators

• Using operators in formulas

• Formula error messages

• Relative cell referencing within formulas

• Absolute cell referencing within formulas

Excel 2013 functions

• Common functions

• Sum function

• Average function

• Max function

• Min function

• Count function

• The counta function

• The countblank function

Excel 2013 charts

• Inserting a line, bar or pie chart

• Resizing a chart

• Deleting a chart

• Chart title or labels

• Changing the column, bar, line or pie slice colors in a chart

• Modifying the legend fill color

• Changing the chart type

• Modifying charts using the layout tab

• Copying and moving charts within a worksheet

Sorting and Querying Data

• Sorting internal Excel databases

• Custom sort options

• Using AutoFilter to query data

• Multiple queries

• Removing filters

• Top 10 AutoFilter

• Filtering unique records

• Advanced Filter

Consolidating Data

• Consolidating data over several worksheets or worksheet pages