Microsoft Office How-to Guides
Our Microsoft Office how-to guides help you get the best from Excel, Word, PowerPoint – learn how to configure and optimize these Microsoft Office Apps.
Microsoft Office How-to
How to Merge 2 or More Excel Files into 1 Excel File
In this Itechguide, Victor teaches you how to merge Excel files. The guide covers 8 steps to merge Excel files. In this Itechguide, I will merge the files shown in this image into a ...
How to Combine Two Word Documents
This Itechguide teaches you how to combine two Word documents. The guide covers 10 steps to combine two Word documents. To make it easier, before you proceed with the steps in this Itechguide, ...
How to Add More Rows to a Table in Word and Google Docs
Introduction This guide demos how to add more rows to a table in Word. It also has a section with steps to add more rows to a table in Google Docs. How to Add More Rows to a Table in Word ...
How to Create a Bar Chart in Excel and Google Sheets
Introduction This guide demos how to create a bar chart in Excel and Google Sheets. A bar chart is used to visually compare values across categories. Representing data in charts makes it ...
How to Create a Pie Chart in Excel and Google Sheets
Introduction This guide demos how to create a pie chart in Excel and Google Sheets. A pie chart is a circular representation of a data set in portions. In other words, a pie chart shows ...
How to Download Office 365 Offline Installer
This Itechguide teaches you how to download office 365 offline installer. The guide covers steps to download office 365 offline installer for Office 365 Personal and Business accounts. ...
How to Fix “Document not Saved” Error in Excel
Excel "Document not Saved" Error may be caused by one of the following: Attempting to save a shared Excel workbookYou are trying to save an Excel document to a drive with insufficient drive ...
How to Calculate Variance in Excel
Introduction Variance measures the spread between numbers in a data set. You can calculate variance in Excel using the VAR, VAR.S, VARP or VAR.P. In this guide you will learn how to calculate ...
How to Calculate Standard Deviation in Excel
Introduction Standard Deviation is a measure of how dispersed values are from their mean (average). You can calculate standard deviation in Excel with STDEV, STDEVP, STDEV.S or STDEV.P Functions. ...
How to Merge Cells in Excel in 2 Easy Ways
Introduction You can merge two Cells in Excel using CONCATENATE function or the “&” (ampersand) operator. Though Excel has a merge tool, when you merge cells in Excel with data, you will lose ...
How to Make a Pivot Table in Excel
Introduction A Pivot Table allows you to analyze, summarize and calculate large data to help find relationships. With a Pivot Table in Excel you can see patterns and trends. In this guide you ...
Concatenate in Excel: How to Concatenate Columns and Strings
What is Concatenate in Excel? Concatenate in Excel is joining two strings into one continuous string. You can join two strings using the CONCATENATE function or the "&" (ampersand) operator. ...