S P E C I A L P R O J E C T S
"Give someone a fish, and you feed them for a day; show someone how to catch fish, and you feed them for a lifetime."That's cool, but what if you're too busy right now and just want someone to get the job done for you? And of course, not everyone has to be a power user.
A lot of the work I do for clients is bringing their special projects from ideas to finished deliverables. While most of these are one-and-done, other projects are ongoing per my clients' requests, typically prepared monthly or annually.
Here are some examples of work products I've completed for clients (without programming):
Word:
Templates with style sets, table calculations, fillable forms with check boxes and dropdown lists, tables of contents, complex field codes, conditional mail merge, modified text wrapping around pictures, cross references, indexes, keyboard shortcuts for ribbon buttons, multi-section page numbering and related formatting, outline levels, labels, advanced find and replace codes, various troubleshooting, etc.
Excel:
Intricate workbooks or templates with interrelated worksheets, PivotTables with data slicers, personnel databases, customized number formats, autofill lists, text string manipulations, cash flow calendars, employee time sheets, conditional formatting rules, intricate formulas like nested IF statements, running totals, consolidations, goal seeking, data validation with INDEX and MATCH, subtotals, advanced filters, dashboards, data wrangling, project coordinators, scenarios, charts that respond to weekly sales, various troubleshooting, and setting up workbooks for printing, etc.
PowerPoint:
Complete decks with "custom slide show" variants, trial graphics, presentation templates, slide footers, bullet builds, visualizations of processes or structures, multiple object animations and slide transitions, reusable elements, etc.
Outlook:
Email templates, Quick Parts, Quick Steps, categories, rules, mail merge to email addresses, etc.
I enjoy designing and creating workable and valuable solutions for my clients. I look forward to learning about your special project ideas, and bringing each one from concept to completion for simplified and enhanced workflow.
► What special projects in Microsoft Office are on your wish list?
"I highly recommend Rob Mendell to anyone who wants customized Excel solutions that make life easier. He is highly knowledgeable about many various uses of Excel. I had my company hire him to simplify and expand a spreadsheet we use to track metrics. Rob learned how we use it, asked what would make it better, and created an intelligent workbook that auto-generates worksheets, graphs, and tables that really help us get a quick look at the information we need. I find Rob professional and always willing to go beyond to provide excellent service."
— Jillian Eichel, M.A., M.Ed.,
Personal/Professional Development Coach, Speaker & Trainer at Wright Foundation
Recommendation on LinkedIn
— Jillian Eichel, M.A., M.Ed.,
Personal/Professional Development Coach, Speaker & Trainer at Wright Foundation
Recommendation on LinkedIn