excel tips and tricks

MS Excel LEFT, MID, RIGHT Functions: How To Slice Up Cell Contents

By Violeta | Published: December 8, 2010

Why would anybody want to automate slicing up cell contents in a spreadsheet? If you ever tried to copy a list from a web page or from a .txt file and paste it into Excel with the purpose of creating a database, then you know how frustrating it is to go through cells and edit [...]

Posted in Microsoft Office, Tutorials | Also tagged excel functions, microsoft excel | 1 Comment

How to assign a toolbar button to a macro in MS Excel

By Violeta | Published: September 28, 2006

Do you know what a macro is? Or how to make a MS Excel macro? Have you ever made a macro? If you had, it means you use it frequently, this is why you made it, isn’t it? It must be boring though, every time you want to run it, to go to the main [...]

Posted in Microsoft Office, Tutorials | Also tagged add macro in excel, excel macros, macros, microsoft excel, productivity | 2 Comments

How to use macros in MS Excel

By Violeta | Published: August 25, 2006

It happens many times that we have to accomplish boring repetitive tasks in MS Excel, such as formatting cells in lots of tables, to make them look more professional, in order to print, let’s say, a report for a client. Those tasks, although easy to do, require a lot of time to complete. Repetitive tasks [...]