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. Any assistance would be appreciated, I use OneNote frequently.
Microsoft Office Forum
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.
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 ...more
Sorry if I'm on wrong section but it's a serious mess over here. I prepared a presentation file on MS PowerPoint 2010 on my Windows 7 laptop last week. Everything was fine there before yesterday. But now the .pptx file can't be opened. It stops me with this: "PowerPoint has e ...more
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()
Check out this video tutorial on how to nest the AND, OR functions with IF function Video: .
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 t ...more
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 ic ...more
Like very inspirational designs for Powerpoint presentation slides.
Creating a visual histogram from a set of numerical data is maybe the most comprehensive way for truly understanding its nature Every major statistical software, including Excel, offers a histogram view of the data but it is usually a static and certainly not a very appealing ...more
Many systems offer true dashboard capabilities, but they are usually part of BI (Business Intelligence), complex and expensive applications, that only enterprises may afford Excel is without any doubt the most popular and affordable "BI" solution, but it basically lacks the c ...more
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. Video: . More Tutorials on Excel Dashboa ...more
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. Video: .
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. Example see atta ...more
How to sum the credit card trasection by credit card type in excel.
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 th ...more
How to Insert Random Time Between 7:30 AM to 8:00 AM in Ms Excel with Interval of 5 Minutes ?
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. Thank You.
Just a great excel KPI map for free. Video: .
Creating Excel 2013 Sparklines chart. In Excel 2010 and Excel 2013 we can use a new chart type named sparklines. Video: .
Using Excel 2013 Powerpivot SQL Tables - Excel Database Tutorial. In this tutorial we will learn how create database table relationships in excel. Video: .
Creating KPI dashboard using Excel 2013 PowerPivot - In this tutorial we will use SQL database to create a call center KPI dashboard. Video: .
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. Video: .
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. Video: .
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. Vi ...more
GeoFlow adds to the existing self-service BI capabilities in Excel 2013, to help discover and visualize large amounts of data. Video: .
Show sales and forecast data in the same line. It's common problem to show both actual data and forecast as a single trending component. Video: .
A picture tells a story just as well as a large amount of words, but building pretty cool excel data visualization can be time consuming 'passion'. Video: .
In this example, We'll use AdventureWorks DW2008 sample data and we'll create a KPI dashboard. Video: .
We'll show you how to use geographic data in a PowerView table. Video: .
In this tutorial explains the geometry and trigonometry used to create a new rotating gauge needle to replace the static one. Video: .
This video helps you to create Excel KPI Dashboards and Excel Dashboard Templates with gauges in Excel. No VBA code used to build! Video: .
To summarize and report results from separate worksheet ranges, we can consolidate data from each separate worksheet range into a PivotTable report on a master worksheet. Watch This Tutorial! Video: .
Be very careful while using the mathematical operators in excel. Use parenthesis to group the numbers. Excel follows the mathematical order of operators BODMAS B: Bracket O: Order/ Power of D: Division M: Multiply A: Addition S: Subtraction Some people may also call it PEDMA ...more
Excel keyboard shortcuts generally start with by pressing the “Alt” key. So, once you press the “Alt” key, you will see a shortcut or in fact an alphabet for each tab in the ribbon. Like F is for File, H is for Home, N for insert and so on. In the old excel interface, I mean ...more
When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly. A very good s ...more
Video: . How to use the excel formula..this is the easiest way to understand it
Many times you are supposed to enter the current date or time in excel so here is what you do; simply go to the cell and enter control + colon and the current date is added. If you want the time to be recorded, it is control + shift + colon. If you want both; it is control + ...more