Advance Excel Course
Tally Course, Tally ERP 9, Spoken English Classes, Digital Marketing Course, Python for Beginners, Java Programming, Graphic Design Course, Website Development Course, Internship
Advance Excel Course
Course Detail
Advance Excel
This Advanced Excel Training program is best suited for people who use Microsoft Excel in their day-to-day work, and know the basics fairly well, but would like to extend their knowledge of the more advanced functions of Excel to become more productive and make the most of Excel 2013. The course is designed for students would want to learn how sort and filter data, import and export data sets, and analyze data using the rich features provided in Excel. It will impart the necessary skills to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Certified Application Specialist exam in Microsoft® Office Excel® 2013, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data
We have the best courses for you!
Enroll today and learn something new.Syllabus
Module 1
USING CUSTOM & CONDITIONAL FORMATS:
- Reasons for Using Custom Format
- Understanding Conditional Formatting
- Managing the Conditional Format Rules
- Changing the Conditional Formatting Rules
- Locating Cells with Conditional Formatting
- Working with Conditional Formatting
USING RANGE NAMES:
- Assigning Names to Groups of Cells
- Managing Named Range
- Using Names in Formulas
Module 2
USING FORMULAS & FUNCTIONS:
- Understanding Formulas & Functions
- Quick Way to Insert a Function
- Viewing the Formulas (and not the results)
- How to Delete Values and not Formulas
- Create a Relative & Absolute Reference
- Working with Logic Functions
- Using SUMIF () and COUNTIF ():
- Adding and counting only the Cells you Specify
- Working with Text Functions
- Using More Text Function
- Working with Date and Time Functions
- Using More Text Function
- Working with Date and Time Functions
- Working with Lookup Functions
- Understanding VLOOKUP () Function
MANAGING, SORTING & FILTERING TABLES:
- Create and Modify Tables
- Sorting and Filtering Data in a Table
- Getting Summary Information in a Table
- Calculate Total Row in a Table
- Display Special Formatting for First or Last Column
- Outline a List of Data
- Validating Data during Entry
- Working with Database Functions
- How to Use Advance Filters in Excel
Module 3
WORKING WITH CHARTS:
- Summarizing Data Visually Using Charts
- Creating a Chart Quickly
- Changing the Chart Type
- Customizing Chart Data
- Altering Chart Options
- Changing the Chart Body
- Show or Hide Chart Gridlines
- Creating a Pie Chart
- Saving the Chart as a Template
- Creating Combination Charts
WORKING WITH PIVOT TABLES:
- What is a Pivot Table
- Anatomy of a Pivot Table
- How does a Pivot Table Works
- Create a Basic Pivot Table Report
- Rearranging a Pivot Table Report
- Customizing a Pivot Table
- Changing Summary Calculations
- Adding and Removing Subtotals
- Adding and Removing Subtotals
- Sorting in a Pivot Table
- Filtering in a Pivot Table
- Create Report Filter Pages
- Using Slicers in Pivot Table
- Working with Pivot Chart
Module 4
WORKING WITH SHARED WORKBOOKS:
- Working in a Group Environment
- Sharing Workbooks in Excel
- Commenting in Cells
- Tracking Changes in Workbooks
- Accepting or Rejecting Changes
- Keeping a Backup of your Changes
WORKING WITH MULTIPLE WORKBOOKS:
- Linking to Other Workbook
- Consolidating Multiple Sets of Data
- Consolidate Multiple Worksheets
Module 5
PROTECTING YOUR WORKSHEET AND WORKBOOK:
- Protecting Your Worksheet
- Protecting Your Formulas
- Protecting Your Workbook
- Save Your Workbook with Password
- Encrypting your Workbook
WORKING WITH EXCEL MACROS:
- Recording & Testing a Macro
- Using the Developer Tab
- Create a Macro
- Relative and Absolute Recording
- Testing the Macro
- Running and Deleting Macros
- Using a Shortcut key
- Placing a Macro on the Quick Access Toolbar
- A Quick Introduction to Macro Programming in Excel
Career Opportunities
- Operations Analyst- Online
- Business Analyst
- Business Analyst
- Associate Analyst
- Excel Consultant
- Financial Analyst
- Business Analyst
Entry Qualification
- Candidates will be admitted on the basis of interviews and / or group discussions.
- 20% of the total seats will be reserved for SC, ST and OBC candidates.If the reserved seats are not filled within the specified period, the vacant seats will be offered to the general candidates.
Course Features
Instructor
Industry Experienced Trainer
Rating
4.9 (Google Review)
Study Mode
Offline & Online
Duration
2 month
Language
English, Bengali, Hindi
100% Job Assistance
Yes
Internship
Free & Paid
Course Price
Click to Know
Our Students Testimonials
MD Kashid Hossain
I am MD Kasid Hossain. I am a student of Oxford Global Academy of Excellence, Kolkata. Here I am doing Spoken English class. Oxford Global Academy of Excellence is a very advantage platform by spoken English, computer course and more. There sirs, madams are very Helpful. All time they Support and guide us. I always enjoy my classes.
