
Closed
Posted
Paid on delivery
Looking for an Excel Expert/Tutor – PivotTables & Case Analysis Hi everyone, I’m looking for an experienced Excel expert/tutor who can teach me how to build management reports using an existing case-level Excel report. I have a Q3 OM case dataset containing fields such as Case Number, Territory, Case Opened Date/Time, Case Closed Date/Time, Case Age No Weekend, and Domestic/International classification. I need help learning how to create the following reports: 1. Q3 Case Count Report Total Q3 case count Domestic vs. International case count Case count by Territory Group/merge territory divisions such as ALLA 2026-M and ALLA 2026-S where required Correct Grand Totals 2. Average TAT Report Identify closed cases Calculate the number of closed cases Calculate average TAT for closed cases Use the existing Case Age No Weekend field if appropriate Show Domestic vs. International results 3. Aging Report Identify open cases with Case Age > 1 day Count cases greater than 1 day Calculate average aging for those cases Show Domestic vs. International results What I want from the session: Please teach me step-by-step, rather than simply creating the report for me. Explain PivotTables, filters, grouping, calculated/helper columns, averages, and Grand Totals. I want to understand the process so I can independently create/update the reports every quarter. I already have the source Excel report and can share a sample during the session. Preferred: 1–2 hours of live screen-sharing/training with an experienced Excel reporting professional. Please share your experience, hourly rate, and availability.
Project ID: 40741614
18 proposals
Remote project
Active 6 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average ₹1,669 INR for this job

Hello, I have strong experience working with Excel for data management, reporting, analysis, and workflow automation, and I can guide you through the process step-by-step using your actual Q3 OM case dataset. Rather than simply creating the reports for you, I will explain how to build them so you can independently repeat the same process for future quarters. During the 1–2 hour session, we can cover: • Building the Q3 Case Count Report using PivotTables • Analyzing Domestic vs. International cases • Case counts by Territory and handling territory grouping/merging • Understanding and correcting Grand Totals • Identifying closed cases and calculating closed-case counts • Calculating Average TAT using the existing Case Age No Weekend field where appropriate • Building the Aging Report for open cases with Case Age > 1 day • Calculating the number of aging cases and their average aging • Using filters, grouping, helper/calculated columns, and PivotTable settings correctly • Explaining the logic behind each report so you can update it yourself every quarter I will work directly with your existing Excel report during the session and explain not only **what to click**, but also **why each step is needed** and how to avoid common reporting and Grand Total errors. Best regards, Peter Elias
₹1,000 INR in 1 day
6.0
6.0

Hi, I’d be happy to help you master this reporting process. I have 10 years of Excel experience and can teach you step-by-step how to build Q3 Case Count, Average TAT, and Aging reports using PivotTables, filters, grouping, helper columns, and appropriate calculations. Rather than simply creating the reports, I’ll explain the reasoning behind each step so you can confidently reproduce and update them every quarter. We can work directly with your existing dataset during a live screen-sharing session. My rate is $10/hour, and I’m available to start immediately. Will you mind sharing the actual Q3 dataset before the session so we can work through your real report together? Please don't hesitate to contact me for more information. Thanks in advance.
₹1,050 INR in 7 days
4.8
4.8

Hi, I’d be happy to help you build these Q3 management reports while teaching you the process step-by-step, rather than simply delivering the final reports. I have 15+ years of experience in Excel reporting, PivotTables, Power Query, VBA, data analysis, and BI. I can guide you through: Building each PivotTable and applying the right filters Domestic vs. International analysis and territory grouping Closed-case TAT and open-case aging calculations Helper/calculated columns and when to use them Correct averages and Grand Totals Structuring the workbook so you can easily repeat the process every quarter Approach: We’ll work directly on your sample dataset during a 1–2 hour screen-sharing session, and I’ll explain each step and the reasoning behind it. My goal is that by the end of the session, you can confidently recreate and update these reports independently for future quarters. I’m available for live training and can start based on your preferred schedule.
₹2,500 INR in 2 days
4.9
4.9

Dear Sir/Mam, ★★★ TOP 1% IN FREE LANCER WORLD ★★★ ★★★ 20+ Year Experience in IBD being CMD ★★★ ★★★ 200+ Country Satisfied Clientele ★★★ ★★★ Linkedin ★★★ ★★★ Data Entry ★★★ ★★★ Business Plans ★★★ ★★★ Operational Strategic planner ★★★ ★★★ Customer Support 24*7 ★★★ ★★★ Excel/Word Operation ★★★ ★★★ Chat Support ★★★ ★★★ Calling Support ★★★ ★★★ Business Plans / Marketing Strategy ★★★ ★★★ Digital Marketing ★★★ ★★★ Social Media Marketing ★★★ ★★★ Internet Marketing ★★★ ★★★ Any type of Data Projects ★★★ Regards, ★★★Marketing Team★★★ ★★★PVSYS GROUP (INDIA)★★★ ★★★IF YOU THINK THEN WE CAN★★★
₹10,000 INR in 31 days
3.5
3.5

Hello, I can provide practical, step-by-step Excel training focused specifically on your Q3 OM case reporting requirements. We will cover PivotTables, territory grouping, filters, helper columns, closed/open case identification, TAT and aging calculations, averages, and accurate Grand Totals. Rather than simply preparing the reports, I will explain the underlying logic so you can confidently maintain and update them each quarter. I’m comfortable working directly with your sample dataset through a live screen-sharing session and answering questions as we build each report.
₹1,500 INR in 2 days
3.2
3.2

Hi, I can help you learn this directly from your existing Q3 case report rather than simply preparing the reports for you. We can work through the actual dataset during the session, so you understand how to repeat the same process for future quarters. I will walk you through building the Q3 case count report with Domestic and International splits, Territory grouping and merged divisions, filters, and correct Grand Totals. We can then build the Average TAT report by identifying closed cases and using the existing Case Age No Weekend field where appropriate, followed by the Aging report for open cases above one day. The focus will be on understanding why each PivotTable, filter, grouping, helper column, and average calculation is being used. I will also show you how to update the reports when the next quarter's data is available. I am comfortable doing this as a live one-to-two hour screen-sharing session. You can share the sample Excel file beforehand, and I can review its structure so we can use the session efficiently. I am available to start as soon as convenient for you.
₹800 INR in 2 days
3.0
3.0

As a versatile professional adept in Excel, I confidently offer my services to teach you advanced techniques in data analysis and management reporting. My keen understanding of PivotTables, filtering, grouping, calculated columns and Grand Totals aligns perfectly with your requirements. Moreover, I am well-versed in turning raw data into valuable insights, making me an ideal candidate to help you create the Q3 Case Count Report, Average TAT Report, as well as the Aging Report. My proficiency also extends to data manipulation and analysis using complex datasets, such as your Q3 OM case dataset. Through step-by-step guidance tailored to your needs,I ensure my learners gain a comprehensive understanding of the processes involved rather than a mere copy-and-paste approach. I believe that once we complete 1-2 hours of live screen-sharing/training session where you can ask all the queries required for these three reports, you will be proficient enough to independently create/update such reports every quarter.
₹1,500 INR in 1 day
2.0
2.0

Hi, I'd be happy to walk you through building management reports in Excel using PivotTables, filters, grouping, and calculated columns. While this is tutoring rather than data cleanup, I'm comfortable working with Excel data. As a new freelancer on the platform, I'm competitive on price and committed to clear written communication. I can deliver a session within 3 days and provide a reference guide afterward. Could you share a redacted sample of the Q3 OM case dataset so I can tailor the walkthrough to your exact fields? I'm looking forward to helping.
₹1,000 INR in 7 days
0.0
0.0

Hi, I can help you build all three Q3 management reports while teaching you the process step by step, so you can update them independently each quarter. During the session, we can work directly with your sample case-level dataset and cover: • Q3 case counts by Domestic/International and Territory • Territory grouping such as ALLA 2026-M / ALLA 2026-S • Closed-case count and Average TAT • Open-case aging > 1 day • PivotTable filters, grouping, helper columns, averages and Grand Totals • How to refresh the same reporting structure with future quarterly data I will focus on explaining why each PivotTable field, filter and calculation is used, rather than simply building the reports for you. I’m available for a 1–2 hour screen-sharing session and can work from your sample Excel file. Bid: ₹1,000 INR Regards, SmartDevLab
₹1,000 INR in 1 day
0.0
0.0

Hello, We are Whitekraaft Solutions LLP. We would be glad to teach you step by step, so you can build and refresh these reports yourself every quarter. Our rate: ₹1,500 per hour (hourly rate, live screen-share session). This bid covers the first 1-hour session. If you'd like a second hour, it's at the same hourly rate. What we'll cover using your Q3 case data: - Case Count report: total, Domestic vs International, and by Territory using PivotTables - Grouping territories (e.g. ALLA 2026-M / ALLA 2026-S) and getting Grand Totals right - Average TAT for closed cases using helper columns and the Case Age No Weekend field - Aging report: open cases older than 1 day, count, average aging, Domestic vs International - Filters, grouping, calculated fields, and how to refresh everything next quarter You'll also get a short written cheat sheet of the steps, and I can record the session for you to revisit if you're comfortable with that. Availability: We are happy to work around your schedule. Please share the sample file beforehand, with sensitive data masked, so we use the session time well. Regards, Sambit Whitekraaft Solutions LLP
₹1,500 INR in 1 day
0.0
0.0

Hello, I can help you learn how to build and maintain these Q3 management reports using your existing Excel case-level dataset. I will focus on teaching you step-by-step, rather than simply creating the reports for you. During the session, I can guide you through: * Creating and configuring PivotTables * Q3 case count and Domestic vs. International analysis * Case counts by Territory and merging/grouping territory divisions * Correct use of Grand Totals * Identifying closed and open cases * Calculating average TAT using the existing Case Age No Weekend field where appropriate * Creating the Aging Report for cases older than 1 day * Using filters, helper/calculated columns, and PivotTable fields * Checking the results for accuracy * Refreshing and updating the reports for future quarters I can work with your existing Excel file and explain each step clearly so that you understand the process and can independently recreate the reports later. I am available for a 1–2 hour live screen-sharing session and can adapt the training to your current Excel skill level. I would be happy to review a sample of your source report before the session so we can make the training focused on your actual requirements. Thank you, Sumer
₹700 INR in 7 days
0.0
0.0

With 10+ years of experience in Excel, data analysis, PivotTables, Macros, and VBA, I can create detailed management reports and turn your data into clear, actionable insights. I can also provide step-by-step guidance so you understand the process and can confidently manage the reports yourself. My focus is on accurate analysis, practical reporting, and easy-to-follow training.
₹1,050 INR in 1 day
0.0
0.0

Hello, I can provide a step-by-step Excel training session focused on PivotTables, filters, grouping, helper columns, averages, and Grand Totals. I can guide you through creating the Q3 Case Count, Average TAT, and Aging reports using your existing dataset, rather than simply doing the work for you. My goal will be to make sure you understand the process well enough to repeat and update these reports independently each quarter. I’m available for a 1–2 hour live session and can start immediately. Best Regards Fatima
₹600 INR in 1 day
0.0
0.0

Hello, I’m a Data & Business Intelligence professional with 3+ years of experience using Excel for data analysis, reporting, reconciliation, and management dashboards. I can teach you the process step-by-step rather than simply building the reports for you. During the 1–2 hour session, I can guide you through: * Building the Q3 Case Count PivotTable and validating Grand Totals. * Separating Domestic vs. International cases. * Identifying closed cases and calculating average TAT using Case Age No Weekend. * Creating an Aging analysis for open cases with Case Age >1 day. * Using filters, helper/calculated columns, PivotTable settings, and appropriate averages. * Structuring the workbook so you can repeat and update the reports each quarter. My approach will be practical: we work directly with your sample dataset, and I explain why each step is performed so you can independently recreate the reports afterward. I’m available for a live 1–2 hour session and can start soon. My rate is $15/hour. Thank you, Gadvin Gitamo
₹700 INR in 7 days
0.0
0.0

With over a decade of experience spanning data analysis and software development, I'm confident that navigating the complexity of Excel for management reports will be a breeze. I specialise in curating clear, concise training materials and guiding others through the intricacies of Excel. We can ensure that I'll teach you all you need to know about Pivot Tables, filters, grouping, calculated/helper columns, averages, and Grand Totals in a step-by-step manner to precisely meet your learning needs. My proficiency with data management techniques such as data processing and cleansing further solidifies my suitability for this role. Additionally, as a Full Stack developer, I am well-informed about manipulating arrays of unique fields to build your territory divisions like ALLA 2026-M and ALLA 2026-S just as you specified. I'll not only help you create the reports now but guide you towards mastering these skills on your own so you can efficiently update them in future. It is important to note that my customer service skills have been refined over the years which means effective communication and providing guidance are second nature to me. So rest assured; not only will we efficiently tackle this project together but you can depend on me 24/7 to provide continuous and comprehensive support even after project completion should post-training questions arise. Let's get your management reporting game up to speed together!
₹1,050 INR in 7 days
0.0
0.0

Building these three reports yourself, so next quarter you can update them without help: that's exactly how we'd run the session. On screen-share, with your Q3 OM case file, you build each one while we guide: - Case Count: PivotTable with Territory in rows and Domestic/International in columns, plus a helper column that merges ALLA 2026-M and ALLA 2026-S so the Grand Totals stay right - Average TAT: filter to closed cases, count them, and average Case Age No Weekend, split Domestic vs International - Aging: open cases older than 1 day, with count and average age - A one-page cheat sheet of the steps afterwards, for next quarter Free value: a common trap is Case Age No Weekend stored as text. The PivotTable then shows a count instead of an average, or zeros. We'll check that first. 1 to 2 hours, at a time that suits you (we're in India, IST). Which Excel version are you on: Microsoft 365, or an older desktop version? Chaman
₹600 INR in 2 days
0.0
0.0

Bengaluru, India
Payment method verified
Member since Aug 18, 2025
₹600-1500 INR
₹600-1500 INR
₹100-400 INR / hour
£1500-3000 GBP
₹1500-12500 INR
$25-50 USD / hour
₹750-1250 INR / hour
$20-60 USD / hour
$30-250 USD
$15-25 USD / hour
$30-250 USD
₹600-800 INR
$25-50 USD
$250-750 USD
₹400-750 INR / hour
£250-750 GBP
$15-25 CAD / hour
$250-750 USD
₹750-1250 INR / hour
₹1500-12500 INR
₹750-1250 INR / hour
$10-30 USD
£20-250 GBP