Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Microsoft Advance Excel

No Reviews Yet

Nerul, Mumbai

Course ID: 23396

Nerul, Mumbai

Students Interested 0 (Seats Left 0)

₹ 100

No Reviews Yet

Date and Time

Not decided yet.

MOHSINKHAN KAZI

MECHANICAL ENGINEER

About MOHSINKHAN KAZI

WORKED WITH VARIOUS MANUFACTURING COMPANIES HAVING A WIDE 05 YEARS OF EXPERIENCE ON EXCEL
No reviews currently

About the Course

Microsoft excel with detail formula and macros

Topics Covered

• Automating Excel
• Customising Excel (Toolbars, menus and views, Workspaces )
• Logical functions (if, iferror, and, or, not)
• Mathematical functions (round, roundup, rounddown, floor, celing, mround, trunk, even, odd, int, abs, rand, randbetween)
• Date Function (now(), today(), day, month, year, date, datevalue, weekday, networkdays, workday, eomonth, edate, hour, minute, second, weeknum, yearfrac)

• Text Function (clean, concatenate, exact, find, left, right, mid, find, search, replace, substitute, upper, lower, proper, trim, rept, text, value, fixed)

• Financial Function (Pmt, Ppmt, rate)

• Information (cell, info, isblank, iserror, iserr, iseven, isodd, istext, isnumber, n, t)

• Working with databases

• Special features -The use of PivotTable Dynamic Views to summarize and analyze data
• Document distribution- Security and worksheet protection
• Database Functions (daverage, dcount, dcounta, dget, dmax, dmin, dproduct, dsum)
• Extended technologies(Goal Seek, Table, sumif, countif, vlookup, lookup, index, match, indirect, row, column, small, large, frequency, rank, address, choose, offset, transpose, two dimensional relationships, three dimensional relationships, Consolidate, Dynamic Consolidation, Group, Outline)
• Working with arrays

Who should attend

This training course is designed for advance users

Pre-requisites

In Advanced Excel, we try to teach Automation In Excel i.e. Dynamic Report/ Dash Boards using Excel functions (not macro). To achieve this target participants should have some knowledge of functions like :
Vlookup, Sumif, Pivot Table, Addressing (i.e. using $ in formula like $a$1, a$1, $a1, a1. ), Basic Conditional formats, Basic Data Validation, IF function, Using and / or function in IF

What you need to bring

Laptop

Key Takeaways

Excel Work

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

₹ 100

Post your requirement and let us connect you with best possible matches for Microsoft Excel Training classes Post your requirement now
₹ 100 Enquire