ADVANCE EXCEL TRAINING COURSE

Key Features

  • Class Room Training
  • High Quality Training
  • Ample Practical Sessions
  • Industry based examples
  • Course Completion Certificate
  • Course Design as per MOS(Microsoft Office Specialist)

What is the course all about?

Now a days, many jobs require advanced Excel skills. That said, there are a number of functions that, in practice, require some skill in order to solve complex problems. Part of the challenge for you is knowing when and how you can apply these and how to design them for your specific purpose. Without them, Excel is just a data keeping tool. But by using formulas, you can crunch data, analyze it and get answers to most complex questions. Apart from knowing the formulas, advanced Excel users know how to debug them, audit them and how to use which formula for which occasion.


Advance Excel Course Content

Introduction to MS Excel and Understanding Basic Working with it,
Introduction to MS Excel,
Quick Review on MS Excel Options,
Ribbon, Worksheets and Toolbar,
Copy, Cut, Paste,
Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets,
Protecting & Unprotected Cells, Rows, Columns and Sheets with or without Password,
Paste Special Options,
Page Layout, Themes, Background and Printer Properties,
Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets.
Create a Criteria Range,
Use a Criteria Range,
Show All Records,
Use Comparison
Criteria,
Use an Advanced And Condition,
Use an Advanced Or Condition,
Copy Filtered Records,
Use Database Functions,
Find Unique Records,
Remove Duplicates from a Table
Insert chart,
Add, Remove and Format Gridlines,
Format an Axis,
Change the Axis Scale,
Format the Data Series,
Add Data – Different Worksheets,
Use a Secondary Axis,
Change Data Series Chart Types,
Create User-defined Charts, Customize, etc.
Use the Scenario Manager,
Create, Display and Edit a Scenario,
Create a Scenario Summary Report,
Use Goal Seek,
Use Data Table.
Create a PivotTable Report,
Add PivotTable Report Fields,
Select a Report Filter Field Item,
Refresh a PivotTable Report,
Change the Summary Function,
Add New Fields to a PivotTable Report,
Move PivotTable Report Fields,
Use Expand and Collapse Buttons,
Hide/Unhide PivotTable Report Items,
Delete PivotTable Report Fields,
Create Report Filter Pages,
Inserting & Using Slicers,
Format a PivotTable Report,
Create a PivotChart Report,
Publish PivotTable Reports to the Web.
Learn to sort data in Excel by a single column or by multiple columns,
Learn about creating named ranges, and the benefits of doing so.,
Validation,
Conditional Formatting,
Subtotals,
Use Of Cell Referencing.
VLOOKUP,
HLOOKUP,
AND,
IF,
NOT,
OR,
CHOOSE,
INDEX,
INDIRECT,
MATCH,
TRANSPOSE.
CHAR,
CODE,
CONCATENATE,
EXACT,
FIND,
DOLLAR,
LEFT,
RIGHT,
MID,
LEN,
LOWER,
UPPER,
PROPER,
REPLACE,
REPT,
TRIM.
DATE,
TODAY,
WEEKDAY,
WEEKNUM,
DAYS360,
MONTH,
DAY,
YEAR,
TIME,
NOW,
MINUTE,
HOUR,
SECOND.
ABS,
CEILING,
COMBIN,
COUNTIF,
EVEN,
FACT,
FLOOR,
GCD,
INT,
LCM,
MMULT,
MOD,
ODD,
PI,
POWER,
PRODUCT,
QUOTIENT,
RAND,
ROMAN,
ROUND,
ROUNDDOWN,
ROUNDUP,
SIGN,
SUM,
SUMIF,
SUMPRODUCT,
SUMQ,
TRUNC.
AVERAGE,
CORREL,
COUNT,
COUNTA,
FORECAST,
FREQUENCY,
LARGE,
MAX,
MEDIAN,
MIN,
MODE,
QUARTILE,
RANK,
SMALL,
TREND.
FV,
PMT,
PV,
NPER,
RATE,
DB,
SLN.
DAVERAGE,
DCOUNT,
DCOUNTA,
DMAX,
DMIN,
DSUM.
CELL,
ERROR.TYPE,
INFO,
ISBLANK,
ISERR,
ISERROR,
ISEVEN,
ISLOGICAL,
ISNA,
ISNONTEXT,
ISNUMBER,
ISODD,
ISTEXT,
N.
Display the Formula Auditing Toolbar,
Display/Remove Dependent and Precedent Arrows,
Remove Tracer Arrows,
Use Auditing Tools Buttons.
Recording new Macro,
Use of Referencing,
Applying Macro.

Search

Request a Call Back

Your Name (required)

Your Phone Number (required)

Your Email (required)

Select Course

What Our Students say..

Good Quality of Teaching

I like this class because in this class good quality of teaching, mam takes more program practice as well as give me knowledge about Java & PHP and Updated knowledge also.

Monika N. Taklakar

I am Thankful to Mam

I like Java very much because first it was very difficult to understand this language but guidance of Bagul Infotech it become so much easier.. Hence I am thankful to mam..

Kirti K. Sasane.

My Class is Awesome

My class is awesome.. Teaching is very simple & nice… Mam is very helpful n she try to solve all the problems & queries of all students… Sir is very simple so I love my class, sir and mam also...

Rutuja Mane.

Great Pleasure to Join Bagul Infotech

It is my great pleasure to join this class, Sir and Mam are too good. Mam not only giving educational knowledge, but also given good career guidance, and general knowledge, which will definitely help me in future, life. I am very thankful to Sir and Mam that such given knowledge and information.

Santosh Kadam

key to Success

The key to success is through Bagul Infotech. I have very well realized it and would like others also to appreciate it by joining the Bagul Infotech.

Yogesh Bhandare.

Place Where Learning is Joy

Bagul Infotech is a place where learning is joy. Here, teaching is a piece of art. And we students interact with sir and madam very humoursly and learn with great efficiency.

Rucha Kamble