Skip navigation

Bookboon.com The best way to educate yourself

Tag Archives: Excel 2016

Excel 2016: Using Worksheets and Workbooks

excel-2016-core-part-11-ebook-bookboon-blog Learn how to work with worksheets by reading this article. It’s as easy as 1, 2, and 3!

 

How to keep record and find your data fast and easy

Excel can be compared to a real book and we call that book a “workbook”. A workbook can contain one or several pages, which in Excel, we call “worksheets”. Now, imagine a workbook containing lots of information all mixed-up in only one worksheet; for instance, a company’s financial statement for five long years. Would you be able to locate specific information, like a month’s report, easily? Obviously, the answer is NO. That’s when the idea of having multiple worksheets becomes handy. Excel indeed is a great tool, especially for record-keeping, and of course, finding.
(more…)

Excel 2016: How to Split Cells in Excel for a Better View

What are the different ways of viewing Excel 2016’s worksheets? What are the different ways of viewing Excel 2016’s worksheets?

 

How to make your work easier when splitting large worksheets

Working on a huge workbook that has significant information all throughout its part is very tedious and time-consuming; especially when you are constantly scrolling up, down, left and right just to see and work at different parts.

Well, worry no more! By using the different views of Excel 2016, you will be able to save lots of time and effort in manipulating your workbooks and worksheets.
(more…)

MS Excel 2016: Basic Excel Functions

Basic Excel Functions - learn more about this amazing features! Basic Excel Functions – learn more about this amazing features!

 

Excel’s basic functions: SUM, AVERAGE, MAX, MIN and COUNT

One of the most advantageous uses of Excel is its capability to handle formulas. Users appreciate the fact that calculations can be made easier using this platform. Students, and even professionals, rely on its capabilities to lessen their burden on doing certain calculations and operations over and over again. However, calculations using formula is not the only feature Excel can boast. It also has its “functions”, or specially programmed formulas, which allow users to perform more complicated calculations in just few clicks.
(more…)

MS Excel 2016: Get Faster Using the Flash Fill Feature

Tired of using formula in joining contents or extracting data in Excel? Tired of using formula in joining contents or extracting data in Excel?

 

How to use the Flash Fill feature in Microsoft Excel

Previously, when you have a data in columns and you want to combine them in a single cell, you need to create a formula. Formula must also be created when you want to extract data in a cell or format cells based on your reference. Well, the agony of creating formula for these tasks has now come to an end. 

With Excel 2016, you can now make these complicated things simple through the feature known as Flash Fill. This feature was actually first introduced in Excel 2013 and I bet everybody enjoyed using it!

(more…)

Excel 2016: 3 Simple Steps to Hide and Unhide Portions

Hide and Unhide Portions in Excel.Hide and unhide portions in Excel.

In dealing with Excel, most especially with formulas, there are necessary portions that we need to include but not that so important to be shown. There are also portions that we do not want someone to mess with or change, for if it is changed, the entire worksheet or workbook will be negatively affected. Messing with those portions will not make your file work out the way you planned and designed it to be. With these instances, the “hide and unhide” options of Excel 2016 are very helpful.
 
(more…)

Excel 2016: How to Format Cells and Worksheets

Format Cells and Worksheets. Format Cells and Worksheets.
 

The Home Ribbon to customize and format cells and worksheets

Creativity and uniformity are few of the least aspects most people consider in using Excel. More often, we tend to disregard the styles we use, for instance fonts, no matter how different they are from each other. We ignore the format, most especially when we are working with lots of information in a worksheet. However, formatting your worksheets is not a difficult task at all. Doing so will make your file look more organized and professional. Uniformity will even encourage you to work on your file with enthusiasm and excitement.

(more…)

Excel 2016: Essential Facts About Worksheets and Workbooks and How to Utilize Them

This user guide will take you through all the things you need to know when using Excel at a simple level. This user guide will take you through all the things you need to know when using Excel at a simple level.
 

The difference between Excel’s worksheets and workbooks

Excel is now even more powerful with its new version – Excel 2016. The enhanced version allows users to analyze and organize data more efficiently using added tools and functions. Although sometimes, it seems hard to navigate Excel, knowing the basic concepts can be a starting point to learn more. For instance, Excel’s basic terms, such as worksheet and workbook, can be confusing at first but knowing their difference is of great help in using the program.

Worksheet refers to a single spreadsheet, while workbook refers to an Excel file that contains one or more worksheets in separate tabs found at the bottom of the window.

 

(more…)

Excel 2016: Customize The ‘Quick Access Toolbar’

Customizing your Quick Access Toolbar in Excel 2016. Customizing your Quick Access Toolbar in Excel 2016.

 

3 easy ways to customize your Excel sheet

Excel, as one of the most helpful programs in ones computer or laptop, has evolved into something more powerful this year. Aside from our favorite functionalities and features, Windows added more enhancements and improvements for the benefit of their users under its new version – Excel 2016. A very useful tool, the Quick Access Toolbar, is still present in the said program. It is found not only in Excel, but also in other programs of the Office package like Word, PowerPoint and Outlook. Customizing this toolbar based on one’s need and frequent usage is a huge help in conserving time while using the platform.

(more…)

MS Office 2016 tutorial eBooks

MS Office 2016 tutorial eBooks MS Office 2016 tutorial eBooks

Recently updated to Microsoft Office 2016? The 5 eBooks below will help you get up to speed with all the functions you have been using in the past or previous Microsoft Office versions and introduce you to new functions of Excel 2016, PowerPoint 2016 , Outlook 2016 and Word 2016.
(more…)