"Microsoft Advance Excel" is no longer available

No Reviews Yet

Nerul, Mumbai

Course ID: 23396

Nerul, Mumbai

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

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

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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