Excel 2016: Up To Speed

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications

• Author: R.M. Hyttinen
• ISBN: 9780991518654
• Publisher: PCM Courseware
• Publication: April 9, 2016
• Language: English

The Excel 2016: Up To Speed guide helps you to get up and running  quickly with the world's most popular spreadsheet application.  This handy step-by-step guide is written from scratch, starting with basic Excel topics and moving on to more advanced features of application, designed to help you to become more productive more quickly.  Though comprehensive, the information in this book is presented in a clear, consise manner with screenshots providing helpful visual guidance all along the way.

    In no time at all you're be importing and exporting data, creating formulas, modifying and formatting spreadsheets, setting up and formatting data in tables, creating beautiful charts, adding and subtracting dates, creating impressive PivotTables,  and much more.    
    
Some of the topics include:        
        

• Examining the Excel Environment
• Opening an Existing Workbook
• Navigating a Worksheet
• Creating a New Workbook
• Saving a New Workbook
• Moving Between Workbooks
• Setting Excel Options
• Switching between Views
• Using Tell Me to Obtain Help
• Closing a Workbook and Exiting Excel
• Entering Text and Numbers
• Entering Numbers as Text
• Changing Column Width:
• Entering Simple Formulas
• Choosing Formula Cell References
• Using AutoSum
• Total rows and columns at the same time using AutoSum
• Changing & Deleting Data
• Using Undo/Redo
• Using Find and Replace
• Using the Go To Command
• Spell Checking Your Worksheet
• Inserting Symbols
• Using Smart Lookup
• Working with Ranges
• Copying and Pasting Data
• Using the Office Clipboard
• Cutting and Pasting Data
• Copying and Moving Cells using Drag-And-Drop
• Changing Column Width
• Autofit
• Changing Row Height
• Inserting and Removing Rows and Columns
• Copying Data and Formulas with AutoFill
• Using AutoFill to Create a Series
• Filling in Cells using Flash Fill
• Formatting Text
• Using the Format Cells Dialog Box
• Formatting Values from the Ribbon
• Formatting Numbers
• Fractions
• Using the Format Painter Button
• Formatting Cells
• Hiding and Freezing Rows and Columns
• Inserting Headers and Footers
• Working with Formulas & Functions
• Using a Formula to Join the Contents of Multiple Cells
• Combine Cells using the Ampersand
• Combine cells using the CONCATENATE Function
• Combine cells using the CONCAT Function
• Joining Text with the TEXTJOIN Function
• Pasting as Values
• Modifying Workbooks
• Adding and Deleting Worksheets
• Copying Worksheets
• Renaming Worksheets
• Repositioning Worksheets
• Grouping Worksheets
• Changing Worksheet Tab Colors
• Using 3-D Formulas & References
• Creating a Table
• Enter Data into a Table
• Deleting Rows and Columns
• Formatting a Table
• Totaling Data in a Table
• Sorting Data in a Table
• Sorting Multiple Columns
• Filtering Data using AutoFilter
• Creating Custom Filters
• Creating a Chart
• Moving a Chart
• Resizing a Chart
• Changing the Layout and Style
• Labeling Chart Elements
• Formatting Chart Text
• Formatting Chart Elements
• Changing the Chart Type
• Showing or Hiding Gridlines
• Customizing Axes
• Creating a Pie Chart
• Changing a Chart’s Source Data
• Moving a Chart to a Different Worksheet
• Saving a Chart Template
• Filtering Chart Data
• Using Sparklines
• Customizing Sparklines
• Adding Pictures
• Inserting Online Images
• Adding Shapes
• Formatting Drawing Objects
• Inserting WordArt & SmartArt
• Inserting & Modifying an Organization Chart
• Taking a Screenshot
• Using the IF Function
• Using Nested Functions
• The COUNTIF Function
• Using the PMT Function
• Using the FV Function
• Using AutoCalculate
• Understanding Date/Time Functions
• And much more....