Відео

Regarding the "ask for 50% up front" comment - correct - there are a number of "not so serious clients out there" so you need to filter those out. What also helps is to be careful when they tell you "oh, we have everything (i.e. data) in orderly form, we just need someone to tackle the report or so...". Have yourself at least a few hours of "current state analysis" as a step BEFORE you commit to building anything for a fixed price.

The image you downloaded from pngwing i can't seem to.find it when i search for it.

This is superb :)

Hi, it is a great compact video about making money with Excel. I request to guide me how I can learn Excel to earn? i really need guidance. Waiting for your reply. Regards

Hello, the excel download file link led me to 404.

Hi, Can we open a file in one-drive using a vbs script?

I am trying to make excel work for a complicated sorting need that I have. I’ve run in to a roadblock. Who can I reach out to for help? It’s hard to describe my problem. However, I’ll give it a try. I have 1500 lines of items that I am sorting from 7 different tables. Each line has valuable info. It’s not numbers, it’s words only. I sorted with pivot tables and have slicers to help narrow down the models on one sheet. What I would like is to have the slicers to narrow down the original tables info as well, but I can’t seem to find out how to do that.

Is there any way you can add a calculated field to get a percentage for Gross profit or net profit, i have tried but getting a division error.

Thank you, it was very helpful and saved me a lot of time.

Working on projects that leverage Excel can help you develop and demonstrate a wide range of skills, making you valuable in various job roles. Here are some of the best project roles in Excel to work on, along with examples of projects you can undertake to build expertise in each area: 1. Data Analysis and Reporting Role: Data Analyst / Business Analyst Projects: Sales Analysis: Analyze sales data to identify trends, calculate growth rates, and forecast future sales. Customer Segmentation: Segment customers based on purchasing behavior and demographics to tailor marketing strategies. Market Research Analysis: Compile and analyze survey data to understand market trends and customer preferences. 2. Financial Modeling and Budgeting Role: Financial Analyst / Accountant Projects: Budget Tracker: Create a personal or business budget tracker to monitor expenses, income, and savings. Financial Forecasting Model: Develop a model to predict future financial performance based on historical data and assumptions. Investment Portfolio Tracker: Track and analyze investment performance, diversification, and risk. 3. Project Management Role: Project Manager / Operations Manager Projects: Gantt Chart: Create a Gantt chart to visualize project timelines, milestones, and task dependencies. Resource Allocation: Develop a resource allocation plan to manage team members' workload and project resources. Project Budgeting: Track project expenses against the budget to ensure financial control and efficiency. 4. Inventory and Supply Chain Management Role: Logistics Coordinator / Inventory Manager Projects: Inventory Management System: Develop a system to track stock levels, manage reorder points, and forecast inventory needs. Supply Chain Dashboard: Create a dashboard to monitor supply chain performance, including lead times, costs, and supplier reliability. Order Tracking System: Build a tool to track order status, delivery timelines, and customer satisfaction. 5. Human Resources and Payroll Role: HR Analyst / Payroll Specialist Projects: Employee Database: Create a comprehensive database to manage employee information, including contact details, job roles, and performance reviews. Payroll Calculator: Develop a payroll calculator to automate wage calculations, tax deductions, and benefits. Training and Development Tracker: Monitor employee training progress, certifications, and skill development. 6. Marketing and Sales Role: Marketing Analyst / Sales Analyst Projects: Marketing Campaign Analysis: Analyze the effectiveness of marketing campaigns by tracking key performance indicators (KPIs) such as conversion rates, cost per acquisition, and return on investment. Sales Dashboard: Create an interactive dashboard to monitor sales performance, track sales targets, and identify top-performing products or regions. Customer Retention Analysis: Analyze customer data to identify factors affecting retention and develop strategies to improve customer loyalty. 7. Administrative and Office Management Role: Administrative Assistant / Office Manager Projects: Schedule Organizer: Develop a scheduling tool to manage appointments, meetings, and deadlines efficiently. Contact Management System: Create a database to store and organize contact information for clients, vendors, and stakeholders. Task Tracker: Implement a task tracking system to monitor progress on various administrative tasks and projects. Advanced Excel Projects for Demonstrating Expertise Automated Reporting System: Use Excel macros (VBA) to automate the generation of periodic reports, saving time and reducing errors. Dynamic Dashboards: Build dashboards that update automatically with new data, using advanced Excel features like Power Query and Power Pivot. What-If Analysis Tool: Create a tool to perform scenario analysis and sensitivity analysis for financial models or business decisions. Conclusion By working on these projects, you can develop a robust set of skills that are highly valued in various job roles. Each project type will help you build expertise in specific areas of Excel, such as data analysis, financial modeling, project management, and automation. This hands-on experience will not only enhance your resume but also prepare you for real-world tasks and challenges in your career.

I like it waw , verry impressive and clearly,❤️❤️ thanx so much .

Useful video solved my problem! How about I am using excel getdata from a folder in sharepoint? My dataset are combined from 100+ files that save in one sharepoint folder.

Hi teacher Thank you very much. you saved my day! Great content for finance guys like me passionate to learn about the advanced excel skills. Thank you very much again!!!

Amazing video. I was stuck on formatdate. Didn’t find any video that used the dynamic content in html… finally!!!! Pls pls pls create a power automate list. It is not there when i looked in the playlists.. waiting for more power automate videos!!! ❤❤❤

Thanks for the video. The problem is that in those platforms there are thousand of people doing tasks for less money. How to find proper jobs / tasks to take advantage?

This is great! Thanks!!

How can I add the frecuency table function?

Hi - I have watched your videos re: conditional formatting, but haven't been able to solve my problem -- I am attempting to link cells (including cell formatting). When linking cells, in addition to retrieving the contents from the source cell, I want the linked (dependent) cell to also follow the same formatting as the source cell (as the source cell formatting may change). Any suggestions are appreciated. Thank you!

Wow. I use conditional formatting with formulas all the time - although I tend to prefer doing a background fill on the cell in order to make it really stand out. I have also seen the symbols thing in another video (of yours, I think). However, I did not know any of the first four! VERY useful video. Thanks !!!!

so cool!

Hallelujah! Only 4 years late to the XLOOKUP party, so glad I finally found this video. My VLOOKUP source data is in a separate tab, within the same sheet, and nearly every time I added or deleted a row, all the VLOOKUPs broke. Thanks Mynda - bonzer mate.

is the dashboard still available???

What are considered advanced formulas?

Brilliant thank you 🙏🏽

Great video thank you!. Is it possible to make the line move in the stacked column if the value changes? I'm finding it disappears as soon as i change the value

Im looking for a formula or conditional formatting that highlights a large set of data table based on Purchase Order Numbers eg ( PO124589) > The table has 12 columns and i would like each PO# and the row all to have there own colour. I cant find this anywhere. If you could help that would be amazing. Thank you.

Excellent

I am not able to access the data file

Love, love these useful tips!

Thank you so much