MJL Consulting

I provide Microsoft Excel services.
*Expert with Excel as well as know visual basic and can write macros
*Create / Customize all types of spreadsheets
*Know both simple and complex Excel formulas
*Can link data to multiple worksheets so no duplicate en...tries are required
-Use Drop Downs to eliminate typing and provide standard names
-Use check boxes to select items you want to include
*Can do all sorts of data manipulations
* Create Templates / Input Forms that can easily be reused
-can write macros to transfer input entries to a central database, and clear for new entry
*Create Pivot Tables and other reports using formulas like SUMIFS & COUNTIFS
-Can create dashboards / graphs / Key Performance Indicators
*Can do Conditional Formatting to fill cells with color or modify fonts
*Can automate many manual tasks using Visual Basic (code to write macros) or provide advanced logic not possible with native Excel
-Macros to open another excel/csv file and select data and paste to an Excel file
-Macros to loop through spreadsheets and capture specific data required

I have over 20 years experience with Excel as well as was an Project Industrial Engineer. Know all aspects of manufacturing, and many Service functions as well

Also can assist with PowerPoint presentations too

Very reasonable rates, which can be negotiated

Email: Marty.MJLConsulting@gmail.com Read More