Jose Miguel Sanchez Guia

1,047 Flips | 5 Magazines | 7 Following | 1,706 Followers | @josemsanchez | Keep up with Jose Miguel Sanchez Guia on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Jose Miguel Sanchez Guia”

Data Validation to Avoid Duplicate Values

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 …

Four Excel Tips to Increase Productivity

Often times we think we know enough about Excel, or any program for that matter, and get set in our ways while preforming a particular task. …

Protect a Worksheet Except for Individual Cells

If you have ever used Excel to gather information from people in a pre-defined form setup, you know it can be frustrating when the responses contain …

3D Sum Formula Reference

On occasion, it is useful to keep track of similar data in separate worksheets. Data such as monthly, quarterly, or annual financial information …

Twitter 140 Character Tool

Just to have a little fun with the new Twitter account, I thought I’d put together a little Excel tool to make fitting into the 140 character limit a …

3 @Microsoft Excel formulas that will make it easy to slice and dice piles of data https://t.co/oMKEFXiR4U

Use Excel As A Calculator

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 …

Mathematics

11 basic Excel tricks that will change your life https://t.co/qaQm9ySt5S

Adding Comments to Formulas

Adding comments to your worksheet allows you to share your thoughts with other users, or to serve as a reminder for yourself.<p>It’s also useful to be …

How to Format Numbers as File Sizes

Have you ever had a list of files with accompanying file sizes that you wanted to use in some sort of calculation such as adding up the file sizes, …

Remove Hyperlinks

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 …

10 Excel Tips For Increased Productivity

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 …

Run Macro Automatically on Open

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 …

Using Fill Handle for the Alphabet

Using the fill handle is easy. Simply start typing a list of consecutive numbers, dates, etc. and drag the rest. You can easily fill 100 cells in no …

Type Same Data In Multiple Cells

Have you ever had the need to type the same data in multiple cells in your Excel spreadsheet? If so, you know it can be quite the time consuming …

Return all Characters in a Font

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 …

How to Create a Calendar in Excel

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 …

How To Make a Map From Open Data Using a Spreadsheet

<i>Ad:</i><p>There’s been an explosion of open data made available by all levels government, but much of it is still in a pretty raw form and can be hard to …

Microsoft Excel: Macro Code to Perform a “Contains” Text Filter

A handy piece of VBA code to have in your toolkit!<p>Performing an AutoFilter in Excel and I needed to perform a “contains” text filter. So, I have a …

Microsoft Excel Online tips and tricks to help you get started

From students to businessmen – Microsoft Excel can be a very useful tool for all who want to create reports, charts, tables and so on. When someone …

10 Microsoft Excel 2016 Tips Every User Should Know

ShareEmail Comments<p>Microsoft Outlook, Microsoft Word, and Microsoft Excel are the three heavyweights in the Microsoft Office suite. We recently …

18 Tricks to Make Yourself a Microsoft Excel Master

The number of ways you can use Excel is countless, and so are the number of features packed inside Microsoft’s most popular number-crunching …

Formula to Link Between Excel Files

Often times, you’ll do work in one Excel file, that would be useful to show in another Excel file. You can simply copy and paste the data in, but if …

NASA's Juno Mission on Twitter: "Sounds of science: Listen to #Jupiter’s auroras, as heard during my close flyby on Aug 27 https://t.co/1wce7PxgTs… "

New conversation<p>New conversation<p>End of conversation<p>New conversation<p>End of conversation<p>Replying to @<b>NASAJuno</b><p>I was waiting for 'Moving in Stereo ' to …

How to Use Excel Sparklines

Excel Sparklines are a neat feature that was introduced back in Excel’s 2010 version. Excel Sparklines gives you a small chart that represents a set …

On this day in 1997, Mars Global Surveyor went into orbit around #Mars, where it would map the planet for 9 years. https://t.co/kAC4XCiko7

Adding and Subtracting Time in Excel

Adding and subtracting time in Excel is something that people often times have a difficult time figuring out how to do correctly. Often times you are …

How to Recover Lost Excel Passwords

Let me preface this article by saying that this will not help you recover lost data, or gain access to protected data that you otherwise wouldn’t …