# Event Details - **Event Name**: Excel Analytics: 4 Days Hands-On Training in Canberra - **Event Start and End Date**: Wed, 06 May, 2026 at 09:00 am – Mon, 12 Oct, 2026 at 05:00 pm (-04:00) - **Event Description**: Master Excel analytics, dashboards, and data tools in 4 days to improve reporting, insights, and business decision-making skills.About this EventBring your team and save:1. Groups of three or more receive a 10% discount2. Organizations hosting an in-house session with 10+ participants enjoy a 15% discount.For more information on venue address, reach out to "eventbrite@mgaussie.com"Duration: 4 DaysDelivery Mode: Classroom (In-Person)Language: EnglishCredits: 32 PDUs / Training HoursCertification: Course Completion CertificateRefreshments: Lunch, snacks and beverages will be provided during the sessionCourse Overview:Grab Excel Analytics Profile in our Hot marketIn this corporate world, analyzing the current and future needs, undoubtedly we need ananalytical skill to take preventive measurement. Apparently, all the companies arefollowing the same by having skilled analytical resources. Henceforth, to enhance yourskill and succeed in that level, you must have mandate knowledge in Excel analyticalskills which is irrespective of working in IT/non-IT sector and in anydepartment/business.Excel Dashboards are diagnostic tools designed to provide busy managers with a quickoverview of a company's performance. AS a Concept Performance dashboards havebeen around for many years and reports indicate that they have been widely adopted bybusinessLearning Objectives:● Overview on MS Visio & Powerpoint● Overview SAP Business Intelligence Tool● Tips & Tricks will be driven at the EOD in all 4 days session.● Corporate Interview Questions & Answers● Excel ShortcutTarget Audience:There is no Eligibility Criteria for this training, anyone can attend this trainingWhy Choose This CourseThis course is designed to provide practical, hands-on Excel analytics skills that are immediately applicable in real-world business scenarios. From advanced formulas to dashboard automation, it equips you with the tools needed to analyze data efficiently, improve decision-making, and enhance your professional value across industries.©2026 MG Aussie Events. This content is protected by copyright law. Copy or Reproduction without permission is prohibited.Why People Should Opt for In-House TrainingIn-house training allows organizations to tailor the course content to their specific business needs, data challenges, and workflows. It ensures teams learn using real company data, improves collaboration, and delivers faster, more relevant results that directly impact productivity and performance.Contact us today to schedule a customized in-house, face-to-face session: https://cdn-az.allevents.in/events3/banners/61c39d10-2e7f-11f1-a796-25373a183b85-rimg-w983-h740-dc497aa8-gmir.jpg https://cdn-az.allevents.in/events10/banners/61fbc410-2e7f-11f1-b4a4-e74a4bf63e65-rimg-w983-h740-dcd6d1c3-gmir.jpg https://cdn-az.allevents.in/events10/banners/6238cd10-2e7f-11f1-a796-25373a183b85-rimg-w1200-h678-dcffffff-gmir.jpg https://cdn-az.allevents.in/events6/banners/6276c070-2e7f-11f1-b66b-c789a2302db1-rimg-w983-h740-dc91938d-gmir.jpg https://cdn-az.allevents.in/events10/banners/62aee770-2e7f-11f1-a796-25373a183b85-rimg-w1200-h392-dcffffff-gmir.jpg https://cdn-az.allevents.in/events6/banners/62ded110-2e7f-11f1-b4a4-e74a4bf63e65-rimg-w1200-h697-dcffffff-gmir.jpg AgendaExcel 2007 & 2010 Quick OverviewInfo: Difference between Excel 2003, 2007 & 2010, Use of Excel and its boundaries & FeaturesProgram Fundamentals :Info: What’s New in Excel 2010, Understanding the Excel Program Window, Customizing the Ribbons, Using Ribbon Shortcuts, Using Help, Customizing the Quick Access Tool Bar, Overview of Office Button and Dialog box.Getting Started with Worksheets :–Info: Cut, Copy and Paste Special mechanisms, Cell Range Reference, Overview of Formulas, Entering Formulas, Formatting Numbers and Cells, Managing Alignment, Conditional Formatting, Document Themes, Finding & Removing Blank cells, Object, Shapes and Smart art.Working with Data Ranges :Info: Custom Sort, Filtering Data, Creating a Custom AutoFilter, Using an Advanced Filter, Data Validation, Removing Duplicates in multiple aspects, Grouping, Ungrouping and Subtotal workings, Hyper Links, Text to Columns, Sticky notes comment.Managing Workbooks :Info: Selecting and Switching Between Worksheets, Inserting and Deleting Worksheets, Renaming, Moving, and Copying Worksheets/Workbooks, Splitting and Freezing a Window, Hide/Unhide usage, Setting the Print Area, Adjusting Page Margins and Orientation, Protecting Worksheets and Workbooks and Sharing Workbooks.FunctionsOverview:-Info: Introduction to Formulas and Functions by Syntax, Parameters and Values, Formulas using Wizard, Cell Reference and Absolute Cell ReferenceFormulas and Functions :–Info: VLOOKUP, HLOOKUP, Match, Index, Logical at all levels, Statistical, Logical, Concatenate, Text, Date & Time and More Functions, Name Ranges, Using Named Ranges in the Formulas, Using the Name Manager, Evaluating the Formulas and Error Checking, Goal Seek analysis, Consolidate Method, AutoCalculate and Manual Calculation.Working with the Web and External Data:-Info: nserting a Hyperlink, Importing Data from Access or Text Files or Other Sources, Working with Existing Data Connectionsfrom SQL Server or XML Data. Practicing on Formulas and Functions to enhance the skills in a speedy way.Working with Tables and Pivot Tables:Info: Creating a Table, Filtering a Table, Summarizing a Table with a PivotTable, Creating a PivotTable, Changing a PivotTable Calculation, Grouping, Filtering and Sorting a PivotTable, Various analyses in the PivotTable, Formatting a PivotTable, Using Slicers, Power Pivot, Sharing Slicers Between PivotTables.Creating and Working with Charts:Info: Creating Multiple Charts at all levels, Choosing the Right Chart, Changing Chart Layout and Style, Using Chart Templates, Workings on Settings for the apt view, Changing the Scale, Primary and Secondary axis workings, Changing Chart Type.Ad-Hoc Tasks :Info: Understanding the Business/Process requirements and completing the task in a short span of time with the hygienic way in terms of delivering high level upshot of the Dashboards. As a result of that management can take action against the process improvement by eagle-eyed performance metrics in various aspects. Apparently, we can make you think, that level of spontaneous thoughts to some extent by giving more examples and workings.Automation :Info: Automating the Dashboards to cut down the repetitive steps for any type of dashboards for logical reasons.In such case, we can cut down the resources and we can cut down the SLA as well with the precise excellence and fortunately it’s user friendly too. Here, we will be educating you in enormous ways to automate the dashboards by yourself to some extent, which will help you to showcase your skills in a bigger vision in front of your peers - **Event URL**: https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182 - **Event Categories**: workshops, art - **Interested Audience**: - total_interested_count: 0 ## Ticket Details - **Ticket URL**: https://consumer.pxf.io/c/1339408/3151484/39691?partnerpropertyid=1191892&MediaPartnerPropertyId=1191892&svlink=14105511&level=1&u=https%3A%2F%2Fwww.eventbrite.com%2Fe%2Fexcel-analytics-4-days-hands-on-training-in-canberra-tickets-1986290442182 - **Ticket Price Range**: min: 3336.69, max: 4766.13, currency: AUD ## Event venue details - **city**: Canberra - **state**: CT - **country**: Australia - **location**: Regus - Canberra, Gateway Business Center - **lat**: -35.3053031 - **long**: 149.1933066 - **full address**: Regus - Canberra, Gateway Business Center, CANBERRA, Canberra Airport Level 4, Plaza Offices, Australia ## Event Organizer details - **affiliate_id**: 10 - **organizer**: MG Aussie (https://allevents.in/org/mg-aussie/26713862) ## Event gallery - **Alt text**: banner - **Image URL**: https://cdn-az.allevents.in/events10/banners/34ef7b848b17ad59ec3cbc6e2d8c33918e4a6fc89538d8f725bf344ac27b9eda-rimg-w800-h602-dc2f2b31-gmir.jpg?v=1775126012 - **Alt text**: thumbnail - **Image URL**: https://dyn-image.allevents.in/generate-image?v=4&title=Excel+Analytics%3A+4+Days+Hands-On+Training+in+Canberra&date=06+May ## FAQs - **Q**: When is the event happening? - **A:** Wed, 06 May, 2026 at 09:00 am (-04:00) - **Q**: Where is the event happening? - **A:** Regus - Canberra, Gateway Business Center, CANBERRA, Canberra Airport Level 4, Plaza Offices, Australia - **Q**: What is the ticket price? - **A:** starting from 3336.69 up to 4766.13 AUD - **Q**: Who is organizing the event? - **A:** MG Aussie - **Q**: What type of event is this? - **A:** workshops, art - **Q**: Where can I find ticket details about Excel Analytics: 4 Days Hands-On Training in Canberra ? - **A:** You can find ticket details about this event on AllEvents. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "Excel Analytics: 4 Days Hands-On Training in Canberra", "image": "https://cdn-az.allevents.in/events10/banners/34ef7b848b17ad59ec3cbc6e2d8c33918e4a6fc89538d8f725bf344ac27b9eda-rimg-w800-h602-dc2f2b31-gmir.jpg?v=1775126012", "startDate": "2026-05-06T09:00:00-04:00", "endDate": "2026-10-12T17:00:00-04:00", "url": "https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182", "eventStatus": "https://schema.org/EventScheduled", "location": { "@type": "Place", "name": "Regus - Canberra, Gateway Business Center", "address": { "@type": "PostalAddress", "streetAddress": "CANBERRA, Canberra Airport Level 4, Plaza Offices", "postalCode": "2609", "addressLocality": "Canberra", "addressRegion": "CT", "addressCountry": "AU" }, "geo": { "@type": "GeoCoordinates", "latitude": "-35.3053031", "longitude": "149.1933066" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "Master Excel analytics, dashboards, and data tools in 4 days to improve reporting, insights, and business decision-making skills.", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "AUD", "availabilityStarts": "2026-04-02", "availabilityEnds": "2026-10-12T17:00:00-04:00", "validFrom": "2026-04-02", "lowPrice": "3336.69", "highPrice": "4766.13", "price": "3336.69", "url": "https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "AUD", "availabilityStarts": "2026-04-02", "availabilityEnds": "", "validFrom": "2026-04-02", "url": "https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182", "price": "3336.69", "name": "Group Registration Fee" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "AUD", "availabilityStarts": "2026-04-02", "availabilityEnds": "", "validFrom": "2026-04-02", "url": "https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182", "price": "3707.28", "name": "Early Bird Fee" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "AUD", "availabilityStarts": "2026-04-02", "availabilityEnds": "", "validFrom": "2026-04-02", "url": "https://allevents.in/canberra/excel-analytics-4-days-hands-on-training-in-canberra/100001986290442182", "price": "4766.13", "name": "Standard Fee" } ], "organizer": [ { "@type": "Organization", "name": "MG Aussie", "url": "https://allevents.in/org/mg-aussie/26713862", "description": "Why Partnering with MGAUSSIE Works for YouFuture-Ready Workforce: Equip your team with up-to-date technical skills in data analytics, cybersecurity, and more to stay ahead in a competitive market.Practical, Hands-On Training: Ensure learning translates into action with project-based, interactive modules.Wide Industry Reach: Join a network of over 15,000 upskilled professionals and leading organizations who trust our expertise.Flexible Delivery Methods: Choose from a variety of learning modes—including virtual labs, self-paced courses, and in-person workshops—tailored for your convenience.Industry-Aligned Content: Benefit from courses developed in collaboration with leading tech partners, ensuring maximum relevance and applicability.Popular courses:Grant Writing EssentialsPublic SpeakingTrain-The-TrainerInternet Marketing FundamentalsOrganizational Skills" } ] } ] ```