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 -prononcer [Maïp']- signifie Make Your Process Easier.

MYPE est une société par actions simplifiée immatriculée au RCS de Paris sous le numéro 841 625 460 et sise au 214, rue de la Croix Nivert, 75015 Paris.

MYPE est enregistré auprès de la Préfecture de Paris en tant qu'Organisme de Formation sous le numéro 11755924475. 

Pour toute question, vous pouvez nous contacter à l'adresse 

contact@mype-consulting.com ou au 09 87 17 79 98.

Retrouvez notre brochure ici.

Microsoft-Partner-Network-Logo_transpare

© MYPE. Tous droits réservés.

  • Facebook Social Icône
  • Twitter Icône sociale
  • LinkedIn Social Icône
  • Icône sociale YouTube