Excel 2016: Up To Speed

Nonfiction, Computers, Application Software, Spreadsheets, Financial Applications
Cover of the book Excel 2016: Up To Speed by R.M. Hyttinen, PCM Courseware
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: R.M. Hyttinen ISBN: 9780991518654
Publisher: PCM Courseware Publication: April 9, 2016
Imprint: Language: English
Author: R.M. Hyttinen
ISBN: 9780991518654
Publisher: PCM Courseware
Publication: April 9, 2016
Imprint:
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....
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart


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:        
        

More books from Financial Applications

Cover of the book Analisi dei dati con Excel by R.M. Hyttinen
Cover of the book Microsoft Excel 2019 Formulas and Functions by R.M. Hyttinen
Cover of the book Excel 2016 In Depth (includes Content Update Program) by R.M. Hyttinen
Cover of the book Excel 2019 Bible by R.M. Hyttinen
Cover of the book Business Analysis with Microsoft Excel by R.M. Hyttinen
Cover of the book Excel職場工作術:立即上手的16個收支圖表、市調統計分析、投資試算、績效評核、函數應用職場即戰例 by R.M. Hyttinen
Cover of the book Head First Excel by R.M. Hyttinen
Cover of the book PowerPivot for the Data Analyst by R.M. Hyttinen
Cover of the book Excel 2016 Passo dopo Passo by R.M. Hyttinen
Cover of the book Excel 2016 für Dummies kompakt by R.M. Hyttinen
Cover of the book #EXPERT EXCEL PROJECTS tweet Book01 by R.M. Hyttinen
Cover of the book QuickBooks 2010 Solutions Guide for Business Owners and Accountants by R.M. Hyttinen
Cover of the book Intuit QuickBooks Enterprise Edition 12.0 Cookbook for Experts by R.M. Hyttinen
Cover of the book Business Barista by R.M. Hyttinen
Cover of the book MOS 2016 Study Guide for Microsoft Excel by R.M. Hyttinen
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy