Shuvo M.

🌟Certified Microsoft Excel Expert, I'm in the top 5% in LinkedIn Excel assessment. 🥂 100+ Happy Clients 🌟 6+ Years of Experience I'm a certified Microsoft Excel and Power BI expert who has 6+ years of experience in the Data analysis field. I'm very confident in observing data proficiently and giving them the best view. *** I can do most of the crucial activities in Microsoft Excel & Power Bi*** ✔️ Custom Excel Formula- Prepare the best formula based on your condition. ✔️ Macro button- Help to ease the task frequently need to do, it can also help to sort data as a pro. ✔️ Dashboard- Create dynamic charts and view the overall summary in the best way. ✔️ Frequently Used Charts Type - Column Chart, Line Chart, Gantt Chart, Pie Chart, Doughnut Chart, Bar Chart, etc. ✔️ Data Modelling - It helps to link with multiple tables to avoid unnecessary steps in Power Bi. It's also called Power Pivot in Excel. ✔️ DAX - it is really useful to load the Power BI faster by avoiding unnecessary steps ✔️ Power Query- The best tool for combining multiple Excel files, transforming and manipulating the data. This is a dynamic process, so whenever we update data, the results will be updated too. ✔️ VBA- This tool is great for doing frequent tasks with a single click on a button. For creating "User Form" VBA is required. ✔️ Advanced Formula such as INDEX, MATCH, H/VLOOKUP, XLOOKUP, SUBTOTAL, SUMPRODUCT, SUMIFS, COUNTIFS etc. ✔️ VBA Function- This tool can create permanent customized functions very well. ✔️ Generate Text & Number- separate text and number from a line by Formula & VBA. ✔️ SQL- Is great for maintain a Database and work with Big Data. I use my top-notch Excel and Power BI skills to automate daily tasks, Data transformation, and organization in Excel and Power BI, Pivot Charts, Power Pivot, and Pivot Tables in Excel. With the help of Formulas, Excel Functions, VBA, Power Query, and more, I create perfect solutions based on the requirement which provide faster data processing, more controls, and a high level of accuracy. You will get: ➕ A Smart Solution to Fix Your Issue ➕ Advanced Excel Report ➕ Automated Excel Report ➕ Insightful Dashboard ➕ Power BI Report ➕ A Video Instruction / Zoom Meeting As a full-time freelancer, I'm capable of providing long-term support, communicating on time, and updating regularly. Please give me an opportunity to save your Time and Money with an Automated solution.