Welcome to CBitss, Mentoring you with Management Training.
Mon-Sat : 8:00AM - 8:00PM
Sunday 10:00AM - 4:00PM
SCO 23-24-25, Sector 34A
Advanced Excel training in Chandigarh
Microsoft Excel is a spreadsheet establish by Microsoft for Windows, macOS, Android and iOS. Its main function is calculation, graphing tools, pivot tables and also facilities macro programming. CBitss which is an ISO 9001:2008 certified company which provides advanced excel training in Chandigarh.
Excel has the same basic features as every spreadsheet which use a collection of cells arranged into rows and columns to organize data manipulation. It also displays data as charts, histograms and line graphs.
Learn the expert features and functions in Microsoft Excel alongside our expert author to help you get you beyond the basics and have advanced-level proficiency within the Excel.
In this course we’ll cover the basics of Excel, including SUM, MIN, MAX and other conditional statements. Then , we will quickly move onto more advanced-level topics including VLOOKUP and HLOOKUP, IF statements, Sparklines, Pivot Tables and Charts, Macro Operations.
Suitable for beginners with Microsoft Excel but also for those who wish to cover the advanced topics in Excel which will enable you to use Excel expertly within in a personal or commercial environment.
This course covers:
- Using advanced graphs and presentation techniques to maximize impact.
- How macros and VBA automate your spreadsheets and increase interactivity.
- How superpower functions can solve complex problems.
- Using PivotTables and PowerPivots to turn raw data into clear information that supports key decisions.
Watch the Video to know the SUCCESS story of Mr. Jaspreet Singh
Submit Your Details for Career Counselling
Syllabus for Advanced Excel Training in Chandigarh:
Unit 1:- Using Mathematical Functions
- The Basic SUM, COUNT, MIN, And MAX
- AVERAGE, MODE, MEAN, And MEDIAN
- SUMIF For Selective Adding Up
- COUNTIF For Selective Counting
- AVERAGE IF For The Mean Of Selected Cells
- Multiple Criteria Within SUMIF, COUNTIF, And AVERAGEIF
- Area And Volume Calculations
Unit 4:- Sparklines
- Creating A Sparkline
- Altering The Design Of Sparklines
- Dealing With Empty Cells
- Comparing Sparklines Within A Sparkline Group
- Removing Sparklines From A Worksheet
Unit 5:- Further Mathematical Functions
- Working With Time In Excel
- Calculations Using Time
- Useful Time And Date Functions
- Rounding Decimal Places
- MOD And INT Functions And Uses
- Generate And Use A Random Number
- Loan And Investment Calculations
- Loan Calculation Elements And Functions
Unit 8:- Custom Views
- Custom Views Explained
- Use Of Outlining To Help Setup Custom Views
- Editing And Deleting Custom Views
- Add Quick Access To Custom Views
Unit 10:- Arrays
- Arrays And Creating A New Array Formula
- Array Formulas With IF Statements
- Conditional Evaluation With No IFs
- The Array-Only TRANSPOSE Function
Unit 11:- Useful Data Functions
- Using The MATCH Function
- How The INDEX Function Works
- Handling Out Of Range Index Requests
- The CHOOSE Lookup Function
- MATCH And INDEX Functions Working Together
Unit 13:- Auditing & Troubleshooting Formulas
- What Are Tracer Arrows
- Adding And Removing Tracer Arrows
- Auditing Tools: Error Checking And Tracing
- Step-By-Step Formula Processing
- Using The Watch Window In Troubleshooting
Unit 2:-IF Functionality
- IF Syntax And Uses
- Nesting The IF Statement
- Use Of The AND Operator Within An IF
- Use Of The OR Operator Within An IF
- The NOT Operator Within AND And OR Statements
- Display Cell Formulas In Another Cell
Unit 3:- Performing Data Lookups
- VLOOKUP: Syntax And Usage
- VLOOKUP In Live Action
- HLOOKUP: Variation On A Theme
- Using A Near Match In The Lookup
- Dealing With Missing Data In A Lookup
- Managing The Lookup Table
- Lookups Nested Within Lookups
Unit 6:- Custom Views
- Custom Views Explained
- Use Of Outlining To Help Setup Custom Views
- Editing And Deleting Custom Views
- Add Quick Access To Custom Views
Unit 7:- Scenarios
- Setting Up A Set Of Scenarios
- Displaying And Editing The Different Scenarios
- How To Work Out Which Scenario You Are Displaying
- Merging And Deleting Scenarios
- Producing A Summary Of Scenarios
Unit 9:- Functions For Manipulating Text
- LEFT And RIGHT: Text Manipulation
- LEN And TRIM: String Extractions
- FIND And MID: Text Functions Working Together
- CONCATENATE: Building Strings From Multiple Cells
- Changing Case Functions
- REPLACE And SUBSTITUTE: Two More String Manipulation Functions
- Use Of CHAR Function For More Obscure Characters
- Formatting Numeric And Date Values Using TEXT
- Keeping The Values Created By String Manipulation
Unit 12:- Some Other Useful Functions
- Introducing Is Functions
- Error Checking Using ISERR, ISERROR, And IFERROR
- OFFSET Function Syntax
- OFFSET Function: Creating A Dynamic Named Range
- INDIRECT Function To Build Dynamic Formulas
- Dealing With INDIRECT Errors
- The CELL Function And Determining File Or Sheet Names
Unit 14:- PivotTables
- What Is A PivotTable?
- The New Recommended PivotTable Route
- Creating Your Own PivotTables
- Changing The Formatting And Formulas In Pivot Table Summaries
- Creating Multiple Pivot Tables On The Same Dataset
After completion of Advanced excel training in Chandigarh, you will master :
- To take your basic Excel skills to the next level.
- To gain a solid understanding of the more powerful features and functions in Excel.
- Gaining Insights from vast array of data with ease.
- Making powerful dashboards.
- Analysing data like a professional.
- Understanding shortcut techniques for faster and efficient use of Excel.
- To be able to use Microsoft Excel in a commercial environment.
Get in Touch with Us
CBitss Trainer's Profile
- Kishore Kashyap is Finance HR industrial trainer along with deep knowledge in various types of industries like National, International MNC’s company.
- He is certified Professionals with 7+ years of experience.
- He has acquired awards and acceptance from our partners and numerous recognized IT Organizations.
- He is well connected with Hiring HR for MNCs.
I am very impressed with the recruiting services provided by CBitss in HR training in Chandigarh. They gave me periodic and detailed notes with the information that help me in future to make good hiring decisions. All their efforts helped me a lot to accelerate my skills. All Staff is very helpful and cooperative in CBitss.
Ashish Garg
(Punjabi University, Patiala)
My experience with CBitss was an extremely positive. My mentor really took the time to get to know me, asked relevant questions, were easy to talk with and very enlightening when defining each of the positions presented. I want to thank you for the special service you and your team have provided me.
Navjot Kaur
(PTU, Jalandhar)
HR training in Chandigarh helped me to fill a alternate HR generalist role at our company and from starting I was very fascinated with their professionalism, knowledge, and their services. They are absolutely good at providing training to students through the HR point of view. I would definitely recommend others to join services provided by CBitss.
S. K. Batra
(HP University)
Do You Need Help?
Contact us at the FinExpert office nearest to you or submit a business inquiry online.
Computer Courses
Industrial Training
Accounting Courses
Managment Courses
English Courses
