Microsoft Excel and Visual Basic Expert for $20

Level 1

Attention: The owner of this service has not logged into SEOClerks for more than 30 days. It is highly recommend that you contact them before ordering this service. Last Login: 3142 days ago

Microsoft Excel and Visual Basic Expert

Highly trained and experienced with computer consulting in the area of Microsoft Excel
and Visual Basic (writing macros) and PowerPoint

Creating simple to complex spreadsheets / data manipulation / automation
Visual basic programming
Creating pivot tables, summary data using SUMIFS & COUNTIFS, creating ad hoc reports and dashboards
Create robust Templates / Input sheets that are reusable
1. Can write macro to automatically add input data to a central DB on another worksheet
2. Can create summary reports / key metrics from this DB

Highly proficient with conditional formatting, use of drop downs, check-boxes, etc.
Eliminate redundant data entry, linking data across multiple worksheets, doing lookups
Process flow diagrams, flowcharting
Professional presentations

Thirty plus years in: Manufacturing as an Industrial / Process Engineer. Broad experience in
1. Manufacturing (domestic and international),
2. Supply Chain Management, Planning, and Procurement, and Warehousing functions.
3. Know many Service Functions
4. Business Planning, Financial / Business Case Analysis, Process Improvements.
5. Ability to lead highly visibl projects, establish rapport and credibility with diverse groups, with an
  eye toward bottom line results.
AREAS OF EXPERTISE:

- Microsoft Excel Consulting - Workflow and Process Improvements - Mergers & Acquisitions - Project Management – Internet Research - Financial Analysis - Lean Manufacturing -Professional Presentations

WORK EXPERIENCEMJL Consulting 2006- Present

President and Owner

Provide computer consulting support in the areas of Microsoft Excel and PowerPoint. We assist in creating simple to complex spreadsheets and / or making existing spreadsheets more robust or more automated. Trained in visual basic and can write macros as required.

Skill sets:
1. Creating/ developing informational databases
2. Create ad-hoc reports as required from existing excel data, files
3. Creating/ developing spreadsheets (simple to complex)
4. Customizing existing spreadsheets to be more robust, automated, and less labor intense
  1. Use visual basic to write macros as needed
  [/*]
5. Providing complex data manipulations / data summaries / dashboards & metrics
6. Creating templates, automated input sheets, and data transfers as needed
7. Creating professional presentations / training materials / process flow charts
8. Make use of drop downs and checkboxes where applicable
  1. Create dropdowns that automatically update data range and make new additions
    automatically appear on the drop down
  [/*]
9. Can create pivot tables or other summary tools such as advanced formulas like
  SUMIFS, COUNTIFS, etc
Business Expertise:
- Manufacturing / Supply Chain / Logistic and Warehousing / Procurement
- Real Estate…residential and commercial
- Service Organizations
- Mergers and Acquisitions
We also assist in creating professional presentations using PowerPoint.

0.0

0 reviews

Rating breakdown

$20

Order Now ($20)

Response	22 hours
Last seen	3142 days ago
Delivery	7 days
Ratings	0

Other services by MJLexcelexpert

$20 - In stock

Avg Time	Count	SQL	Max	Min
0.097303	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%hours%') ORDER BY total_recommendations desc LIMIT 0,40	0.097303	0.097303

MJLexcelexpert

MJLexcelexpert

SEOClerks

Microsoft Excel and Visual Basic Expert for $20

Attention: The owner of this service has not logged into SEOClerks for more than 30 days. It is highly recommend that you contact them before ordering this service. Last Login: 3142 days ago

Microsoft Excel and Visual Basic Expert

Tags

0.0

Rating breakdown

$20

Other services by MJLexcelexpert

Top Sellers

New Services

Top Services

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()
SELECT * FROM posts WHERE PID=548088	1	SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=548088	/opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
SELECT * FROM seoclerks.members WHERE USERID='607681'	1	SELECT * FROM seoclerks.members WHERE USERID='607681'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='548088' AND A.RATER=B.USERID	1	SELECT COUNT(A.RID) as total, SUM(bad) as badTotal, SUM(good) as goodTotal FROM ratings A, seoclerks.members B WHERE A.PID='548088' AND A.RATER=B.USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM orders WHERE PID='548088' AND status in (1, 4, 6)	1	SELECT OID, stime, extradays1, extradays2, extradays3, extra1ordered, extra2ordered, extra3ordered, days, status, quantity, extras_data FROM orders WHERE PID='548088' AND status in (1, 4, 6)	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
UPDATE posts SET viewcount = viewcount + 1 WHERE PID='548088'	1	UPDATE posts SET viewcount = viewcount + 1 WHERE PID='548088'	/opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() ()
SELECT * FROM seoclerks.ratings WHERE USERID='607681' AND PID != 0	1	SELECT good, bad FROM seoclerks.ratings WHERE USERID='607681' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM codeclerks.ratings WHERE USERID='607681' AND PID != 0	1	SELECT good, bad FROM codeclerks.ratings WHERE USERID='607681' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM listingdock.ratings WHERE USERID='607681' AND PID != 0	1	SELECT good, bad FROM listingdock.ratings WHERE USERID='607681' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM pixelclerks.ratings WHERE USERID='607681' AND PID != 0	1	SELECT good, bad FROM pixelclerks.ratings WHERE USERID='607681' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM wordclerks.ratings WHERE USERID='607681' AND PID != 0	1	SELECT good, bad FROM wordclerks.ratings WHERE USERID='607681' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
select * from categories_software order by name asc	1	select * from categories_software order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()
select * from categories_wanttobuy order by name asc	1	select * from categories_wanttobuy order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()
select * from categories_wanttotrade order by name asc	1	select * from categories_wanttotrade order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()
SELECT * FROM categories WHERE parentid = 0	1	SELECT * FROM categories WHERE parentid = 0	/opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include()
SELECT * FROM seoclerks.members WHERE USERID=?	1	SELECT usergroup FROM seoclerks.members WHERE USERID=?	/opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include()