EXPERTISE

 
User Interface
Data Extraction
System Protection
Reporting Automation
Performance Improvement
 
 
 
 

 Automated processes in one click

  • Automated creation of custom objects in one click ("Create") in Excel

  • Automated update of custom objects in one click ("Update") in Excel

  • Automated deletion of custom objects in one click ("Delete") in Excel

  • Lists of selections in Excel and Power BI

  • User form (creation of several fields for data input) in Excel

  • Message box with multiple choices (OK, cancel, Yes/No...) in Excel

  • Contextual message box ("You are about to do X action"...)​ in Excel

  • Informative message box for a given area ("This cell contains X data"...)​ in Excel

  • Full screen mode enabled & removal of formula bar and menus in Excel and Power BI

Data Extraction, Transformation & Refresh

  • Custom API requests (Get any data from an API) in Excel and Power BI

  • Files linking (connect files to each other by using a common key), in Excel and Power BI

  • Query Parameters (Get elements from mutiple requests into one single request), in Excel and Power BI

  • Webscrapping (Get data from HTML pages, i.e Wikipedia, Google Finance, IMDB.).., in Excel and Power BI

  • SharePoint requests (Get data from SharePoint) in Power BI

  • Spreadsheet automation with VBA in Excel

  • Copy/paste given variable data to another tab in Excel

  • Copy/paste given variable data to the first empty row in Excel

  • Data export (export data into a PDF, DOC, PPT or TXT file) in Excel and Power BI

  • Scheduled data refresh (refresh your data up to 12 times per day) in Excel and Power BI

  • On demand data refresh (refresh your data at any time) in Excel and Power BI

 System Protection & data integrity

  • Lists of selection in Excel and Power BI

  • Restricted input according to datatype (ex : only integers, or text...) in Excel

  • Restricted input according to a list of values (ex : only a, b, c) in Excel

  • Restricted input according to a Time Range (ex : only from 2018/01/01 to 2019/03/30) in Excel and Power BI

  • Worksheet/workbook locking system (some given cells are not editable) in Excel

  • Columns / rows hiding system (some given cells are not visible) in Excel

  • Worksheet/Workbook protection by password in Excel

  • VBA editor protection by password in Excel

  • Row Level Security (data access is restricted according to the user's identity) in Power BI

  • Restricted access to folder according to the user's identity in SharePoint

  • Restricted access to folder  according to the user's identity in Excel

  • Goup Workspace in Microsoft Power BI 

  • Disable cut-copy-paste in Excel

Reporting Automation​

  • Creation of interactive reports in the cloud with dynamic visualizations in Excel and Power BI

  • Reporting Migration from PowerPoint to OLE - Object Linking & Embedding (in PowerPoint)

  • Reporting Migration from PowerPoint to Power BI

  • Automatic formatting (colors, fonts) according to data values, in Excel and Power BI

  • Automatic up or down arrows according to data values, in Excel and Power BI

  • Automated charts in PowerPoint (charts are automatically updated)

  • Automated values in PowerPoint (values such as dates, numbers, arrows, KPIs... are automatically updated)

  • Dynamic reports to compare objects over variable subjects, in Excel and Power BI

  • Dynamic reports to monitor data evolution over a custom time range, in Excel and Power BI

  • Dynamic reports to monitor data evolution by city, region, country or continent, in Excel and Power BI

  • Dynamic reports to monitor data evolution in Excel, and Power BI

Performance Improvement

  • Overall sum system with multiple parameters (overall sales of cars under the Brand "Renault"  in "France", in "2018")

  • Overall average system with multiple parameters (Average NPS of orange apps  for "Android", in "Senegal", in "2018")

  • Overall count system with multiple parameters (Number of "App" Products where "Quality score" is "Bad", in "2018")

  • Scoring process (Good, Bad...) to any object (product, company, employee...)  using multiple KPIs

  • Design & delivery of tailor-made calculation tools :  calculate premiums, wages,  bonus...>Watch an example

  • Training

    • Visual Basic for Applications (VBA) Training    

    • Power Query Training

    • Power BI Training

    • Excel Training (formulas, Pivot Tables...)

    • Microsoft OLE - Object Linking & Embedding Training

    • SharePoint Online Training

 
MYPE-Solutions.PNG
formations.PNG-min.png
pbi.PNG

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

MYPE -pronounce [Maip']- means Make Your Process Easier.

MYPE is a simplifier joint stock company registered with the Paris trade and Companies Register under number 841 625 460  and  located at  214, rue de la Croix Nivert, 75015 Paris.

MYPE is registered with the Paris  Prefecture as a Training Organization under number  11755924475. 

 

if you have any questions, you can contact us at contact@mype-consulting.com or  09 87 17 79 98.

 

Find our brochure  here.

Microsoft-Partner-Network-Logo_transpare

© MYPE.  All rights reserved

  • Facebook - Gris Cercle
  • Twitter - Gris Cercle
  • LinkedIn - Gris Cercle
  • YouTube - Gris Cercle