Most valuable professional
  • Archives

Excel Daily News - Alphabetical Archive by Title

This page contains an alphabetical list of articles from the Excel Daily News. It currently includes October 5, 2014 and newer. I am working on older archives. Other archives are available, as follows:

10 Excel Data Entry Tips You Should Know

trumpexcel.com - Excel is an amazing tool with fascinating capabilities to analyze data (be it using formulas, charts or dashboards). The ease with which data can be entered and stored in Excel makes it a compellin...

Date shared: October 16, 2014

Error 2042

 

 

10 Excel Tips For Increased Productivity - Excel Zoom

excelzoom.com - Microsoft Excel has tons of uses available to its users. But not everyone knows all the features that Excel has to offer. Some Excel tips will help you instantly become more productive, or use Exce...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

2014 Excel Dashboard Competition

excelforum.com - Forum: 2014 Excel Dashboard Competition

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

35 Years Ago Today, Spreadsheets Were Invented - The Atlantic

qz.com - On this day in 1979, a computer program called VisiCalc first shipped for the Apple II platform, marking the birth of the spreadsheet, a now-ubiquitous tool used to compile everything from grocery ...

Date shared: October 17, 2014

Error 2042

 

 

3D Sum Formula Reference - Excel Zoom

excelzoom.com - On occasion, it is useful to keep track of similar data in separate worksheets. Data such as monthly, quarterly, or annual financial information isn't always best to show in one spreadsheet. Howeve...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

5 minute tutorial for creating custom maps with Excel and Power Map - PowerBI - Site Home - MSDN Blogs

blogs.msdn.com - This blog post was authored by James Marshall, Developer on the Excel Power Map team In early September, we introduced you to Custom Maps, a new feature in Power Map for Excel. Power Map is part of...

Date shared: October 14, 2014

Featured in the Science section of the Excel Daily News on October 14, 2014.

 

 

5 Unknown Excel Features To Make Your Work Easier

almurray.hubpages.com - I begin with a feature that has been around for many years and inspired this article. I demonstrate some techniques that require this feature on my courses, and very rarely are people aware of it's...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

50% Off Video Tutorials: Learn Microsoft Excel, PowerPoint, WordPress, Minecraft, Gmail

quepublishing.com - Que's video courses empower you with the gift of knowledge from the world's leading author experts. Take advantage of this exclusive 50% discount offer and save up to $75! Use discount code GIFT50 ...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

 

7 Excel Formatting Tricks - Excel Zoom

excelzoom.com - Microsoft Excel, like any other Office product offers it's users simple and intuitive ways to format your data. Many of these formatting options are great for using once or twice, but what if you f...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

A better chart to visualize "Best places to live" – Top 100 cities comparison Excel chart

chandoo.org - It is trying to depict how various cities rank on livability index and how they compare to previous ranking (2014 vs 2009). As you can see, this chart is not the best way to visualize "Best places ...

Date shared: October 8, 2014

Featured in the Business section of the Excel Daily News on October 9, 2014.

 

 

A patently pointless picture - Junk Charts

junkcharts.typepad.com - I am mystified by the intention behind this chart, published in NYT Magazine (Sept 14, 2014). It is not a data visualization since the circles were not placed to scale. The 650 and 660 should have ...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

ABC Analysis using Conditional Formatting in Excel | PakAccountants.com | Free accountancy resources | Video Lectures | Online Forums | Notes | Past papers

pakaccountants.com - ABC analysis is an inventory management technique in which stock is classified in usually three categories on the basis of their importance. Such classification help management to concentrate their...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

ABC Inventory Analysis using Excel | Excel Easy

scoop.it - ABC analysis is a popular technique to understand and categorize inventories. Imagine you are handling inventory at a plant that manufactures high-end super expensive cars. Each car requires severa...

Date shared: October 4, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

Add A Rank Number Field To Your Pivot Table

howtoexcelatexcel.com - When you need to sort and rank a field within a large number of data items it can be confusing to determine the ranking of the data you are looking at if the list is too long, or you may want to tu...

Date shared: October 17, 2014

Error 2042

 

 

Add Spaces to Empty Cells - Excel Zoom

excelzoom.com - We put information from all types of sources into our Excel workbooks, usually just by copying and pasting or by using another program to extract data from a database. In either case, sometimes thi...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Add Values Between Two Dates - Excel Zoom

excelzoom.com - If you are keeping records in an Excel spreadsheet that contains a column for dates and another column for some figure that can be added up, such as sales, you can easily use a formula to add value...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

 

Adding and Displaying Comments to Power Pivot Results in an Excel Pivot Table

powerpivot-info.com - Requirement: Allow users to enter comments after they review results from a Power Pivot model and then show the comment text in the Pivot Table report results. Here's a quick example of the final r...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

Adding calculations WITHIN Pivot Tables

efficiency365.wordpress.com - This article can be read independently, but it is a part of the series which covers a bigger problem. Trying to add formulas OUTSIDE the pivot table manually. Please read these articles to understa...

Date shared: October 15, 2014

Error 2042

 

 

Adding Comments - Excel Zoom

excelzoom.com - Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself. Right click the cell where you want to insert the comment, and begin ty...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Advanced Microsoft Excel Techniques

seminarinformation.com - You may use Excel daily, or maybe only casually, but one thing's for sure—you've probably wished you knew more about this dynamic program. That's why you'll want to attend this workshop. In it, you...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Ageing Analysis (Bucket Analysis) using VLOOKUP – Part 3

efficiency365.wordpress.com - This is a continuation article. Read this article first: Ageing Analysis (Numeric Grouping in Pivot) – Part 2 Earlier we saw how to perform bin analysis using fixed bin size. Now we will see how to...

Date shared: October 19, 2014

Error 2042

 

 

Algorithmia's Online Marketplace for Algorithms - Businessweek

businessweek.com - Innovators: Kenny Daniel and Diego Oppenheimer Ages: Both 30 Co-founders of year-old Seattle startup Algorithmia, which has four full-time workers Form and function: Algorithmia is a marketplace wh...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Alternatives To Spreadsheets - Big Red Cloud

bigredcloud.com - Many small businesses use spreadsheets to run their accounts when they start up. However, moving to an accounting software package can provide your business with a number of advantages and set you ...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

Analytics in Excel, University of Cincinnati

business.uc.edu - Course Description: Excel ?2007 ?or ?higher ?installed ?on ?a ?personal ?laptop ?recommended. This course will introduce intermediate-to-advanced tools in Excel for analytics. We will cover data vi...

Date shared: October 15, 2014

Error 2042

 

 

 

Announcing Power Query support for Salesforce.com - PowerBI - Site Home - MSDN Blogs

blogs.msdn.com - Today, at the Salesforce Dreamforce conference in San Francisco, we announced the preview of a new Salesforce connector for Microsoft Power Query for Excel. With this integration customers can now ...

Date shared: October 17, 2014

Error 2042

 

 

Announcing Power Query support for Salesforce.com - PowerBI - Site Home - MSDN Blogs

blogs.msdn.com - Today, at the Salesforce Dreamforce conference in San Francisco, we announced the preview of a new Salesforce connector for Microsoft Power Query for Excel. With this integration customers can now ...

Date shared: October 16, 2014

Error 2042

 

 

AutoExist and Normalization – SQLBI

sqlbi.com - The autoexist feature used by MDX queries sent to an Analysis Services or Power Pivot data models can have different behaviors depending on the normalization level. This article describes these dif...

Date shared: October 15, 2014

Error 2042

 

 

Automatic Formulas and Formats in Microsoft Excel

officearticles.com - So you wonder how it is that your formulas automatically change, and why Excel has suddenly started picking up not only data, but fill colors and font formatting from other cells? Go to ToolsàOptio...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

Automatically Create an Index for Your Excel File - Excel Zoom

excelzoom.com - Do you want one central location where you can easily navigate to any worksheet in your file, and then navigate back with one click? This macro creates an index that lists all sheets in your workbo...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

AutoSave in Microsoft Excel

officearticles.com - OfficeArtilces.com debuted on May 26, 2005. MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, inc...

Date shared: October 15, 2014

Error 2042

 

 

Avoid Screen Updating - Excel Zoom

excelzoom.com - Do you have a large macro that causes the screen to flash a lot? This can be avoided with two simple lines of code to insert before and after your macro. "Application.ScreenUpdating = False" goes d...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

Avoiding crashes in Excel

excelwithbusiness.com - We have all experienced the classic slow down, freezing, and those dreaded words "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience." This mont...

Date shared: October 16, 2014

Error 2042

 

 

 

Basic file and folder examples using VBA in Microsoft Excel

exceltip.com - Here we have a few examples where we can use files and folders in a vba code.   1. Obtain the active folder path Enter this line of code in your code if you want to obtain the active folder path wh...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

Best Excel Tutorial - 4 Axis Chart

best-excel-tutorial.com - Radar charts, also known as spider charts, web charts or star charts, are used to evaluate multiple alternatives based on multiple criteria. You need to use a radar chart when you have to display m...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

Best Excel Tutorial - AGGREGATE Function

best-excel-tutorial.com - The AGGREGATE function, as the name indicates, returns the aggregate in a list of values. You can perform 19 different operations using this same function and can specify whether error values, hidd...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

Best Excel Tutorial - How to calculate monthly payment?

best-excel-tutorial.com - Excel is the spreadsheet application component of the Microsoft Office. Using Microsoft Excel, you can calculate a monthly payment for any type of loan or credit card. Launch Excel, create a new wo...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

Best Excel Tutorial - How to insert drawing objects?

best-excel-tutorial.com - Insertion of drawing objects can successfully be performed by following these simple steps: Press and hold the left button on the mouse, while moving the mouse to draw the object.

Date shared: October 16, 2014

Error 2042

 

 

Best Excel Tutorial - How to use Excel to Summarize Surveys?

best-excel-tutorial.com - These following steps will easily make you summarize surveys: Note: Response, Friendly, and Waiting are topics that have sub-topics (low and high). If someone checked 2 on a scale of 1 – 5, then th...

Date shared: October 16, 2014

Error 2042

 

 

Best Excel Tutorial - OFFSET function

best-excel-tutorial.com - In this tutorial you will learn how to use the offset function. OFFSET is a function of Excel which allows you to select an area on the basis of selected parameters. OFFSET returns the field - a fi...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

Blackjack / 21 Probability in Excel

xlcalibre.com - This spreadsheet uses macros and formulas to predict odds in the card game Blackjack (aka 21). It deals you random cards one at a time and shows you the probability of your hand value if you hit ag...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

 

Blending "Time of Day" Analysis with Calendar/Date Analysis

powerpivot-info.com - Usually, when we talk about "time" in Power Pivot, we're talking about the Calendar/Date flavor: How much have things changed from yesterday to today. What are our Month to Date numbers, and how do...

Date shared: October 7, 2014

Featured in the Business section of the Excel Daily News on October 8, 2014.

 

 

Bubbles

store.office.com - The Bubbles app for Office lets you visualize your data in a fun and interactive way. Your data is represented as bubbles of different sizes and colors with realistic physics behaviors. Select a ta...

Date shared: October 17, 2014

Error 2042

 

 

Business Deal - Microsoft Excel 2010 for Dummies Blue Square Deals

bluesquaredeals.co.uk - This course covers the basics of creating Excel spreadsheets, creating and using formulas and functions, and formatting worksheets. You will move at your own pace through three interactive lessons,...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Cell References in Formulas - Excel Zoom

excelzoom.com - When you enter a cell reference into the formula bar, you can press the F4 button to make the reference either absolute, mixed, or relative. This helps your formula work as expected when you copy t...

Date shared: October 12, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

Changing the Default Color Palette in Excel - Excel Zoom

excelzoom.com - Excel, by default comes with a standard pre-selected color palette, which is useful, however there are times when those standard colors just won't do. It's possible that your company's colors are n...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Compound Interest in Excel - Easy Excel Tutorial

excel-easy.com - What's compound interest and what's the formula for compound interest in Excel? This example gives you the answers to these questions. 1. Assume you put $100 into a bank. How much will your investm...

Date shared: October 17, 2014

Error 2042

 

 

Computer and IT Training

ahbsolutions.co.uk - Training companies are often seen as ‘one size fits all' centres, making sure you buy what they want to sell, not necessarily the same as what you need. AHB Information Technology Solutions is diff...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

Confirmation Before Execution - Excel Zoom

excelzoom.com - Often times when you execute a macro, the process isn't easily undone. You may have a macro that deletes certain information, or completely reformats your worksheet. In either case, you want to be ...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

 

Count Colored Cells in a List in Excel 2007 - Excel Zoom

excelzoom.com - If you have a list with cells of all different colors, you can apply a filter to those cells to have Excel filter them by color, and then apply a formula to count how many of those cells are visibl...

Date shared: October 16, 2014

Error 2042

 

 

Counter - Excel Zoom

excelzoom.com - Sometimes it is useful to know how many times a macro has been run. For example, if you run a macro once a week to perform a particular task, but don't want it run more than once a week, having a c...

Date shared: October 7, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

COUNTIF Excel Function for Counting Headcount

xlcalibre.com - No HR Dashboard is complete without a headcount summary, and Excel has given us the COUNTIF function to make it easy! It's a pretty straightforward formula – this is how Excel describes it: "Counts...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

CP022: What's a Macro? Introduction to Excel VBA, Macros & Automation

chandoo.org - In the 22nd session of Chandoo.org podcast, lets do some macros. VBA (or macros, automation) is a mystery for many of us. So in this podcast, lets unravel the mystery behind it and get you started ...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 9, 2014.

 

 

Create and Name a New Worksheet - Excel Zoom

excelzoom.com - Say you have a spreadsheet that keeps track of weekly sales information, which you want displayed in a new sheet for each month. You don't want to copy an "original" worksheet each week, so a macro...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Create User Forms - Excel Zoom

excelzoom.com - Have you ever had a spreadsheet, where you wanted users to be able to enter information in a form, and have it populate the next available row in a given set of columns? It's easier than you though...

Date shared: October 18, 2014

Error 2042

 

 

Create/use custom or default sheet templates in Mac Excel

rondebruin.nl - Note : If you use Excel for Windows read the information on this page. If you want to insert a new specific worksheet to your workbook with a nice layout and maybe a few formulas on a regular basis...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Daily Dose of Excel » Blog Archive » PinkyPivotPimping

dailydoseofexcel.com - Well here's something that I probably learned once, but have subsequently forgotten and then rediscovered: You can filter a PivotTable Page Field just by typing the PivotItem that you want to filte...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

 

Data Analytics Consultant, Active Top secret clearance job at Deloitte (US-DC-Washington)

reqcloud.com - Requisition ID: E15ROSCSRCRV10143 Location: US-DC-Washington Deloitte Consulting LLP is one of the world's leading management consulting firms for executable strategy, operations, technology, and h...

Date shared: October 16, 2014

Error 2042

 

 

Data Sort in Excel

trumpexcel.com - Where there is data, there will always be a need to sort it. Excel gives you enough option to slide and dice your data, and a running knowledge of using sorting in Excel could be very useful. You c...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Data Validation to Avoid Duplicate Values - Excel Zoom

excelzoom.com - Suppose you have a spreadsheet where you are entering a list of unique values, such as invoice numbers, customer names, etc. You don't want to duplicate any of the data, as this would cause problem...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Date and Time Function in Excel2010

tutorialstree.com - This step-by-step article describes how to use date and time functions in Microsoft Excel to perform complex date and time calculations. Excel stores all dates as integers and all times as decimal ...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Delete Every Other Row in Excel - Excel Zoom

excelzoom.com - Sometimes you will copy and paste data into a worksheet from another file, a web page, or some other source that isn't formatted the way you want it. Often times there is extra irrelevant data like...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

Delete Rows Based on Criteria in Microsoft Excel

officearticles.com - Suppose you have to delete all the records that contain an N in the Y/N column in the spreadsheet in the graphic. You could use AutoFilter, but that won't always be possible. If you have to do it o...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Delete sheets without confirmation prompts using VBA in Microsoft Excel

exceltip.com - There could be a time when the vba macro / code needs to delete the sheets from the workbook.  It could be one sheet or several.  And excel gives a popup alert to confirm the sheet deletion.  If it...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

Digging into New Custom Maps for Excel Power Map

sqlmag.com - In the latest September round of monthly Power BI updates, a really cool addition for Power Map was released called Custom Maps. Custom Maps empower you to get incredibly creative with regards to y...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

 

Display a message on the statusbar using VBA in Microsoft Excel

exceltip.com - Certain vba macros / codes take a long time to run or execute the actions required. If you have turned off screen updating using the line Application.ScreenUpdating = False at the beginning of your...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Documents, Spreadsheets, Presentations

products.office.com - Work on Office files with anyone, anywhere, in real time—for free. Create, store, and share documents, spreadsheets, presentations, and notebooks online. Collaboration made easy.

Date shared: October 17, 2014

Error 2042

 

 

Dollar General - Job details

sjobs.brassring.com - Responsible for the management of all employees in the effective planning and implementation of all store processes, including ordering, receiving, stocking, presentation, selling, staffing and sup...

Date shared: October 16, 2014

Error 2042

 

 

Drop Down Lists Using Data Validation - Excel Zoom

excelzoom.com - Adding a drop down list to your worksheet allows the users of the worksheet to enter information in a neat, consistent format. For example, say your worksheet asks a user to input information that ...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

Empowering Excel with Table Valued Functions

finaquant.com - We are currently working on an Excel add-in named Finaquant in Excel that will make all the Matrix, Vector and most importantly, Table Valued Functions of finaquant libraries available for Excel us...

Date shared: October 15, 2014

Error 2042

 

 

Escape the Spreadsheet Hell-Events Calendar and Registration

board.com - Do your Excel-based budgeting, planning, and forecasting processes have you drowning in a sea of spreadsheets? Attend this 30-minute webinar and discover how BOARD can simplify and improve your pla...

Date shared: October 14, 2014

Featured in the Business section of the Excel Daily News on October 14, 2014.

 

 

Excel 2007 - Excel Zoom

excelzoom.com - If you are looking to change the number format from a decimal (0.01) to a comma (0,01) Excel typically uses the system defined decimal separator. Depending on which operating system you are using, ...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

Excel 2013: Interface & Environment

tutorialstree.com - Microsoft Excel 2013 is a spreadsheet program from Microsoft Corporation that allows you to store, process, organize, and analyze information & Data. Generally, People Think Microsoft Excel 2013 is...

Date shared: October 11, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

 

Excel Back into an Answer Using Goal Seek

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

Excel Coerce an Array of Dates from 2 Dates

excelarticles.com - Problem: I have a start date in A and an end date in B. I need to see how many days between those two dates fell on Friday the 13th. Strategy: This formula came from the MrExcel.com message board. ...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Excel Excel's Obsession with Security Has Hampered Linked Workbooks

excelarticles.com - Excel's Obsession with Security Has Hampered Linked Workbooks Problem: It used to be easy to set up a link between one workbook and another workbook. When you sent the file to someone else, they ha...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

Excel Formula Errors - Easy Excel Tutorial

excel-easy.com - This chapter teaches you how to deal with some common formula errors in Excel. When your cell contains this error code, the column isn't wide enough to display the value. 1. Click on the right bord...

Date shared: October 13, 2014

Featured in the Science section of the Excel Daily News on October 14, 2014.

 

 

Excel Macro Errors - Excel VBA Easy

excel-easy.com - This chapter teaches you how to deal with macro errors in Excel. First, let's create some errors. Place a command button on your worksheet and add the following code lines: The variable x is not de...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Excel Mall from MrExcel

mrexcel.com - MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warran...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Excel Power Map September update - Office Blogs

blogs.office.com - Each month we strive to improve Excel Power Map with features that matter most to you, so you can tell richer and more creative stories with your data. This month we are rolling out two big feature...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Excel Preserve Column Widths

excelarticles.com - Problem: I've nicely formatted my pivot table, including using narrow column widths. When I choose a new customer from the filter dropdown in B1, Excel changes all of my column widths. Strategy: Th...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

 

Excel Report Diagnostic Display « Contextures Blog

blog.contextures.com - Did you ever print and distribute pivot table reports in Excel, only to discover – too late – that they weren't showing the correct information? To help save you from wasted time and paper, and pos...

Date shared: October 16, 2014

Error 2042

 

 

Excel Roundup 20141006 « Contextures Blog

blog.contextures.com - In this video, Annie Cushing shows how to create a scrolling table, by using the INDEX function and a scroll bar form control. This technique would work nicely in a dashboard, where space is limite...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Excel Roundup 20141013 « Contextures Blog

blog.contextures.com - The Power Map feature was improved last month, and this short video shows some of the things you can do with custom maps in Excel. Or watch on YouTube: 6 Cool Ways To Use Custom Maps in Power Map H...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

Excel Shortcut Keys - Excel Zoom

excelzoom.com - Below, you'll find a fairly comprehensive list of default shortcut keys found on a standard English keyboard in Excel.

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Excel Text Alignment Keyboard Shortcuts

xlcalibre.com - I share many of Michael's sentiments but he gives Microsoft way too much credit . What brought me to this page was being forced to locate a keystroke combination for Excel to make my life easier in...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

Excel Tutorial- Add Your Own Macros To The Excel Ribbon Tab

howtoexcelatexcel.com - In Excel 2010 onwards you can create your own Ribbon Tabs as well as add your own Macros to them! Let's learn how really easy this is to do. This is really useful if you have a set of commands you ...

Date shared: October 15, 2014

Error 2042

 

 

Excel Twitter 20141010

exceltheatre.com - Don't spend all day coloring the cells, or you'll never become an Excel programming wizard. cdhowe, kikibunny_, agharvey1014, ericfbrinkley, Chimiel82, gwestr, leeshakanbour, taylor_gamble17, NCook...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

Excel Use a Laser Printer to Have Excel Calculate Faster

excelarticles.com - Use a Laser Printer to Have Excel Calculate Faster Problem: How can I speed up my Excel calculations? Strategy: Believe it or not, Excel uses your print driver to draw the screen. Having an HP Lase...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

 

Excel VBA Variables - Easy Excel Macros

excel-easy.com - Integer    |   String    |   Double    |   Boolean This chapter teaches you how to declare, initialize and display a variable in Excel VBA. Letting Excel VBA know you are using a variable is called...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Excel Video Tutorials from MrExcel | Learn Excel 2010 - "Picture Lookup": Podcast #1485

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Excel Video Tutorials from MrExcel | Learn Excel 2010 "Dynamic Pictures": Podcast #1417

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Excel Video Tutorials from MrExcel | MrExcel's Learn Excel #845 - Stacked Column 3

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

Excel Video Tutorials from MrExcel | MrExcel's Learn Excel #873 - First Macro

excelarticles.com - Rick asks how to get started with VBA. In Episode 873, I show a horribly formatted file that someone in my Power Excel audience has to deal with daily. A mac...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Excel Video Tutorials from MrExcel | MrExcel's Learn Excel #884 - HLOOKUP with VLOOKUP?

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

Excel Video Tutorials from MrExcel | MrExcel's Learn Excel #938 - Excel Is Fun

excelarticles.com - If you like my videos, check out the YouTube channel EXCELISFUN. Mike Gel Girvin has an amazing collection of enthusiastic Excel Videos on YouTube. Also in E...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Excel Video Tutorials from MrExcel | MrExcel's Learn Excel #965 - Two-Way Lookup

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

 

Excel Video Tutorials from MrExcel | PowerPivot Data Analyst 12 - Asymmetric Reporting

excelarticles.com - ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied ...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

Excel Video Tutorials from MrExcel | PowerPivot Data Analyst 5 - Creating Relationships

excelarticles.com - This episode shows you how to manually define a relationship between two tables in PowerPivot. This video is designed to accompany the book, PowerPivot for t... Keywords for this video: Excel, busi...

Date shared: October 15, 2014

Error 2042

 

 

Excel Video Tutorials from MrExcel | PowerPivot Data Analyst 7 - Compact vs Flattened

excelarticles.com - I hate the compact view for pivot tables. The PowerPivot team gives us Flattened pivot tables. This video is designed to accompany the book, PowerPivot for t...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Excel Video Tutorials from MrExcel | Understand GetPivotData - 1127 - Learn Excel from MrExcel

excelarticles.com - Rather than turn off the evil GetPivotData like we did yesterday, how about trying to understand what GetPivotData actually does? Episode 1127 shows you how

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Excel VLOOKUP function – how do I use that again?

itbrigadeinc.com - Every time I use VLOOKUP in Excel, I have to go lookup how to use it again.  This tutorial is aimed at being a handy reference for that situation. To setup VLOOKUP in Excel setup a list of items wh...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

Excel VLOOKUP function for currency conversion

xlcalibre.com - VLOOKUP is an essential Excel tool. Even if it's the first function you learn, don't worry, it's actually pretty straight forward, and is really useful. The purpose of the VLOOKUP function is to fi...

Date shared: October 10, 2014

Featured in the Business section of the Excel Daily News on October 11, 2014.

 

 

Excelerate Masterclass: Power BI for Office 365- Eventbrite

eventbrite.com.au - Wyn gained his Chartered Accountant qualification in 2000 at PwC (UK). He has extensive international business analyst experience, having worked with a variety of UK's FTSE 100 financial services c...

Date shared: October 14, 2014

Featured in the Business section of the Excel Daily News on October 14, 2014.

 

 

Favorite Power Pivot Resources

tinylizard.com - This post is just a list of what helped me grow my Power Pivot skills… well, other than trial by fire.    If I have missed any awesome resources, let me know in the comments!

Date shared: October 7, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

 

FeedBurner Email Subscription

feedburner.google.com - …will receive a verification message once you submit this form. FeedBurner activates your subscription to "Excel » PakAccountants.com" once you respond to this verification message. To help prevent...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Financial Modeling: From Paper and Pens, to Excel - Intralinks DealcloserBlog

blogs.intralinks.com - To be successful in business, every company needs to make informed business decisions – and that's where modeling comes in. Some might consider financial modeling to be the art of finding a solutio...

Date shared: October 16, 2014

Error 2042

 

 

Find and fix a circular reference

support.office.com - At times, you may want to use circular references because they cause your functions to iterate—repeat until a specific numeric condition is met. This can slow your computer down, so iterative calcu...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

f-keys - Excel 2013 Time Saver, Tips & Tricks Seminar-Microsoft Excel 2007/2010/2013/Office 365

f-keys.co.uk - This Microsoft seminar will provide attendees with a taste of the many time saving tips and tricks and a number of powerful features and functions that can be found in Microsoft Excel 2013/Office36...

Date shared: October 4, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Format and customize Excel 2013 charts quickly with the new Formatting Task pane - Office Blogs

blogs.office.com - The new Excel offers a rich set of charting capabilities that make creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane.   Un...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

Formula Friday- Excel Tip- Generate Random Numbers With Excel.

howtoexcelatexcel.com - Hello again it's time for more Formula Friday frolics. Today let's look at generating random numbers with Excel.  This function in Excel can be used for lots of reasons, one of the main reasons I t...

Date shared: October 17, 2014

Error 2042

 

 

Freakalytics® | Strategic analytics, forecasting & visualization for smarter choices & greater profits

freakalytics.com - Dieter Rams is a German industrial designer most closely associated with the minimalist designs of the consumer brand Braun. Dieter was head of design at Braun for over 30 years, where he became fa...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

From SQL to DAX: Grouping Data – SQLBI

sqlbi.com - The GROUP BY condition of a SQL statement is natively implemented by SUMMARIZE in DAX. This article shows how to use SUMMARIZE and an alternative syntax to group data. Consider the following SQL qu...

Date shared: October 7, 2014

Featured in the Business section of the Excel Daily News on October 8, 2014.

 

 

 

Generate a Random Character String - Excel Zoom

excelzoom.com - You may find yourself faced with a need to generate a ton of random strings of characters. For example, you may have a list of usernames that need passwords – you could be lazy and say everyone's p...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

Getting the most value out of Microsoft Excel - ctc TrainCanada

traincanada.com - There are a number of advanced, useful functions within the program that are often unacknowledged. Taking a short Microsoft training course that comprehensively breaks down every aspect of the solu...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Goal Seek to Break Even - Excel Zoom

excelzoom.com - Recently I found myself deciding if I should sell some stock in order to provide a little extra cash to my bank account.  I purchased shares of the company's stock four times in various quantities,...

Date shared: October 4, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

Gridlines On/Off - Excel Zoom

excelzoom.com - Have you ever set the fill color of an entire sheet (or workbook) to white just because you didn't want to see the gridlines? Well if you have a large file, you could literally reduce the file size...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

Grouping Text in Pivot Tables

efficiency365.wordpress.com - Use this file to follow along… Download Sample Data This data contains simple transactional data about Accounts Receivable. Open the file and understand the columns. Each row represents some invoic...

Date shared: October 15, 2014

Error 2042

 

 

Happy Spreadsheet Day 2014 – Spreadsheet Day

spreadsheet-day.com - This is the 25th anniversary of the VisiCalc launch date, so I hope that you have some special celebrations planned. Spreadsheet Day is now listed in the Days of the Year website, so you can show t...

Date shared: October 17, 2014

Error 2042

 

 

Here's why you should use Office for iPad - Office Blogs

blogs.office.com - Aaron Wilson is a senior program manager on the Office for iPad team. Hi all – I want to let you know that our whole team is excited to see how much people enjoy using the Office for iPad apps. Our...

Date shared: October 9, 2014

Featured in the Technology section of the Excel Daily News on October 10, 2014.

 

 

Heroes of Visualization: John Snow, H.W. Acland, and the Mythmaking Problem |

peachpit.com - Figure 1 John Snow's 1854 cholera outbreak map, my favorite information graphic. Every human community—nations, ethnic and cultural groups, professional guilds—inevitably raises a few of its member...

Date shared: October 16, 2014

Error 2042

 

 

 

Highlight Alternating Rows With Conditional Formatting - Excel Zoom

excelzoom.com - You can apply conditional formatting to your sheet that will allow you to format every other row however you specify. Select the area where you want to highlight alternating rows. Go to the Format ...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Holy Macro Books Shop

e-junkie.com - A fun book about Microsoft Excel. It covers using Excel for a variety of simulations - from Gambling to Genetics. Offers a solid introduction to using Microsoft Excel Simulations in the disciplines...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

How about a FIRSTDATE()? « PowerPivotPro

powerpivotpro.com - I am, like most (if not all) visitors to this website, an addict for information –> data –> truth –> ?µpe???a <-hope that sounds like Greek to you… My journey into Power Pivot has been one of uphil...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

How strong is Microsoft Excel encryption? - Telegraph

telegraph.co.uk - Up to Excel 2000 encryption was weak and could be broken in a matter of seconds using widely available utilities on the web. It was strengthened significantly in Excel 2002/3, and changing from the...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

How to add a Google translator in WordPress

tutorialstree.com - How many of us know Mandarin or German or French or even Arabic? Adding a language translator can make your website more popular. For a business website a language translator is very effective beca...

Date shared: October 12, 2014

Featured in the Technology section of the Excel Daily News on October 12, 2014.

 

 

How to Add and Remove Bookmarks in Word 2013

tutorialstree.com - Bookmarks are a great way to organize large documents since they help make it easier for readers to access different parts of the document. If you learn how to add and remove bookmarks in Word 2013...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

How to add Google adsense codes in wordpress posts and home page

tutorialstree.com - In this tutorial I will show how to add Google adsense codes in your home page and blog posts. The screenshot shows a sample website with a basic wordpress theme. I am going to add a Google adsense...

Date shared: October 18, 2014

Error 2042

 

 

How to Annotate an Image in Word 2013

tutorialstree.com - Learning how to annotate an image in Word 2013 is extremely useful when you want to convey as much information was possible through images. Annotations are descriptive labels that are normally atta...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

 

How to change the Worksheet Tab Colour in Microsoft Excel 2013 - The IT Training Surgery

theittrainingsurgery.com - When you have many worksheets, it can be helpful to change the tab colour so that the one you want is easy to recognize. Figure – Different coloured tabs help identify worksheets How will this help...

Date shared: October 16, 2014

Error 2042

 

 

How to Compare Worksheets in Excel 2013

tutorialstree.com - Comparing spreadsheets with a lot of data can be confusing if one does not know how to compare worksheets in Excel 2013. This innovative feature lets you place multiple worksheets side-by-side so t...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

How to Convert Text from a PDF into an Editable Document in Word 2013

tutorialstree.com - How to Convert Text from a PDF into an Editable Document in Word 2013 Among the many new features that Word 2013 has to offer, the ability to convert text from PDF files into editable word document...

Date shared: October 18, 2014

Error 2042

 

 

How to Create a Calendar in Excel - Excel Zoom

excelzoom.com - It's always useful to have a calendar in Excel. Having one lets you save it on a shared network drive, so everyone involved in a particular project knows what's going on and important dates coming ...

Date shared: October 19, 2014

Error 2042

 

 

How to Create a List of Random Numbers in Excel 2013

tutorialstree.com - How to Create a List of Random Numbers in Excel 2013 You never know when you will need a list of random numbers in life, which is why it can't hurt to learn how to create a list of random numbers i...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

How to Create a PivotTable in Excel 2013

tutorialstree.com - PivotTables are a great way to summarize your data. Many people shy away from using them because they don't know how to create a PivotTable in Excel 2013. This step-by-step guide on how to create a...

Date shared: October 18, 2014

Error 2042

 

 

How to create a scrollable Text Box in PowerPoint 2013

tutorialstree.com - How to create a scrollable Text Box in PowerPoint 2013. Sometimes you have too much text to add in slide and you would rather want it fitted in one slide that continuing the text in other slide. Th...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

How to create Charts in Word 2013

tutorialstree.com - A dialog box opens which lists different types of Charts and Graphs that can be created A sample Excel worksheet opens which lists some variables.  A Chart is also inserted in your Word document.  ...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

 

How to insert an Image in Word 2013

tutorialstree.com - How to insert an Image in Word 2013.  Many times you may want to insert files to improve your presentation.   This can make your documents aesthetically pleasing and effective.  This is probably on...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

How to Merge an array into Single cell

mrexcel.com - This is a discussion on How to Merge an array into Single cell within the Excel Questions forums, part of the Question Forums category; This might look simple but it is not . How can you merge the ...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

How to Mix Different Oil Painting Filters in Photoshop CS6

tutorialstree.com - How to Mix Different Oil Painting Filters in Photoshop CS6 As we know, one of the new features in Photoshop CS6 is the Oil Paint filter. It is a nice filter that allows you to create a very effecti...

Date shared: October 11, 2014

Featured in the Technology section of the Excel Daily News on October 12, 2014.

 

 

How to prevent Document Editing in Word 2013

tutorialstree.com - How to prevent Document Editing in Word 2013. Many times when you finished writing, you wish marking your document as Final and prevent editing of the document by other people. Word 2013 presents y...

Date shared: October 19, 2014

Error 2042

 

 

How to record a Macro in Excel 2010

tutorialstree.com - Macro in Excel 2010 allows you perform multiple operations. It helps to work in a smart and efficient way. By this tool we can reduce manual work and get the things done very fast. In Excel 2010 we...

Date shared: October 10, 2014

Featured in the Business section of the Excel Daily News on October 11, 2014.

 

 

How to Record Macros in Excel 2013

tutorialstree.com - Macros are extremely useful for users who perform repetitive tasks in spreadsheets. This guide on how to record macros in Excel 2013 will walk you through the process of setting up your own macro f...

Date shared: October 12, 2014

Featured in the Business section of the Excel Daily News on October 12, 2014.

 

 

How to Reveal Formatting in Word 2013

tutorialstree.com - Sometimes it is useful to know exactly what the formatting of a particular document is so that you can reuse it at another time. If you learn how to reveal formatting in Word 2013, you can see your...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

How to Start Multiple Animation Sequences in PowerPoint 2013

tutorialstree.com - How to Start Multiple Animation Sequences in PowerPoint 2013 If you have several animations within your PowerPoint presentation, you don’t need to worry about having to manually make sure each of...

Date shared: October 11, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

 

How to Use Solver in Excel - Excel Zoom

excelzoom.com - Solver is an add-in tool that lets you find solutions to various problems. You can use solver in Excel to run through "what-if" scenarios that might help you determine the best course of action. Th...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

How to Use the Content Aware Extend Tool in Photoshop CS6

tutorialstree.com - How to Use the Content Aware Extend Tool in Photoshop CS6 Photoshop CS6 has many content-aware tools that have proved to be very useful. One of them is Content-aware extend tool that allows us to e...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

How to Use the New Crop Tool in Photoshop CS6

tutorialstree.com - When you start to crop in Photoshop CS6, you will notice that it is very much different, even strange and very uncomfortable. But it just seems that way. The tool is actually made much more comfort...

Date shared: October 17, 2014

Error 2042

 

 

How to Use the New Oil Paint Filter in Photoshop CS6

tutorialstree.com - How to Use the New Oil Paint Filter in Photoshop CS6 1.  Photoshop CS6 came with many new features, one of them being the oil paint filter that allows you to turn your picture into a nice painting....

Date shared: October 17, 2014

Error 2042

 

 

How to Use VLOOKUP Function in Excel 2013

tutorialstree.com - You might know how to use the Find feature in Excel 2013, but it is not always effective when you want to find very specific information from large tables. Learning how to use VLOOK UP Function in ...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

How'd You Do That? Create an Excel Survey - Microsoft Citizenship Asia Pacific - Site Home - TechNet Blogs

blogs.technet.com - This post is part of a series offering technology tips and tricks to help you work more efficiently and help organisations get the most out of IT. Office 365 has many useful features that you may n...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

HR Dashboard Interactive Employee Relations Summary

xlcalibre.com - On an HR Dashboard or Balanced Scorecard it can be useful to show a summary of recent employee relations case work, things like disciplinaries, grievances, long term sickness, redundancies, materni...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

Importing related MySQL tables into an Excel Data Model using MySQL for Excel (MySQL on Windows)

blogs.oracle.com - In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, you can install the latest GA or maintenance version using the MySQL Installer or optionally y...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

 

Install and Use Macros - Excel Zoom

excelzoom.com - So you've found the perfect macro code to speed up that tedious and repetitive task – now what? In this section, we'll walk you through the several ways to install and use your macro code. First, M...

Date shared: October 4, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

Introducing…Structured References for PivotTables

chandoo.org - Howdy folks. Jeff here, bringing you a Public Service Announcement: Thanks to the magic of VBA , Structured PivotTable References are coming to a PivotTable near you! Structured References for Pivo...

Date shared: October 18, 2014

Error 2042

 

 

Job Board Powered by Bullhorn

cls6.bullhornstaffing.com - Accuro is searching for a Cost Engineer in Charlotte, NC for our client, one of the most respected energy companies in the country. ·       Perform cost analysis for a portfolio of projects budgete...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

Learn all about Data Validation in Excel

trumpexcel.com - Data Validation in Excel lets you control the data that can be entered in a cell. You can restrict the user to enter only the allowed range of numbers or text or date. You can also use Data Validat...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Learn how to sort the Records : Rows in Microso...

scoop.it - Learn how to sort the Records : Rows in Microsoft Excel When there are hundreds or thousands of records / records, there will be times when you will want to ...

Date shared: October 4, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Linked Small Multiples

flowingdata.com - Jim Vallandingham is a programmer and data analyst currently working in the Nordstrom Data Lab as a data visualization engineer. He is interested in interactive interfaces to data that allow for ex...

Date shared: October 15, 2014

Error 2042

 

 

Logical Functions in Excel 2010

tutorialstree.com - Logical functions are used for decision making in spread sheet. There are seven logical functions in Excel 2010 which return whether the logical true or logical false. Follow the below steps to ide...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Microsoft and Salesforce Unveil New Joint Solutions at Dreamforce 2014

cnbc.com - SAN FRANCISCO, Oct. 13, 2014 /PRNewswire/ -- DREAMFORCE 2014 -- Microsoft Corp. (Nasdaq: MSFT) and Salesforce (NYSE: CRM) today announced significant progress in their strategic partnership announc...

Date shared: October 14, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

 

Microsoft Excel - Fundamentals

parallelbranch.com - A core-level candidate for the Microsoft Excel 2013 exam should have a fundamental understanding of the Excel environment and the ability to complete tasks independently. They should know and demon...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Microsoft Excel - Fundamentals by Parallel Branch Inc

udemy.com - We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach t...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Microsoft Excel: Become a Power User

seminarinformation.com - A skill-boosting one-day workshop designed specifically for those who've mastered Excel's fundamentals and are ready to get the tools required to become a "power user"! This skill-boosting one-day ...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

Microsoft Launches New Office 365 Subscription Plans For Small And Midsize Businesses

techcrunch.com - Microsoft is rolling out new Office 365 plans for companies with fewer than 250 employees that will slowly replace the company's existing plans for small and midsize businesses. The company had alr...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Microsoft New York Visits

modeloff.com - As part of the ModelOff New York Finals in December 2014, Microsoft Excel will be sending some of the best and brightest from their Product Development Team to meet with the New York Finance, Banki...

Date shared: October 15, 2014

Error 2042

 

 

Microsoft Office 2010 - Excel Zoom

excelzoom.com - For all of you out there still wondering where the "File" menu is in Excel 2007 and other Office 2007 products, another twist is in store for you.  Microsoft announced earlier this week that they a...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Microsoft Office Tip: How to use the Macro Recorder in Excel

velocityns.com - Recording macros is an easy way to repeat tasks over and over. Keep in mind that the macro recorder is limited. If you wanted the macro to insert a new column between A and B, for example, that is ...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

Mitie acquires leading screening company Procius

mitie.com - Mitie Group plc ("Mitie"), the strategic outsourcing company is pleased to announce that it has today acquired Procius Limited ("Procius"), a leading UK pre-employment screening company, from the m...

Date shared: October 16, 2014

Error 2042

 

 

 

Monday, October 13th | 6:30pm-8:00pm | Introduction to Excel – Rochester Brainery

rochesterbrainery.myshopify.com - Whether you are comparing lists, making financial decision, bookkeeping, performing time management, tracking inventory or charting experimental results, Microsoft Excel is the premier tool for man...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

Move Selection - Excel Zoom

excelzoom.com - These macros change the default direction after pressing enter, of down, to whichever direction you specify. Particularly useful if entering data across several columns rather than down a single ro...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

Multiply by X (Keep Formula) - Excel Zoom

excelzoom.com - This macro has the same functionality of the "Multiply by X" macro, however it allows you to keep your formulas in tact, by simply adding *1000000 (or whatever value you specify) to the end of the ...

Date shared: October 17, 2014

Error 2042

 

 

My Connection List Is Not Working - Bubblews

bubblews.com - For months I maintained an excel worksheet with my real connections on it. That list contains the profile URL for each of them. In the past I would click on the URL and it would open in my browser ...

Date shared: October 11, 2014

Featured in the Technology section of the Excel Daily News on October 12, 2014.

 

 

MySQL for Excel 1.3.2 GA has been released (MySQL on Windows)

blogs.oracle.com - The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can be used for production environments. MySQL for Excel is a...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 9, 2014.

 

 

Named Ranges in Microsoft Excel

officearticles.com - Names ranges can be very useful. Some people argue that point, whether using named ranges in VBA or formulas. The most common problem regarding names ranges, everyone agrees, is user ignorance of t...

Date shared: October 17, 2014

Error 2042

 

 

Negative Cell Value - Excel Zoom

excelzoom.com - This macro takes whatever values are in a selected range of cells and multiplies them by -1. This is especially useful for accountants who might get a list of client data as absolute values. In acc...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

New Dark Interface in Photoshop CS6 – How to Customize It

tutorialstree.com - New Dark Interface in Photoshop CS6 – How to Customize It First thing everyone will notice about Photoshop CS6 is the new dark interface. For many, it is already a topmost favorite feature since th...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

 

No Worksheet Appears in Microsoft Excel

officearticles.com - OfficeArtilces.com debuted on May 26, 2005. MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, inc...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Office Open XML Example–Mortgage Payment Spreadsheet

itbrigadeinc.com - This is a .NET User Control written in C# which computes a mortgage payment for a given loan amount, interest rate, and loan duration.  It uses the standard amortization equation to determine your ...

Date shared: October 10, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

Pareto Chart in Excel - Easy Excel Tutorial

excel-easy.com - A Pareto chart combines a column chart and a line graph. The Pareto principle states that, for many events, roughly 80% of the effects come from 20% of the causes. In this example, we will see that...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

PASS Summit 2014 > Sessions > Details

sqlpass.org - Track: BI Platform Architecture, Development & Administration

Date shared: October 8, 2014

Featured in the Business section of the Excel Daily News on October 9, 2014.

 

 

PC Tips, Tricks and questions - Microsoft Office, Excel, Access

linkedin.com - Private group. To request membership, click Join and your request will be reviewed by the group manager. This group was set up to publish some of my favourite shortcuts, tips and tricks when using ...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

Pétition · Make Power Pivot freely available in all editions of Microsoft Office 2013 & Office 365 · Change.org

change.org - Free Power Pivot!  Make Power Pivot freely available in all editions of Microsoft Office/Excel 2013/365 and beyond. Power Pivot was a free add-in for Excel 2010 and "the best thing to happen to Exc...

Date shared: October 17, 2014

Error 2042

 

 

Pivot : Show Values As – Part 3

efficiency365.wordpress.com - We are exploring the built-in capabilities of Pivot Tables. We saw how data can be converted to percentages and it can be shown in different ways. We also explored multi-level percentages using % o...

Date shared: October 15, 2014

Error 2042

 

 

Pivot Table Intro and Resources

pivot-table.com - Many years, and thousands of pivot tables ago, I wrote a couple of articles for Jon Peltier's Excel charting website. Jon has been updating his website, and asked me to write new versions of those ...

Date shared: October 8, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

 

Pivot: Running Totals and Ranking

efficiency365.wordpress.com - This article belongs to a series. Read the earlier three articles before reading this one. Adding formulas OUTSIDE Pivot Tables = Inefficiency Pivot Table – Show Values As – Part 2 Pivot : Show Val...

Date shared: October 15, 2014

Error 2042

 

 

Preparing For a World Where Branches Matter Less

thefinancialbrand.com - Mobile banking is forcing financial institutions to rethink everything about their branch networks. But your ability to effectively compete hinges entirely on whether consumers think they'll have t...

Date shared: October 8, 2014

Featured in the Business section of the Excel Daily News on October 9, 2014.

 

 

Prevent Pivot Table Bloating in Excel

howtoexcelatexcel.com - Excel takes a snapshot of your data set when you create a Pivot Table report and stores it in a pivot cache.  This is just an area where your data source is duplicated for easy access, this is impo...

Date shared: October 13, 2014

Featured in the Science section of the Excel Daily News on October 14, 2014.

 

 

Print Custom Views - Excel Zoom

excelzoom.com - Custom views are a useful way to set, all sorts of ways to view your data, including print areas. You can set up a sheet to have several custom views set to print different areas of your worksheet....

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

Protecting Worksheets in Excel 2013

tutorialstree.com - Sometimes you may require to protect your important worksheets from misuse & theft. in this post, you are going to learn how to protect your Worksheet in Excel 2013 from unauthorized access. There ...

Date shared: October 11, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Quick Access Toolbar,Backstage View & Auto-Recovering Files in Excel 2013

tutorialstree.com - Did you know? Excel 2013 automatically saves workbooks on you are working to a system defined temporary folder. Sometimes, if you forget to save the changes & Excel crashes or Other Errors occur, y...

Date shared: October 18, 2014

Error 2042

 

 

Random Numbers in Excel - Excel Zoom

excelzoom.com - Sometimes it is useful to be able to generate random numbers in Excel that are limited to a certain range. Maybe you have an "employee of the month" contest and you just can't pick one. Assign a nu...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Randomize and mix table for study purpose

mrexcel.com - Thanks Rick would you please explain the detail. I am really sorry I am not really good in excel. Thank you very much for your help.. HOW TO INSTALL MACROs ------------------------------------ If y...

Date shared: October 16, 2014

Error 2042

 

 

 

Reinventing an Industry: Welcome Avi Singh! « PowerPivotPro

powerpivotpro.com - GENERAL MADINE:  "General Solo, is your Strike Team Ready?" SOLO:  "We're making huge strides.  The Death Star is Toast." File under "Coup, Major."  Folks, this is a CRAZY cool moment for us at Pow...

Date shared: October 16, 2014

Error 2042

 

 

Reminder: Live Class in Philly in < 2 Weeks « PowerPivotPro

powerpivotpro.com - Final Reminder:  I Will Be in Philadelphia Oct 21-22, Teaching a Two-Day Class (at the Microsoft Facility in Malvern, specifically) This entry was posted on Friday, October 10th, 2014 at 1:30 pm an...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Remove Hyperlinks - Excel Zoom

excelzoom.com - Whenever copying a list into Excel from the internet, you run the risk of pasting in unwanted hyperlinks. Sure, you could paste special as text, but sometimes it's format was just fine the way it w...

Date shared: October 12, 2014

Featured in the Science section of the Excel Daily News on October 12, 2014.

 

 

Remove Personal Information From Excel 2007 - Excel Zoom

excelzoom.com - Sometimes, it's useful to be able to remove personal information from your workbook, in the event that you're sending the file to someone else, whether it's someone from another company, posting it...

Date shared: October 17, 2014

Error 2042

 

 

Return all Characters in a Font - Excel Zoom

excelzoom.com - When you use a regular keyboard, you get plenty of options when it comes to the characters you get to type. In most cases the upper and lowercase letters, 0-9, and all of the symbols available to y...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Revenue explosion from iPad for Office fails to ignite - PC Advisor

computerworld.com - Contrary to some experts' expectations, Microsoft hasn't been "printing money" since it launched Office for iPad in March. Although Microsoft has touted the number of downloads of Office for iPad -...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Run Macro At a Specified Time - Excel Zoom

excelzoom.com - Using the Application.OnTime Method will allow you to schedule a macro to be run at a specified time. The specified time can be either after certain amount of time has passed, or at a certain time ...

Date shared: October 6, 2014

Featured in the Business section of the Excel Daily News on October 7, 2014.

 

 

Run Macro Automatically on Open - Excel Zoom

excelzoom.com - Insert your macro code into a module, start with Sub Auto_Open(). Enter whatever commands you wish to have executed on opening the file and end with End Sub. Copy all of the code below. Paste it in...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

 

Saving an entire Excel workbook to a pdf | Exce...

scoop.it - By default if you save from Excel to pdf, it just saves the worksheet you currently have selected. However, you can save the whole workbook as one pdf. If using Microsoft Excel 2007: Click the Offi...

Date shared: October 4, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Saving Multiple Print Ranges in Excel - Excel Zoom

excelzoom.com - Sometimes we setup Excel worksheets so that they flow logically on the screen. Often times they're set up like you would read a book, top to bottom, left to right, but this isn't always the best se...

Date shared: October 13, 2014

Featured in the Science section of the Excel Daily News on October 14, 2014.

 

 

Send Email From Excel + FREE Email Generator Tool

trumpexcel.com - Yes its True! You can send email from Excel by using the HYPERLINK function. In this blog post, I will show you various ways to use HYPERLINK function to send email from Excel. There is also a bonu...

Date shared: October 16, 2014

Error 2042

 

 

Send Emails From Excel - Excel Zoom

excelzoom.com - Often times you'll find yourself working on a file in Excel that needs to be sent to a co-worker as an attachment. If you store your files on a shared network drive, it could take a little while to...

Date shared: October 4, 2014

Featured in the Business section of the Excel Daily News on October 5, 2014.

 

 

Set Excel Zoom Level - Excel Zoom

excelzoom.com - OK, so your co-worker or boss has one of those enormous monitors, and you're stuck working on this little tiny laptop screen. Every time they open a file, they change the zoom setting to 50%, becau...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Show Color With Conditional Formatting « Contextures Blog

blog.contextures.com - I like to color data entry cells, so they're easy to spot on an Excel worksheet. If you know that you should type a value in every blue cell, it's quicker, and safer, to fill in a worksheet. Recent...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Show Leading Zeroes in Microsoft Excel

officearticles.com - Choose the cells, column, or row. Go to FormatàCells. On the Numbering tab, choose Custom under Category, and in the Custom dialog box, type the number of digits you want to use in your data, thusl...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

Sign up for Square

squareup.com - Link your bank account so we can deposit the funds you receive from card payments. Refer to your checkbook or bank website to get your account and routing numbers. Once your bank account is verifie...

Date shared: October 10, 2014

Featured in the Business section of the Excel Daily News on October 11, 2014.

 

 

 

simple code for Export Excel using vb.net with telerik button « scriptquery

scriptquery.blogspot.com - Export Excel ------------:- step:1 ------ step:2 ------- if incase the control is in update panel we need write below the content template step3: ------ Protected Sub btnExportExl_Click(sender As O...

Date shared: October 19, 2014

Error 2042

 

 

So farewell then Lotus 1-2-3, spreadsheet extra...

scoop.it - It had to come. Lotus 1-2-3, the spreadsheet that galvanised a generation is at last no more as IBM announces the end of support for the final version of the software.

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

Split a Worksheet Into Multiple Panes - Excel Zoom

excelzoom.com - You can split a worksheet area into vertical and/or horizontal panes so that you can click inside any one pane and scroll to locate information in that pane while the other panes remain in place. D...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

spreadsheet Bromley | custom spreadsheets, Beckenham

spreadsheetsolutions.pw - Welcome to the Spreadsheet Solutions Online Store. We work a little differently here, although we do like to create custom spreadsheet software, we also know that we have created these documents wh...

Date shared: October 9, 2014

Featured in the Business section of the Excel Daily News on October 10, 2014.

 

 

Spreadsheet Mistake Costs Tibco Shareholders $100 Million - MoneyBeat - WSJ

blogs.wsj.com - That's the lesson Tibco Software Inc. and Goldman Sachs Group Inc. learned in the software company's more than $4 billion sale to Vista Equity Partners, which is paying about $100 million less in t...

Date shared: October 18, 2014

Error 2042

 

 

Stock Tile

store.office.com - Stock Tile is a free, simple financial tool that displays the price of a stock in real time. Use it for finance-related spreadsheets and presentations. You can insert the app in an Excel workbook o...

Date shared: October 15, 2014

Error 2042

 

 

Sum the Same Cell in Multiple Microsoft Excel Worksheets

officearticles.com - Few people know how to do this, but once you learn, you'll never forget. Suppose you have twelve worksheets named January through December. You want to sum the total of cell A2 of all these workshe...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

Sum Values In A Month - Excel Zoom

excelzoom.com - Sometimes we get data in Excel that makes it somewhat difficult to look at the big picture. For example, you might get a list of transactions with a date and sale price. Let's say you need to sum v...

Date shared: October 15, 2014

Error 2042

 

 

 

Taking the Data Validation Dropdown list to the next level

excelunplugged.com - In this article I will show you how to create dependent Dropdown lists using Data Validation and an Excel function called Indirect. First let's take a look at what we are trying to accomplish. We w...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

The amazing Calculated Items in Pivot Tables

efficiency365.wordpress.com - Please read the previous article about Calculated Items before you read this article. Each column is called a FIELD and data inside it is called ITEMS. New fields can be created by using a formula ...

Date shared: October 15, 2014

Error 2042

 

 

The Functional Art: An Introduction to Information Graphics and Visualization: Don't call yourself an infographics designer if what you do is data decoration

thefunctionalart.com - The title of this post came to my mind after seeing the graphic below, published in a cars magazine (1). It puzzles me that the creators of these things call themselves "infographics" designers. Ar...

Date shared: October 4, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

The new Content Aware Patch Tool in Photoshop CS6

tutorialstree.com - Patch tool is not a new feature in Photoshop CS6, but Patch tool with content-awareness is! This tutorial will show you how to transform your regular Patch tool into a powerful and helpful one. Pat...

Date shared: October 4, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

Tips to speed up working with large Excel worksheets - Curah!

curah.microsoft.com - Excel is without doubt a very powerful spreadsheet application and arguably the best in the world. However, many people often design their spreadsheets with no foresight at all. This means most spr...

Date shared: October 14, 2014

Featured in the Business section of the Excel Daily News on October 14, 2014.

 

 

TODAY, YEAR, MONTH, DAY, DATE (an introduction to Excel date functions)

xlcalibre.com -  This post will teach you five Excel functions to help you deal with dates. We will work our way through in the order that they are shown in the picture above. =TODAY(). That's it. That's all you h...

Date shared: October 17, 2014

Error 2042

 

 

Tom's Tutorial For Excel: COUNTIF and SUMIF with wildcards

atlaspm.com - Tom's Tutorial For Excel: COUNTIF and SUMIF with wildcards You can use wildcard characters with functions to return specific information. For example, the wildcard "?" character represents any sing...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Tom's Tutorials For Excel: Conditionally Formatting a Specific Weekday Date

atlaspm.com - Tom's Tutorials For Excel: Conditionally Formatting a Specific Weekday Date In Excel, the 7 days of the calendar week can be identified by their index number using the WEEKDAY function, starting fr...

Date shared: October 18, 2014

Error 2042

 

 

 

Tom's Tutorials For Excel: Converting an Elapsed Time to a Decimal Number

atlaspm.com - Tom's Tutorials For Excel: Converting an Elapsed Time to a Decimal Number Some employers pay their employees based on work time that is measured in decimals as portions of an hour. For example, if ...

Date shared: October 15, 2014

Error 2042

 

 

Tom's Tutorials for Excel: Delete Hyperlinks, Keep Their Text

atlaspm.com - Tom's Tutorials for Excel: Delete Hyperlinks, Keep Their Text At some point you have probably inherited or created a worksheet that contains active hyperlinks, when all you want in the cells is the...

Date shared: October 15, 2014

Error 2042

 

 

Tom's Tutorials For Excel: Going To the Precedent Cell with a Keyboard Shortcut

atlaspm.com - Tom's Tutorials For Excel: Going To the Precedent Cell with a Keyboard Shortcut Here's a cool tip for the keyboard shortcut Ctrl+[ which takes you from the formula cell you are on, to the precedent...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Tom's Tutorials For Excel: Lookup Oldest and Newest Date

atlaspm.com - Tom's Tutorials For Excel: Lookup Oldest and Newest Date The picture shows one way of obtaining the oldest and newest dates in column B that correspond to the person's name in column A that is in c...

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Tom's Tutorials For Excel: Parse a Cell's Contents

atlaspm.com - Tom's Tutorials For Excel: Parse a Cell's Contents If you ever need to parse a cell's contents such that each character is displayed along the row in its own cell, here's one way to do it. In the p...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Tom's Tutorials For Excel: Pasting a Formulas Static Value in Cell Below

atlaspm.com - Tom's Tutorials For Excel: Pasting a Formulas Static Value in Cell Below You probably know that if you select a cell below a cell that contains a value or formula, when you press Ctrl+' (the Ctrl a...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

Tom's Tutorials For Excel: Seeing Values and Formulas on the Same Spreadsheet at the Same Time

atlaspm.com - Tom's Tutorials For Excel: Seeing Values and Formulas on the Same Spreadsheet at the Same Time Did you ever want to watch your spreadsheet in two separate windows in real time, where in one window ...

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

Tom's Tutorials For Excel: SUMIF With Multiple Criteria

atlaspm.com - Tom's Tutorial For Excel: SUMIF for Multiple Criteria The SUMIF function handles one criteria argument, which is great if you only need to sum for one criteria. But what if you want to sum for two ...

Date shared: October 13, 2014

Featured in the Science section of the Excel Daily News on October 14, 2014.

 

 

 

Tom's Tutorials For Excel: Summing a Range Diagonally

atlaspm.com - Tom's Tutorials For Excel: Summing a Range Diagonally Every now and then you come across an unusual request to do this or that in Excel. Such an example is summing a range of numbers diagonally, as...

Date shared: October 17, 2014

Error 2042

 

 

Tom's Tutorials For Excel: Transform a Range Into a Single Column List

atlaspm.com - Tom's Tutorials For Excel: Transform a Range Into a Single Column List Here's how you can take a range of data comprised by multiple columns and rows, and list its items in a single column. In the ...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Tom's Tutorials for Excel: Transpose a Table Range

atlaspm.com - Tom's Tutorials For Excel: Transpose a Table Range In three fast, easy steps you can transpose a multi-row and multi-column table to gain a fresh analytical look at your data. The result is similar...

Date shared: October 17, 2014

Error 2042

 

 

Tom's Tutorials for Excel: TRIM and CLEAN your data

atlaspm.com - Tom's Tutorial For Excel: TRIM and CLEAN your data Sometimes you will receive output files from data warehouse applications, or you will copy data from a web page onto your Excel worksheet. Many ce...

Date shared: October 15, 2014

Error 2042

 

 

Tom's Tutorials For Excel: Using Data Validation to Force a Decimalized Numeric Entry

atlaspm.com - Tom's Tutorials For Excel: Using Data Validation to Force a Decimalized Numeric Entry Data Validation is an excellent way to control data entry to meet a certain condition. Suppose you want to insu...

Date shared: October 7, 2014

Featured in the Technology section of the Excel Daily News on October 8, 2014.

 

 

Transition To Excel 2007 - Excel Zoom

excelzoom.com - I've gotten a few requests for a way to help transition to Excel 2007 from earlier versions of Excel.  As anyone who first tries using Excel 2007 will notice, the traditional File, Edit, View, etc....

Date shared: October 5, 2014

Featured in the Science section of the Excel Daily News on October 5, 2014.

 

 

Turn off warning messages using VBA in Microsoft Excel

exceltip.com - When we run vba code / macros in our excel files, we see a lot of screen flickering as the actions are being performed on the file....

Date shared: October 6, 2014

Featured in the Technology section of the Excel Daily News on October 7, 2014.

 

 

Use Excel As A Calculator - Excel Zoom

excelzoom.com - OK, I know the tag-line for this website is "…because it's more than just a calculator".  Of course this is in reference to the almost endless number of functions that Excel can calculate when comp...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

 

Using a For Loop - Excel Zoom

excelzoom.com -  "For" loop is used in a macro whenever you have an action that needs to be performed a set number of times. For example, if you want to change the fill color of the first 20 cells in a list, you c...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Using Non-Contiguous Data Ranges in Power Query

excelguru.ca - One of the methods we use when building business solutions is creating specific input sheets for our models, as it separates our data from our business logic and ultimately our reporting layers.  T...

Date shared: January 0, 1900

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Using PivotTables - Excel Zoom

excelzoom.com - Note: To work along with this tip, you can download the PivotTable Example file. The download file does not contain the PivotTables referred to below, it simply contains the source data so you can ...

Date shared: October 9, 2014

Featured in the Science section of the Excel Daily News on October 9, 2014.

 

 

Using Text to Columns - Excel Zoom

excelzoom.com - If you have a list of data in a column, formatted in a similar manner throughout that you wish to separate into several columns, you can use Excel's Text to Columns feature to separate this informa...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 6, 2014.

 

 

Vacation Schedule/Tracker (Excel)

flevy.com - For a limited time, we will give you a $10 Amazon gift card or $10 cash reward for every $100 spent. This offer is applied on a per transaction basis. This offer cannot be combined with any other d...

Date shared: October 5, 2014

Featured in the Business section of the Excel Daily News on October 6, 2014.

 

 

Variable width histogram - assign values to ranges - E90E50fx

sites.google.com - [as monster runs out the door] The Blindman: Wait. Where are you going? I was going to make Espresso. by The FrankensTeam Sergio asked us to create a special histogram where the categories are not ...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 10, 2014.

 

 

VBA Concatenate without blank cells

mrexcel.com - This is a discussion on VBA Concatenate without blank cells within the Excel Questions forums, part of the Question Forums category; Hi Guys! My question is very simple: concatenate range Cells(5, ...

Date shared: October 15, 2014

Error 2042

 

 

Video: AutoFill and Flash Fill

support.office.com - This video is part of a training course called Use AutoFill and Flash Fill. You can download the entire course or watch the videos online: Video: AutoFill and Flash Fill. (You are here!) Watch this...

Date shared: October 17, 2014

Error 2042

 

 

 

Video: Create a PivotTable and analyze your data

support.office.com - This video is part of a training course called Create a PivotTable and analyze your data. You can download the entire course or watch the videos online: Video: Create a PivotTable and analyze your ...

Date shared: October 10, 2014

Featured in the Science section of the Excel Daily News on October 11, 2014.

 

 

VLOOKUP Formulas in Microsoft Excel

officearticles.com - The following graphic provides a breakdown for a VLOOKUP formula, and describes each argument. It may be helpful to review it before you continue reading the rest of the article. The V in VLOOKUP m...

Date shared: October 6, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

Watch Window - Excel Zoom

excelzoom.com - In large worksheets, it is especially useful to be able to view a cell that contains summary data, such as totals. This can become tedious if your totals are at the end of your worksheet, while the...

Date shared: October 8, 2014

Featured in the Science section of the Excel Daily News on October 8, 2014.

 

 

Webinar: 5 things you need to know about Freezing Panes in Excel - Office Blogs

blogs.office.com - Need to navigate that huge spreadsheet quickly? Freeze panes can help by allowing you to view your column and row headings continuously while you scroll your document. In this webinar, we'll demons...

Date shared: October 15, 2014

Error 2042

 

 

Webinar: The latest features in Excel Online - Office Blogs

blogs.office.com - Have you ever wanted to see someone else's changes in a workbook right away, without refreshing or saving? Have you ever wanted to keep some cells locked and keep others editable in Excel Online? W...

Date shared: October 13, 2014

Featured in the Technology section of the Excel Daily News on October 14, 2014.

 

 

Wedding Planning Checklist for Excel

vertex42.com - Download a simple wedding planning checklist for Microsoft Excel®. For something as complicated as a wedding, it's easy to forget important things. So, use our original wedding checklist template o...

Date shared: October 10, 2014

Featured in the Technology section of the Excel Daily News on October 11, 2014.

 

 

Welcome to the confusing world of Microsoft Interop Assemblies

itbrigadeinc.com - IT Brigade offers website design services along with SEO, SEM, and marketing to get customers for your small business.  We have a lot of software experience to get your website found.  Additionally...

Date shared: October 5, 2014

Featured in the Technology section of the Excel Daily News on October 6, 2014.

 

 

What is PowerPivot -

auditexcel.co.za - PowerPivot is a new ‘free' tool available in Excel 2010 and Excel 2013 (be careful as it currently does not work in all versions of these two). International experts believe this is a quantum leap ...

Date shared: October 16, 2014

Error 2042

 

 

 

What the World Eats | National Geographic

nationalgeographic.com - Visit this site on your desktop browser or tablet device to explore the full interactive version, and to compare more detailed diet breakdowns of different countries over time. This interactive was...

Date shared: October 16, 2014

Error 2042

 

 

When To Pay Attention To The Stock Market (And When To Ignore It)

fivethirtyeight.com - After a long period of quiet, the markets are once again taking investors on a wild ride. The Dow Jones Industrial Average fell 173 points on Wednesday, the fourth big drop in five trading days. Th...

Date shared: October 17, 2014

Error 2042

 

 

Working with Documents in Word 2013

tutorialstree.com - Word 2013 is bit different from earlier versions of Word.  Microsoft has made several changes in the user interface for the application.  One of the new features added in Word 2013 is pinning a doc...

Date shared: October 4, 2014

Featured in the Technology section of the Excel Daily News on October 5, 2014.

 

 

You asked about pivot tables (video) - Office Blogs

blogs.office.com - So many Office customers ask about "pivot table" that we've gathered the best answers in this blog post. Most likely, you are looking for information about how to create a PivotTable report that ca...

Date shared: October 7, 2014

Featured in the Science section of the Excel Daily News on October 7, 2014.

 

 

You do not need to buy MS Office anymore - Bubblews

bubblews.com - I wrote a post this morning about Hootsuite ( www.bubblews.com/news/3242827-how-i-use-hootsuite-to-increase-traffic-to-my-blogs ) and how I use Excel to prepare my data for submission to it. I rece...

Date shared: October 12, 2014

Featured in the Technology section of the Excel Daily News on October 12, 2014.

 

 

For more resources for Microsoft Excel: