Excel Solutions

How to Create a Portfolio Gallery in Excel

Sharing your portfolio with your Clients is a key step in grabbing a new project. Instead of sharing them multiple URLs or sending them big files, share an Excel file with all necessary URLs. When Clients open this file, all URLs will be converted to images automatically. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the contents below. Let's Prepare the GUI To prepare this...

Read more »

How to Import and Analyze Your Bank Statements in Excel

Unlike others, do not spend too much time and efforts in tracking your expenses. Follow this article and build your own income and expense tracker. This tool accepts your bank statements in an Excel format and then reads it to let you know where you have spent more. Let's Prepare the GUI The tool needs 3 sheets. Rename sheet1 as "Control Panel", sheet2 as "Summary" and sheet3 as "Database".  On the sheet "Control Panel", create a field to allow the user to browse and upload historical bank...

Read more »

How to Easily Manage Your Stock Portfolio with Excel

If you are stepping into stock trading, you would have already realized that it is very important to keep a track of your stock portfolio. There are several online portals that allow you to track your portfolio but you would also have to pay a fee for that. With Excel build your own and customized stock portfolio tracker. Download Now If you want to start to use the software as soon as possible, then you can: Download the Software Now Otherwise, if you want to DIY, you can read the...

Read more »