UrbanPro
true

Micorsoft Excel Advance Module

LIVE
10 Hours

Course offered by Anish Babu

0 review

The course covers topic for advance Excel. and Cost is ₹ 500 per Hour

Topics Covered

ADVANCE MICROSOFT EXCEL: 35 to 40 Hours

a) Introduction Formula and Function Tips and Shortcuts Reviewing function basics Absolute, Relative and mixed references

b) IF and Related Functions An Introduction to Different Operators (Arithmetic, Relational and Logical) Exploring IF logical tests and using relational operators Creating and expanding the use of nested IF statements Using the AND, OR, and NOT functions with IF to create compound logical tests

c) Lookup and Reference Function VLOOKUP and HLOOKUP – A Short Introduction Finding approximate matches with VLOOKUP Finding exact matches with VLOOKUP Nesting LOOKUP functions Finding table-like information within a function with CHOOSE Locating data with MATCH Retrieving information by location with INDEX Using MATCH and INDEX together

d) Power Functions & Statistical Functions COUNTIF, SUMIF, and AVERAGEIF COUNTIFS, SUMIFS, and AVERAGEIFS Finding the middle value with MEDIAN Ranking data without sorting Finding the magnitude data with LARGE and SMALL Tabulating blank cells with COUNTBLANK

e) Date Functions Identifying the day, month, year in a date Identifying the day of the week with WEEKDAY Counting working days with NETWORKDAYS Determining a completion date with WORKDAY Tabulating date time differences with DATEDIF

f) Math Functions Working with rounding functions Finding the remainder with MOD and using MOD with conditional formatting Building random number generators with RAND and RANDBETWEEN Converting a value between measurement systems with CONVERT

g) Text Functions Determining the Length of a Text using LEN Locating and extracting data with FIND and MID Extracting specific data with LEFT and RIGHT Removing excess spaces with TRIM Using CONCATENATE with functions Adjusting case within cells with PROPER, UPPER, and LOWER Adjusting character content with REPLACE and SUBSTITUTE Reviewing additional text functions

h) Financial Functions Calculating payments with PMT Finding future values with FV Determining total amount of future payments with PV

i) Information Functions Working with the IS information functions Using error-checking functions ISERR, ISERROR, IFERROR

j) Reference Functions Getting data from remote cells with OFFSET Returning references with INDIRECT Finding the nth LARGEST and SMALLEST Date using LARGE and SMALL & IF

k) Analyzing Data Using auditing to diagram Using evaluation in Excel Working with Goal Seek (What-if Analysis) Data Tables, Scenarios (What-if Analysis)

l) Data Validation in Depth Controlling the Limits of Numeric Data Setting Up Drop-Down Lists (Pick Lists) Date Controls & Time Controls Text Length Controls & Specialized Custom Formula Controls.

 

EXPERTISE IN MICROSOFT EXCEL: 25 to 40 Hours

a) Financial Functions in Depth

1. Analyzing Loans, Payments, and Interest (PPMT and IPMT, CUMPRINC and CUMIPMT, ISPMT, EFFECT and NOMINAL, ACCRINT and ACCRINTM, NPER)

2. Calculating Depreciation (SLN, DB, DDB, SYD, VDB, AMORDEGRC, AMORLINC)

3. Determining Values and Rates of Return (FV, FVSCHEDULE, PV, NPV, XNPV, IRR, XIRR, MIRR, DISC)

4. Calculating Bond Coupon Dates and Security Durations (COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, DURATION, MDURATION)

5. Calculating Security Prices and Yields (DOLLARDE and DOLLARFR, INTRATE, RECEIVED, PRICE, PRICEDISC, PRICEMAT, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT)

6. Calculating Prices and Yields of Securities with Odd Periods (ODDFPRICE, ODDFYIELD, ODDLPRICE, ODDLYIELD)

 

b) Pivot Tables in Depth Applying Conditional Formatting to PivotTables Printing PivotTables and Pivot Charts Manipulating PivotTables Using Macros Getting Started with PowerPivot Working with DAX Expressions

 

c) MACROS & VBA Running a Macro (Execute, Play Back, Etc.) Using Visual Basic for Applications (VBA) Recording a Macro in Stages Using database functions like DSUM, DAVERAGE, and DMAX Creating Non-Recordable VBA Code Macro Project- Converting a Mailing List into a Database List The Personal Macro Workbook

 

d) Setting up a Database in Excel Introduction Database Design Concerns Tables Controlling the Creation of New Data

 

e) Running with VBA in Excel Introducing Visual Basic for Applications (VBA) Defining Variables, Constants, and Calculations Adding Logic to Your VBA Code Debugging Your VBA Code Managing Workbook Elements and Data in VBA Adding Advanced Elements to Your Workbook Using Excel Events in Your VBA Code Putting It All Together

Who should attend

Anyone who has a passion to learn Excel and know the basics.

Pre-requisites

Basic Computer Knowledge, Basic Microsoft Excel Skill

What you need to bring

Notepad (if required)"

Key Takeaways

Good Advance Working Knowledge in Excel.

About the Trainer

Anish Babu picture

Avg Rating

0 Reviews

2 Students

3 Courses

Anish Babu

MBA, B.Com, Diploma in Web Application & Programming

16 Years of Experience

Above 10 Years of Experience in Training Different software's such a Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Access, Adobe Photoshop, Adobe Dreamweaver, Adobe Flash, Tally, etc. for Individual, co-operate Level and Indian Navy.

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Micorsoft Excel Advance Module by Anish Babu

Anish Babu picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Micorsoft Excel Advance Module by Anish Babu

Anish Babu picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more