General Discussion « Microsoft Office

Forum Thread: How to Make a Simple Report Card Template in Excel

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

Forum Thread: How to Insert 'NESTED if' with Ease

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.

Forum Thread: How to Memorise the Excel Formula Syntax

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 into the calculation mode.

Forum Thread: How to Remove Line Breaks in Excel

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 webpage, get a workbook that already contains line breaks from a customer, or you add them yourself using Alt+Enter.

Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel

Create a gauge chart or speedometer chart in excel using these simple steps in less than 10 minutes.

Forum Thread: How to Add Dependent Data Validations in Excel

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 depended on the item chosen in my first list.

Forum Thread: How to Create a Task Tracker in Excel

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.

Forum Thread: OneNote 2010 document

After recent Windows updates: Have deleted all temp files. Have tried uninstalling and reinstalling Office 2010. Able to access the two notebooks I published to the Web via Windows Live.

Forum Thread: How to Turn Off Panning Hand

Can I turn off "panning hand?"

Forum Thread: While in a Spread Sheet, I Click on One Cell and It Will Auto Highlight Many. Why and How Do I Undo It?

This makes it hard or impossible to auto sum some of the cells. If I want to copy paste into the cells I can't do that either.

Mail Merge Software: Hello.

Hello. I'm looking for a piece of software to help me with mail merges. Specifically, I'm looking for a piece of software/Outlook add-ons that will allow me to insert custom fields (along with the Last Name, First Name, Address, etc. fields, especially with regard to if/then statements), CC and BCC mail merge recipients, and attach documents.

Forum Thread: PPTX File Is Giving an Error and Can't Be Opened.

Sorry if I'm on wrong section but it's a serious mess over here.

Forum Thread: How to Use Vlookup

the data I'm looking up is on one worksheet but where the data is going is on another worksheet. Is this possible? If so, how do I do this? Thanks!

Forum Thread: Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is

Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is Not Sold What Is the Syntac for Sold Date=Today()

Forum Thread: How to use AND, OR with the IF function

Check out this video tutorial on how to nest the AND, OR functions with IF function

Forum Thread: How to Create a Personal Finance Spreadsheet

I need to set up a spreadsheet that will track and reconcile income and expenses from multiple bank accounts and credit card accounts. I also need it to provide me with monthly reports and pie charts. Does anyone have any suggestions or know of a template that is already out there for this use?

Forum Thread: How to Format a Chart Based on Another Chart Format

When you create a chart, you often want that it looks similar to some other one. So that instead of formatting the new chart from scratch, which may be quite time consuming, I use simply to copy the template chart and paste it to the new one AS FORMAT from the Paste Special icon. A real life saver if you create a lot of charts...

Forum Thread: Powerpoint Presentation Design

Like very inspirational designs for Powerpoint presentation slides.

Forum Thread: How to Create Excel Based Interactive Awesome Histograms

Creating a visual histogram from a set of numerical data is maybe the most comprehensive way for truly understanding its nature

Forum Thread: Why Aren't TRUE Excel Based Dashboards More Prevalent?

Many systems offer true dashboard capabilities, but they are usually part of BI (Business Intelligence), complex and expensive applications, that only enterprises may afford

Forum Thread: How to Create Excel Sales Dashboard

This dynamic template let us check sales by consumer type or location and examine values with averages too. In this Excel 2013 tutorial we'll show you how to create a sales kpi template. Visit our blog to download free excel dashboards.

Forum Thread: How to Create Excel Premium Power Maps

Excel Premium Power maps series are a brand new project for you! After the one month development phase finally we are ready to present our new excel map templates for you which enable you to use the power of the excel sales heat map.

Forum Thread: Extracting Data from a Spreadsheet Which Are Use Repeatedly Against a Column Value

I have data in a Spreadsheet from 2 Project Locations. Each Project Locations Has Different Suppliers - Some Have Unique Suppliers Whereas Some Suppliers Supply Commonly to Both Locations. I Want to Identify Those Suppliers Which Are Common to Both Locations.

Forum Thread: How to Sum the Credit Card in Excel by Credit Card Type.

How to sum the credit card trasection by credit card type in excel.

Forum Thread: Conditional Formating Based on an Entered date. Not todays date!

I have a column of dates which are entered by our sales guys when they last had contact with a customer. I wish to highlight the row based on the date they enter being over 60 days ago. All the forums i have looked at have showed me how to do it based on todays date, but in this circumstance todays date is irrelevant. Help please!

Forum Thread: How to Insert Random Time Between 7:30 AM to 8:00 AM with Interval of 5 Minutes

How to Insert Random Time Between 7:30 AM to 8:00 AM in Ms Excel with Interval of 5 Minutes ?

Forum Thread: How Do I Use Excel 2007 to Prepare Dividend Warrant.

How do i use Microsoft excel to Prepare Dividend Warrants for an Organization of About 10,000 Share Holders? Kindly Help Me with Step by Step Guild.

Forum Thread: Excel US Sales Map Dashboard

Just a great excel KPI map for free.

Forum Thread: How to Create Excel 2013 Sparklines Chart

Creating Excel 2013 Sparklines chart. In Excel 2010 and Excel 2013 we can use a new chart type named sparklines.

Forum Thread: How to Use Excel 2013 Powerpivot SQL Tables

Using Excel 2013 Powerpivot SQL Tables - Excel Database Tutorial. In this tutorial we will learn how create database table relationships in excel.

Forum Thread: How to Create KPI Dashboard Using Excel 2013 PowerPivot

Creating KPI dashboard using Excel 2013 PowerPivot - In this tutorial we will use SQL database to create a call center KPI dashboard.

Forum Thread: How to Use Excel 2013 WebApps

Build Excel Sales Map in 2 minutes using Excel 2013 WebApps. In this video I'll show you how to create excel map to visualize sales performance.

Forum Thread: How to Create Excel Customer Service KPI Dashboard

Our tutorial will show you how to create in Excel a simple customer kpi dashboard for monitoring and reporting the actual status of customer center KPIs.

Forum Thread: How to Create Excel KPI Gauge Dashboard Templates

In my first article in this category I made a simple free excel kpi gauge dashboard. It was one of my first attempts in world of Excel Templates. The time is now for me to refresh my old excel template and I achieved some changes in order for the workbook to be more useful.