~Get Your Files Here !

  Ex_Files_Excel_for_Mac_EssT

   Exercise Files

    Chapter01

     01_03_RibbonTour.xlsx

     01_05_GettingHelp.xlsx

    Chapter02

     02_02_Properties.xlsx

    Chapter03

     03_02_CopyPaste.xlsx

     03_04_NamedRanges.xlsx

     03_06_Find.xlsx

     03_08_List.xlsx

    Chapter04

     04_02_CustomSort.xlsx

     04_04_ManageCells.xlsx

    Chapter05

     05_02_CreateFormula.xlsx

     05_04_CopyFormulas.xlsx

     05_06_StatusBar.xlsx

     05_08_Tracing.xlsx

    Chapter06

     06_02_NumberFormats.xlsx

     06_04_CopyFormat.xlsx

     06_06_Conditional.xlsx

     06_08_ManageConditions.xlsx

    Chapter07

     07_02_Line.xlsx

     07_04_Layout.xlsx

     07_06_Axes.xlsx

    Chapter08

     08_02_Pivot.xlsx

     08_04_Summary.xlsx

    Chapter09

     09_02_AutoCorrect.xlsx

     09_04_Print.xlsx

     09_06_Export.xlsx

  [10] 9. Reviewing and Sharing Your Spreadsheets

   [1] Check spelling.srt

   [2] Set AutoCorrect and automatic Replace options.srt

   [3] Manage workbook comments.srt

   [4] Print a worksheet or workbook.srt

   [5] Set and remove print areas.srt

   [6] Export workbooks to other formats.srt

  [11] Conclusion

   [1] Further information.srt

  [1] Introduction

   [1] Learn how to succeed with Excel for Mac.srt

   [2] What you should know.srt

  [2] 1. Getting Started with Excel

   [1] What can you do with Excel for Mac.srt

   [2] Explore the Excel for Mac program window.srt

   [3] The ribbon.srt

   [4] Set program preferences.srt

   [5] Get help in Excel.srt

  [3] 2. Managing Workbooks

   [1] Open, create, and save workbooks.srt

   [2] Set workbook properties.srt

   [3] Create and modify templates.srt

  [4] 3. Working with Cells, Ranges, and Data

   [1] Select cells and groups of cells.srt

   [2] Copy and paste cell data.srt

   [3] Enter data using AutoFill and other techniques.srt

   [4] Create named ranges.srt

   [5] Create an Excel table.srt

   [6] Locate and change data using Find and Replace.srt

   [7] Guide cell input using validation rules.srt

   [8] Enable data entry using validation lists.srt

  [5] 4. Sorting, Filtering, and Managing Worksheets

   [1] Sort worksheet data.srt

   [2] Create a custom sort order.srt

   [3] Filter worksheet data.srt

   [4] Insert, move, and delete cells and cell ranges.srt

   [5] Manage worksheets.srt

  [6] 5. Summarizing Data Using Formulas and Functions

   [1] Introduce Excel formulas, functions, and operators.srt

   [2] Add a formula to a cell.srt

   [3] Use relative and absolute cell references.srt

   [4] Control how Excel copies and pastes formulas.srt

   [5] Refer to Excel table data in formulas.srt

   [6] Summarize data on the status bar.srt

   [7] Summarize data using IF functions.srt

   [8] Identify precedents and dependents.srt

  [7] 6. Formatting Worksheet Elements

   [1] Apply fonts, background colors, and borders.srt

   [2] Apply number and date formats to cells.srt

   [3] Manage text alignment.srt

   [4] Copy cell formats.srt

   [5] Manage cell styles.srt

   [6] Create rule-based conditional formats.srt

   [7] Define data bar, color scale, and icon set conditional formats.srt

   [8] Manage conditional formats.srt

  [8] 7. Working with Charts

   [1] Create bar and column charts.srt

   [2] Create line charts.srt

   [3] Create XY (scatter) charts.srt

   [4] Change chart types and layouts.srt

   [5] Format chart elements.srt

   [6] Manage chart axes and numbering.srt

   [7] Create sparkline charts.srt

  [9] 8. Exploring PivotTables

   [1] Create a PivotTable.srt

   [2] Pivot a PivotTable.srt

   [3] Manage subtotals and grand totals.srt

   [4] Change the data field summary operation.srt

   [5] Change the format of a data field.srt