2005
the year we STARTED
1,013
Corporations SERVED
(up to Q3, 2024)
556
Projects
(up to Q3, 2024)
13
Products
(up to Q3, 2024)
About Modern Excel
Excel does not require an introduction. Google it. Excel is a backbone app.
Modern Excel started with Tables in Excel 2007. Modern Excel transforms our experience with Excel.
You achieve “Excel works for me” happiness. The main components are
Tables
Slicers
Power Query
Data Model
DAX
Power Pivot
Power BI
Excel Online
Projects
Automation of business process
- 1. Saves cost and time
- 2. Eliminate human errors
- 3. Increase business efficiency
Excel projects is the fastest and most economical way to automate department level processes.
- 1. Excel projects is cost effective .It does not require any CAPEX.
- 2. Excel projects does not require any clearance from IT Security.
- 3. You do not need “admin” access to your PC to run an Excel project.
- 4. The solution can be developed with small timelines.
- 5. Familiarity with Excel makes it easy to visualize, learn, and use.
We undertake Excel Projects of all sizes, of all departments in an organization.
We also Repair and Enhance your current Excel / Access Solutions and Excel Macro Models.
In our current and previously held positions, we have developed 100+ projects. Here is a partial list with brief description.
Excel Projects - WITH Macros
Generate Pay Slip
Create a free salary slip with professional template
Submit payslip for loans, insurance, tax and other purposes
Completely free pdf template - ready for download
Excel Projects - WITHOUT Macros
Power BI Projects
Power BI Bank Consumer Complaints
Projects – Best Practices
Practice Makes Perfect.
Our extensive work has helped us create our own “Practically Useful” best practices. We use them for all solutions that we deliver using VBA, “M” Language, and DAX.
If addition to Engineering considerations, our best practices are also driven by “if the User can see the “code”, the User is inquisitive to know what it does?” fact.
Below, we give out most widely used “best practices”.
Repair & Enhance your Current Projects
Quite often, Excel and Power BI solutions are created by an in-house expert or a consultant. They are left unsupported when that individual leaves the organization or becomes unreachable.
The general reasons are
- Business logic has changed.
- The input data structure has changed.
- The required output design has changed.
- Create / delete a visual
- The solution starts giving an error or is just not opening / working
- The solution consumes too much time
This leads to the abandonment of these advanced mission-critical solutions. The departments revert to old manual or formula-based ad-hoc methods.
We offer repair and enhancement service for such solutions. This helps organizations maintain the efficiency and effectiveness of their automated processes.
If you are struck in such situation, we can repair or/and enhance your solution.Based on our experience, the common reasons for errors are:
Products
Delivering several solutions on a domain gives knowledge and confidence to develop Products.
Developing Products in Excel and Power Bi is extremely difficult since both apps are very flexible.
Our products are not mere Templates. They offer automation of best practices / laws of the country. They provide integrated service like creating password protected PDFs and emailing to apt person. They generate output which can be straight away used for Power BI Dashboards.
Products - Excel
Products - Power BI
Courses
Excel Coaching
Post Training Coaching transforms your files, productivity and accuracy.
Our courses impart “actionable” knowledge. But does the knowledge gets implemented in daily work files? TBH, just 10-15%.
Reason – emails become important, urgent becomes priority, and resistance to change!
We coach using your files. We ensure use of better techniques, features, functions, etc in your files. Usually, we coach a group of 2-3 delegates from a department who use similar files.
Modern Excel
Designed for Modern Excel - Excel 2016 and beyond versions. You will not be able to use Power Query, Data Model, DAX and Power Pivot in earlier versions. Other concepts can be practiced on older versions of Excel.
The Essential Skills
Power Query
Power Query is a tool used to manipulate data and is used for data analysis and business intelligence.
Power Query allows a user to import data into Excel through external sources, such as Text files, CSV files, Web, or Excel workbooks.
Power Query Essentials
Data Model, DAX and Power Pivot
Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel.
DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models.
Essentials
Power BI
Microsoft Power BI is a data visualization platform used primarily for business intelligence purposes. Power BI’s dashboard is capable of reporting and visualizing data in a wide range of different styles, including graphs, maps, charts, scatter plots, and more
Power Apps
Power Apps is a service for building and using custom business apps that connect to your data and work across the web and mobile - without the time and expense of custom software development.
Power Apps Essentials
Power Automate
Power Automate is a tool that lets users automate tasks and processes within their Office 365 workflow
Power Automate Essentials
Programming in Excel
Programming in Excel empowers increase in efficiency, enhancing data analysis,automation capabilities and facilitates complex data processes.
Macro Programming in Excel
Script Programming in Excel
Python Programming in Excel
Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.
MS Access is a part of the Microsoft Office suite and stores data in its own format.
Access-Beginners
Customers
Here is a partial list.
Luxury
Financial Services-Bank
Financial Services-Insurance
Financial Services-Investment Houses
Financial Services
Oil and Gas
Hotels
Blog
While we excel as data experts, our prowess in wordsmithing may not be as strong.
We have a treasure trove of insights to share, derived from hundreds of resolved issues and thousands of queries addressed.
Our aim is to share knowledge that can be practically applied by 99.9% of Excel users in the workplace. This will be actionable knowledge. We plan to write articles and create accompanying videos to enhance understanding and facilitate application in your files.
The content in this section is continually being improved and refined.