Buy Microsoft Excel 2016 Step by Step at Bookstore UAE
close menu
Bookswagon
search
My Account
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology Books > Business applications > Spreadsheet software > Microsoft Excel 2016 Step by Step: (Step by Step)
Microsoft Excel 2016 Step by Step: (Step by Step)

Microsoft Excel 2016 Step by Step: (Step by Step)


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Now in full color!


The quick way to learn Microsoft Excel 2016!

This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step.

  • Quickly set up workbooks, enter data, and format it for easier viewing
  • Perform calculations and find and correct errors
  • Filter, sort, summarize, and combine data
  • Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver
  • Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps
  • Build data models and use them in business intelligence analyses
  • Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps
  • Look up just the tasks and lessons you need


Table of Contents:
Introduction     xiii
Who this book is for     xiii
The Step by Step approach     xiii
Download the practice files     xiv
Sidebar: Adapt exercise steps     xviii
Ebook edition     xx
Get support and give feedback     xx
Errata and support     xx
We want to hear from you     xx
Stay in touch     xx
Part 1: Create and format workbooks
Chapter 1: Set up a workbook     3

Explore the editions of Excel 2016     4
Excel 2016     4
Excel Online     4
Excel Mobile Apps     5
Become familiar with new features in Excel 2016     6
Create workbooks     7
Modify workbooks     13
Modify worksheets     18
Merge and unmerge cells     23
Customize the Excel 2016 app window     26
Zoom in on a worksheet     26
Arrange multiple workbook windows     28
Add buttons to the Quick Access Toolbar     30
Customize the ribbon     33
Skills review     39
Practice tasks     40
Chapter 2: Work with data and Excel tables     43
Enter and revise data     44
Manage data by using Flash Fill     48
Move data within a workbook     51
Find and replace data     56
Correct and expand upon data     60
Define Excel tables     65
Skills review     69
Practice tasks     70
Chapter 3: Perform calculations on data     73
Name groups of data     74
Create formulas to calculate values     77
Sidebar: Operators and Precedence     88
Summarize data that meets specific conditions     90
Set iterative calculation options and enable or disable automatic calculation     96
Use array formulas     98
Find and correct errors in calculations     100
Skills review     106
Practice tasks     107
Chapter 4: Change workbook appearance     111
Format cells     112
Define styles     118
Apply workbook themes and Excel table styles     121
Make numbers easier to read     127
Change the appearance of data based on its value     130
Add images to worksheets     138
Skills review     142
Practice tasks     143
Part 2: Analyze and present data
Chapter 5: Manage worksheet data     147

Limit data that appears on your screen     148
Manipulate worksheet data     153
Sidebar: Select list rows at random     154
Summarize data in worksheets that have hidden and filtered rows     155
Find unique values within a data set     161
Define valid sets of values for ranges of cells     163
Skills review     165
Practice tasks     166
Chapter 6: Reorder and summarize data     169
Sort worksheet data     170
Sort data by using custom lists     176
Organize data into levels     179
Look up information in a worksheet     184
Skills review     187
Practice tasks     188
Chapter 7: Combine data from multiple sources     191
Use workbooks as templates for other workbooks     192
Link to data in other worksheets and workbooks     197
Consolidate multiple sets of data into a single workbook     202
Skills review     205
Practice tasks     206
Chapter 8: Analyze alternative data sets     209
Examine data by using the Quick Analysis Lens     210
Define an alternative data set     212
Define multiple alternative data sets     216
Analyze data by using data tables     218
Vary your data to get a specific result by using Goal Seek     221
Find optimal solutions by using Solver     223
Analyze data by using descriptive statistics     229
Skills review     231
Practice tasks     232
Chapter 9: Create charts and graphics     237
Create charts     238
Create new types of charts     248
Customize chart appearance     252
Find trends in your data     260
Create dual-axis charts     263
Summarize your data by using sparklines     264
Create diagrams by using SmartArt     266
Create shapes and mathematical equations     271
Skills review     277
Practice tasks     278
Chapter 10: Create dynamic worksheets by using PivotTables     281
Analyze data dynamically by using PivotTables     282
Filter, show, and hide PivotTable data     290
Edit PivotTables     301
Format PivotTables     305
Create PivotTables from external data     309
Create dynamic charts by using PivotCharts     313
Skills review     316
Practice tasks     317
Part 3: Collaborate and share in Excel
Chapter 11: Print worksheets and charts     323

Add headers and footers to printed pages     324
Prepare worksheets for printing     330
Fit your worksheet contents to the printed page     331
Change page breaks in a worksheet     334
Change the page printing order for worksheets     335
Print worksheets     337
Print parts of worksheets     339
Print charts     343
Skills review     345
Practice tasks     346
Chapter 12: Automate repetitive tasks by using macros     349
Enable and examine macros     350
Set macro security levels in Excel 2016     350
Examine macros     353
Create and modify macros     356
Run macros when you click a button     357
Run a macro when you open a workbook     361
Insert form controls into a worksheet     362
Skills review     369
Practice tasks     370
Chapter 13: Work with other Microsoft Office apps     373
Include Office documents in workbooks and other files     374
Link Office documents to Excel workbooks     375
Embed files in Excel and other Office apps     377
Create hyperlinks     379
Paste charts into documents     384
Skills review     385
Practice tasks     386
Chapter 14: Collaborate with colleagues     389
Share workbooks     390
Save workbooks for electronic distribution     394
Manage comments     395
Track and manage colleagues’ changes     398
Add protection to workbooks and worksheets     401
Finalize workbooks     408
Authenticate workbooks     410
Save workbooks for the web     412
Import and export XML data     414
Work with OneDrive and Excel Online     418
Skills review     424
Practice tasks     425
Part 4: Perform advanced analysis
Chapter 15: Perform business intelligence analysis     431

Enable the Data Analysis add-ins     432
Define relationships between tables     434
Analyze data by using Power Pivot     438
View data by using timelines     442
Bring in external data by using Power Query     446
Skills review     451
Practice tasks     452
Chapter 16: Create forecasts and visualizations     455
Create Forecast Worksheets     456
Define and manage measures     461
Define and display Key Performance Indicators     464
Create 3D maps     468
Skills review     475
Practice tasks     476
Keyboard shortcuts     479
Glossary     89
Index     95
About the author     521


About the Author :
Curtis Frye is the author of more than 30 books, including  Microsoft Excel 2013 Step by Step for Microsoft Press and  Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda.com, including  Excel for Mac 2016 Essential Training and  Excel 2013: PivotTables in Depth. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats.


Best Sellers


Product Details
  • ISBN-13: 9780735697454
  • Publisher: Microsoft Press,U.S.
  • Publisher Imprint: Microsoft Press,U.S.
  • Language: English
  • Series Title: Step by Step
  • ISBN-10: 0735697450
  • Publisher Date: 25 Sep 2015
  • Binding: Digital download
  • No of Pages: 544
  • Weight: 1 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft Excel 2016 Step by Step: (Step by Step)
Microsoft Press,U.S. -
Microsoft Excel 2016 Step by Step: (Step by Step)
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft Excel 2016 Step by Step: (Step by Step)

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!