loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Micorsoft Excel Advance Module

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Anish

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

Micorsoft Excel Advance Module

Rajagiri, Kochi

400

No Reviews Yet
1 Interested

About the Course


The course covers topic for advance Excel. and Cost is Rs.400 Per Hour

Topics Covered

Microsoft Excel 2010 & 2016 – Topics Covered
LEVEL ONE - BASIC MICROSOFT EXCEL: 15 - 20 Hours
a) Introduction
b) Worksheet basics
Creating, editing, saving spreadsheets
Customizing the Quick Access toolbar
Customizing the Ribbon bar
Setting Excel options
c) Excel Formula Basics
Understanding formulas and functions and difference between both
Adding numbers – Manually, Sum, Auto sum
Working with numbers in columns
Preventing errors using absolute references
Naming and using cell ranges
d) Formatting Data
Working with time and dates – basics formatting
Applying fonts, background colors, and borders
Adjusting columns, rows, and text
Using conditional formatting (basic & custom)
Adding pictures and shapes
Inserting SmartArt
Themes in excel
Using templates
e) Printing Preparation
Making the pieces fit
Inserting headers and footers
Printing and PDFs
f) Excel Projects & Collaborating Data
Finding and replacing data
Freezing panes
Repeating row and column titles
Hiding or grouping rows and columns
Importing and exporting data in Excel
Setting workbook permissions
Inserting and editing comments
Splitting cell data into multiple cells
Using tables to sort and filter data
g) Charts
Sparklines
Creating a column chart
Modifying a column chart
Creating and modifying a pie chart
Placing Excel charts into other Office applications
h) Advanced Analysis with PivotTables
Introduction
Creating a basic PivotTable
Modifying a PivotTable
Creating and modifying a PivotChart
i) Creating and Using Macros
Understanding macros
Recording and using a simple macro
Editing a macro


LEVEL TWO - 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


LEVEL THREE – 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

Pre-requisites

Basic Computer Knowledge,
Basic excel skills(for advance course)

What you need to bring

Notepad (if required)"

Key Takeaways

Good Advance Working Knowledge in Excel.
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Anish Babu picture

Anish Babu

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


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.
Seats Left-

Students Interested 1

Course Id: 23211