Learning Path
Excel Expert
Level
Advanced
Enrollment
Closed
Instructor-Led Live Session
Live Session Recording
Expert Support
Case Studies & Projects
Dedicated Resource Portal
04 weeks (Sat & Sun)
01:00 PM to 03:00 PM
Language
Urdu / Hindi
Microsoft Excel can be used to create pivot tables and pivot charts, which are very useful in organizing, summarizing, and analyzing data from large data set.
This course will provide you with the best ways to:
- Source and clean up source data for reporting.
- Present the data in a way that is easy to use for analysis by presenting data in both tabular and visually.
- Analyze the data and drill in and out of data.
At the end of this course, you will be able to
- Create robust, easy-to-maintain Dashboards.
- Better & error-free Excel reports.
- Discover data insights in the quickest possible time.
Prerequisite
Attendees must have Excel proficiency equivalent to our Excel for Everyone course
Course Content
You will get
- Exercise and Project files
- Pre and Post Assessment
- Quizzes and Homework assignments
- 1-month access to the resource portal
- HD Recording of all live sessions
Certificate of Completion
You will be awarded a course completion E-Certificate by TechTAR Solutions after fulfilling the course requirements.
- Excel users who want to build a solid foundation for advanced analytics
- Analysts or BI professionals looking to extract insight and meaning from raw data, using expert-level PivotTable techniques
- Anyone seeking to improve productivity and work more efficiently with data
- Classes will be interactive throughout & LIVE on Zoom. You would be able to ask questions & share views with the Technical Assistant, Trainer & class other participants.
- All PivotTable tasks can be performed in any version of Excel. Tasks related to Power Query require installation of the free Power Query tools in some versions of Excel.
Recommendations:
- Computer with internet access, a webcam, microphone, and Zoom App.
- Microsoft Excel 2016+ or Office 365 (ideally for PC/Windows)
No advance preparation is required
Excel's basic Pivot Table requirements
- Source data structure
- The field list
- Contextual menus
- Refreshing
Formatting options and tools
- Value field formats
- Report Layout
- Grouping Data
- Automatic Date Grouping
- PivotTable Styles
- Sorting Pivot Tables
Sourcing data using Power Query
- The BI life cycle
- Using Power Query & Transform data
- Appending Data Tables
- Consolidating Excel Data
- Unpivoting Data
Value Field Settings
- Summarize Value by (SUM, COUNT and Others)
- Show value as
- Calculated Fields
- Get Pivot Data
Slicing and Filtering
- Label Filter & Manual Selection
- Label Filter with Wildcards
- Value Filter
- Enabling Multiple Filters
- Timelines
- Show Detail Feature
- Slicer and Timelines Formatting options
Conditional Formatting
- Basics of Conditional Formatting
- Data Bars with Indivisible Text
- Advanced Conditional Formatting
Working with Pivot Charts
- Intro to Pivot Charts
- Pivot Chart Formatting
- Expanding and collapsing Pivot Charts
Techniques for Data Analysis
- Comparison Analysis
- Trend Analysis
- Ranking Analysis
- Contribution Analysis
- Variance Analysis
- Frequency Analysis
- Correlations
Building Pivot based Dashboards
- Pivot tables Synchronization
- Tricks for Extracting Key Info
- Using Excel Shape and Objects
- Camera Tools
Data Refresh and Security
- Pivot table Refresh
- Excel Password Protection
Individual Price
PKR 7,000
Per Person
Total charges for complete training
Group of Two
PKR 6,300
Per Person
Avail 10% off on a Group of two
Group of Three
PKR 5,950
Per Person
Avail 15% off on a Group of three
Group of Four or more
PKR 5,600
Per Person
Avail 20% off on a Group of four or more
Course Reviews
We have engaged TechTAR Solutions for a number of session in Excel and Power BI for our employees. Sohail Merchant is wonderful to deal with when making the bookings and the high level of experience the trainers hold is evident. We will definitely use them again in the future.!
I was tasked with seeking out a company to assist us in recreating our department’s appraisal Matrix and after meeting with TechTAR Solutions’ consultant, I knew they were the right fit to help get the job done! Their expertise and understanding of our needs made the whole process so simple.
Sohail Merchant from TechTAR Solutions’ [ explained the theory very well, also gave us sufficient room to ask questions and clarify our queries. Enough resources were provided to read and increase our knowledge on individual capacity..
Lots of useful information, Ideas & strategies with many practical examples. I learned a lot throughout the course & implementing it in my business. Sohail Merchant from TechTAR Solutions’ expertise gave me an amazing learning experience. Thank you.
The professionalism and Personalized service that we got from TechTAR Solutions was unlike any other company we worked with and they made us feel so comfortable by their natural communication and let’s do it attitude. Incredibly trustworthy and high value! Thankyou!
Please keep developing the products and solutions to make our lives more easier and work to be more focused efficient targeted and productive. Appreciate the contributions of the entire community in this.