wonderhowto_01.png

Microsoft Office


Latest Articles

YouTube Preview Thumbnail
Mar 28, 2018

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specifi ...

Article cover image
Sep 25, 2017

This tutorial will teach you how to Create print ready reports from an excel listDownload the sample report here https://goo.gl/Zt8HTz ...

Article cover image
Sep 25, 2017

Nesting of the IF formula is quite tricky but after using the methodology shown in this video, you can be a master at using multiple IF conditions.This tutorial will teach you How to use Multiple IF c ...

Article cover image
Sep 25, 2017

How do you learn all excel formulas?A super simple explanation of the syntax of excel function and the usage of mathematical operators.See it yourself how putting an equal to (=) sign brings a cell in ...

Article cover image
Sep 25, 2017

This tutorial will teach you How to remove line breaks in excel. There can be different reasons for line breaks occurring in your text. Usually, carriage returns appear when you copy text from a webpa ...

Article cover image
Sep 25, 2017

Create a gauge chart or speedometer chart in excel using these simple steps in less than 10 minutes.All you need is to hack a donut chart and pie chart and superimpose them.Link to download the xls fi ...

Article cover image
Sep 25, 2017

A common question from Excel users is along the lines of; I have a list in a cell that has used Data-Validation with the "List" option. I would like to have another cell display a list that is depende ...

Article cover image
Sep 25, 2017

Check this step by step tutorial for a task tracker or to do list. It will also guide you to create dashboards, reports and charts easily.Download the sample spreadsheet from the link here: https://dr ...

YouTube Preview Thumbnail
Jul 27, 2017

So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and ther ...

YouTube Preview Thumbnail
Feb 23, 2017

If you're a teacher in any type of school, whether it's high school, college, or middle school, it's imperative that you keep an attendance sheet. The paper and pen route can get pretty messy, and ver ...