# Event Details - **Event Name**: In-depth Excel Training, Executive Dashboards & Business Data Analysis - **Event Start and End Date**: Thu, 27 Nov, 2025 at 09:00 am – Fri, 28 Nov, 2025 at 05:00 pm - **Event Description**: In-depth Excel Training, Executive Dashboards & Business Data AnalysisAbout this EventBelow are the details of our next training to take place in Lagos. Thanks for your interest!This is a special opportunity for you to be trained at a specially discounted cost by professionals who have done Microsoft Excel training and consulting for MTN Nigeria, Airtel Nigeria, Vodacom, Globacom, Guinness, Nigerian Breweries, Total E&P and many other local and international companies.You will get to learn all you need to boost your productivity at work and your career/entrepreneurial prospects. So this is an opportunity you shouldn't miss.The training details are as follows:Venue: UrBizEdge, 11 Oseni Street, adjacent GTBank, Anthony Village, Lagos.Cost: N120,000The cost covers your training materials, after-training support, video learning materials, certificate, and lunch. Try to pay early to secure your spot and send us your name as you would like it to appear on your certificate.Payment DetailsAccount Name: URBIZEDGE LIMITEDBank: FCMBAccount No: 2888666014Branch: OnipanuTitle: Business Data Analysis, Dashboards, and In-depth Excel TrainingTraining Outline1. Data Manipulation in Excela. How Excel handles different data typesb. Data consistency, starting with the end in viewc. Building Datasheets that can easily scaled. Sortingi. Cascaded sortingii. Sorting across rows (left-to-right sorting, not the usual up-to-down sorting)iii. Sorting and Conditional Formatting to identify trendse. Filteringf. Data cleaningi. Removing duplicatesii. Text-to-columniii. Groupingiv. Data Validationg. Data formattingi. Using Tables (and when to convert to tables)ii. Formatting for printingiii. Formatting for emailiv. Data Review and formatting for 3rd party useh. Named Ranges2. Chartsa. Chart typesi. Line chart and when to use itii. Column chart and when to use itiii. Bar chart and when to use itiv. Pie chart and it’s dangersb. Combining charts; when and how.c. Dynamic Charts, using filter.d. Best practices when making chartse. Sparklines3. Pivot Table, Pivot Chart and PowerPivota. Pivot Tablei. Default Pivot Tableii. Tabular Pivot Tableiii. Pivot Table Filteringiv. Making a very dynamic regular table from Pivot Tablev. Calculations and Formula use with Pivot Tablevi. Advanced Pivot Table tricksb. Pivot Charti. Pivot Chart and its limitationsii. Dynamic Pivot Charts4. Business Data Analysisa. Linking sheetsb. Duplicating sheets (better than copy and paste)c. Inserting sheets, labeling and coloring the professional wayd. Freezing Panes and splitting windowse. Conditional formattingi. To identify patternsii. Using formulaeiii. To make extremely intelligent reportsf. Lookup functions – VLOOKUP and othersg. IF, IFERROR, AND, OR, ISBLANK, and others in the same familyh. COUNTIF, SUMIF and others, to make dynamic summary tablesi. Math Functionsj. Text Functionsk. Date Functionsl. Formula Auditingm. Goal Seek, Scenario Manager and Data Tablen. Most useful Excel keyboard shortcuts5. Executive Dashboards and Reportinga. Best Practicesb. Executive Dashboardsi. What are Dashboardsii. Dynamic Reportsiii. Determining the KPIs and tracking themiv. Strategic Insights & Analysisv. Data Visualizationvi. Having the audience/recipient in mind6. Excel to PowerPoint and Worda. Linking PowerPoint/Word Charts to Excelb. Embedding Excel sheets in PowerPoint/Wordc. Making a Powerful PowerPoint Presentation7. Introduction to Excel Macros (VBA)a. What is Excel Macro?b. Its value propositionsc. Creating a macro from scratchd. Practice Session - **Event URL**: https://allevents.in/anthony-village/in-depth-excel-training-executive-dashboards-and-business-data-analysis/100001047750679487 - **Event Categories**: workshops, entertainment, music, parties - **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%2Fin-depth-excel-training-executive-dashboards-business-data-analysis-tickets-1047750679487 - **Ticket Price Range**: min: 156.57, max: 156.57, currency: USD ## Event venue details - **city**: Anthony Village - **state**: LA - **country**: Nigeria - **location**: URBIZEDGE LIMITED - **lat**: 6.5582279 - **long**: 3.3695118 - **full address**: URBIZEDGE LIMITED, 11, Oseni Street,, Anthony Village, Nigeria ## Event Organizer details - **affiliate_id**: 10 - **organizer**: UrBizEdge (https://allevents.in/org/urbizedge/18271219) ## Event gallery - **Alt text**: banner - **Image URL**: https://cdn-az.allevents.in/events5/banners/4a348e4a58e7621dd246452fa724ee05851ac7a9fbff83ca8449aa1e59826ee1-rimg-w1080-h1080-dc207443-gmir.jpg?v=1730774055 - **Alt text**: thumbnail - **Image URL**: https://cdn-az.allevents.in/events5/banners/dfe86c959cabe7d1e5cf73ff99870fdf6d36df95edffa26a49c81cf614413856-rimg-w400-h400-dc207443-gmir.jpg?v=1730774051 ## FAQs - **Q**: When is the event happening? - **A:** Thu, 27 Nov, 2025 at 09:00 am - **Q**: Where is the event happening? - **A:** URBIZEDGE LIMITED, 11, Oseni Street,, Anthony Village, Nigeria - **Q**: What is the ticket price? - **A:** starting from 156.57 up to 156.57 USD - **Q**: Who is organizing the event? - **A:** UrBizEdge - **Q**: What type of event is this? - **A:** workshops, entertainment, music, parties - **Q**: Where can I find ticket details about In-depth Excel Training, Executive Dashboards & Business Data Analysis ? - **A:** You can find ticket details about this event on AllEvents. ## Structured Data (JSON-LD) ```json [ { "@context": "https://schema.org", "@type": "Event", "name": "In-depth Excel Training, Executive Dashboards & Business Data Analysis", "image": "https://cdn-az.allevents.in/events5/banners/4a348e4a58e7621dd246452fa724ee05851ac7a9fbff83ca8449aa1e59826ee1-rimg-w1080-h1080-dc207443-gmir.jpg?v=1730774055", "startDate": "2025-11-27", "endDate": "2025-11-28", "url": "https://allevents.in/anthony-village/in-depth-excel-training-executive-dashboards-and-business-data-analysis/100001047750679487", "location": { "@type": "Place", "name": "URBIZEDGE LIMITED", "address": { "@type": "PostalAddress", "streetAddress": "11, Oseni Street,", "postalCode": "100001", "addressLocality": "Anthony Village", "addressRegion": "LA", "addressCountry": "NG" }, "geo": { "@type": "GeoCoordinates", "latitude": "6.5582279", "longitude": "3.3695118" } }, "eventAttendanceMode": "https://schema.org/OfflineEventAttendanceMode", "description": "In-depth Excel Training, Executive Dashboards & Business Data Analysis", "offers": [ { "@type": "AggregateOffer", "availability": "https://schema.org/InStock", "priceCurrency": "USD", "availabilityStarts": "2026-04-04", "availabilityEnds": "2025-11-28", "validFrom": "2026-04-04", "lowPrice": "156.57", "highPrice": "156.57", "price": "156.57", "url": "https://allevents.in/anthony-village/in-depth-excel-training-executive-dashboards-and-business-data-analysis/100001047750679487" }, { "@type": "Offer", "availability": "https://schema.org/InStock", "priceCurrency": "USD", "availabilityStarts": "2026-04-04", "availabilityEnds": "", "validFrom": "2026-04-04", "url": "https://allevents.in/anthony-village/in-depth-excel-training-executive-dashboards-and-business-data-analysis/100001047750679487", "price": "156.57", "name": "Reserve a slot and call Hope on +2347039902445" } ], "organizer": [ { "@type": "Organization", "name": "UrBizEdge", "url": "https://allevents.in/org/urbizedge/18271219", "description": "UrBizEdge is a registered business data analysis and consulting firm in Nigeria. We specialise in helping companies be on top of their business data. We focus exclusively on the world’s most used and most flexible business intelligence tool: Microsoft Excel. We have the only Microsoft Excel Most Valuable Professional in Africa. And there are just about 125 in the whole world. It’s the highest recognition Microsoft gives an independent industry expert.\r\nMISSION: To give our clients the business intelligence edge they need using tools they already have." } ] } ] ```