*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

Advance Excel & Arc GIS Data Analysis (Pivot / Power Pivot)

Be the first to rate Advance Excel & Arc GIS Data Analysis (Pivot / Power Pivot
Or log in to access your purchased courses
by fatima
Price: 180,000
2 Months/20 Hours
0 Lessons

Advanced Excel & Arc GIS Data Analysis (Pivot / Power Pivot)

Pivot Tables are one of the most powerful features in Microsoft Excel, allowing users to quickly summarize, analyze, explore, and present large amounts of data. This course is designed to take you from the basics of creating Pivot Tables to advanced techniques for data analysis, enabling you to make insightful data-driven decisions.

Throughout this course, you will learn how to create and customize Pivot Tables, use Pivot Charts for visual data representation, and apply advanced techniques such as calculated fields and items. Whether you are a beginner or looking to refine your skills, this course will provide you with the knowledge and tools to master data analysis using Excel Pivot Tables.

What you’ll learn
  • You will learn about Pivot Tables and Pivot Charts
  • You will learn to create 2 interactive Excel Dashboards
  • You will learn how to use 20 Plus different Excel Charts and Graphs used in Dynamic Excel Dashboards.
  • You will learn how to Design, Format and Style Data Elements
  • You will learn 30 Plus top Microsoft Excel Formulas and Functions

Course Outline:

Module1. Introduction to Pivot Tables:

  • What is a Pivot Table?
  • Benefits and use cases of Pivot Tables.
  • Understanding the Pivot Table interface.

Module2. Creating Your First Pivot Table:

  • Preparing your data for Pivot Tables.
  • Inserting a Pivot Table.
  • Navigating the Pivot Table Field List.
  • Basic Pivot Table layout and design.

Module3. Customizing Pivot Table Layout:

  • Using different report layouts (Compact, Outline, Tabular).
  • Rearranging fields in Rows, Columns, Values, and Filters.
  • Grouping data (by dates, numbers, and text).
  • Sorting and filtering data in Pivot Tables.

Module4. Summarizing Data:

  • Value field settings (Sum, Count, Average, Max, Min, etc.).
  • Showing values as percentages, running totals, and differences.
  • Custom calculations using calculated fields and items.

Module5. Pivot Table Formatting:

  • Formatting numbers and fields.
  • Conditional formatting in Pivot Tables.
  • Customizing the Pivot Table style.

Module6. Working with Pivot Charts:

  • Creating Pivot Charts from Pivot Tables.
  • Types of Pivot Charts and their uses.
  • Customizing Pivot Chart layout and style.
  • Interactivity between Pivot Tables and Pivot Charts.

Module7. Advanced Pivot Table Techniques:

  • Using slicers and timelines for dynamic filtering.
  • Creating and managing multiple Pivot Tables from the same data source.
  • Using GETPIVOTDATA for advanced referencing.
  • Combining data from multiple ranges with Power Pivot.

Module8. Practical Applications:

  • Case studies and real-world examples.
  • Analyzing sales data, financial reports, and customer data.
  • Creating dashboards with Pivot Tables and Pivot Charts.

Module9. Best Practices and Tips:

  • Ensuring data quality and integrity.
  • Optimizing performance with large datasets.
  • Common pitfalls and troubleshooting tips.
  • Automating Pivot Table tasks with macros.

Who this course is for:
  • If you are looking to improve your Microsoft Excel Skills
  • If you want to learn how to create Excel Charts, Formulas and Functions and Excel Shortcuts
  • If you want to learn foundation of how to create Excel Dynamic Dashboards
  • If you create Management Reports or MIS
  • Excel users who have basic skills but would like to become more proficient in data exploration and analysis
  • Anyone who works with Excel on a regular basis

International Student Fees: usd700$

Job Interview Preparation  (Soft Skills Questions & Answers)

Stay connected even when you’re apart

Join our WhatsApp Channel – Get discount offers

 500+ Free Certification Exam Practice Question and Answers

 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

 Join Internships and Referral Program (click for details)

Work as Freelancer or Full-Time Employee (click for details)

Hire an Intern

Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Training Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Excel Training Course for Beginners

Advanced Excel

Financial Modeling Course

Microsoft Certified Solutions Associate (MCSA) Office 365

MicroSoft Power BI




Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Or log in to access your purchased courses

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us