Excel 2016: Up To Speed

Excel 2016: Up To Speed by [Hyttinen, R.M.]
Excel 2016: Up To Speed
By 作者: R.M. Hyttinen
Pages 页数: 417 pages
Edition 版本: 1
Language 语言: English
Publisher Finelybook 出版社: PCM Courseware
Publication Date 出版日期: 2016-04-07
ISBN-10 书号:B01E08F3SG
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, concise 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.
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....


Contents

Chapter 1 - Excel Basics
Chapter 2 - Working with Data
Chapter 3 - Editing a Worksheet
Chapter 4 – Formatting a Worksheet
Chapter 5 - Page Setup and Printing
Chapter 6 - Formulas and Functions
Chapter 7 - Using a Formula to Join the
Contents

of Multiple Cells
Chapter 8 - Modifying Workbooks
Chapter 9 - Working with Tables
Chapter 10 - Working with Charts
Chapter 11 - Working With Graphics
Chapter 12 - Financial & Logical Functions
Chapter 13 - Date and Time Functions
Chapter 14 - Managing Workbooks
Chapter 15 - Importing & Exporting Data
Chapter 16 - Formatting Numbers
Chapter 17 - Working with Ranges
Chapter 18 - Working with Macros
Chapter 19 - Data Analysis Tools
Chapter 20 - Summarizing Data
Chapter 21 - Analyzing Your Data
Chapter 22 - Collaborating with Others
链接: http://pan.baidu.com/s/1dFqPZln 密码: 29n5
觉得文章有用就打赏一下文章作者
未经允许不得转载:finelybook » Excel 2016: Up To Speed
分享到: 更多 (0)

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏