Skip navigation

Bookboon.com The best way to educate yourself

Tag Archives: Microsoft Excel

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: How to Copy Formulas in Excel

Are you exhausted with manual calculation? Are you exhausted with manual calculation?

 

4 tips when using formulas

One of the basic functions of Excel that users love is its capability of utilizing and interpreting simple to complicated calculations using formula. If you are using the platform for a long time, this feature has served you for so long and you might be dealing with complex calculations and formulas already. However, for those who are using the program for the first time, you might be surprised with the fact that Excel can make your calculations in just a few clicks. Yes, it can! You will just have to learn few tricks to incite your learning and be able to make your own formulas based on your need.
(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…)

MS Excel 2016: Save Time Using Autofill

MS Excel 2016 tutorial on how to use Autofill. MS Excel 2016 tutorial on how to use Autofill.
 

How to use the Autofill function in Microsoft Excel

Are you tired of re-typing the same contents in MS Excel over and over again? How about manually entering series of lists or redoing a certain format in each cell that you are working with? Well, you better learn more about the Autofill function and you’ll be surprised with how well Excel knows what you need in using its platform. Autofill will let you save more time and effort in doing the simple yet time-consuming and redundant tasks that you often deal with.
(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…)