Office 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 Auto Archive Declined Meetings to a Specific Calendar with Outlook VBA

Outlook will auto remove the meeting which you decline from your calendar. If you want to still save it, you can use the method introduced in this article. By default, in Outlook, when you receive a meeting invitation, this meeting will be added to your calendar. However, as long as you select to decline it, Outlook will automatically delete it from the calendar at once. But sometimes actually you still desire to save it in another calendar, like a specific calendar named “Declined”. In...

Read more »