Microsoft Advanced Excel 2013 Training

Posted Apr 29      Ikeja, Lagos State, Nigeria
727 views
Post Ad like this for FREE
Services Rendering at Client Location
No

Ad details

Enrol for Microsoft Advanced Excel 2013 Training.
Upgrade your Analytical Skills. Work Smart! Increase your productivity.
Training Curriculum:
Unit 1:Advanced functions and formulas
I.Logical functions –IF, NESTED IF, AND, OR
II.Count and Sum Functions -COUNT | COUNTIF | COUNTIFS | SUM | SUMIF | SUMIFS
III.Financial functions –PMT, RATE, NPER, PV, FV
IV.Text functions –LEFT, RIGHT, LEN, FIND, SUBSTITUTE, CONCATENATE, PROPER
V.Date and time functions –YEAR, MONTH, DAY | DATE FUNCTION | CURRENT DATE & TIME | HOUR, MIN & SEC | TIME FUNCTION
VI.Array formulas
A. WITHOUT ARRAY FORMULA
B. WITH ARRAY FORMULA
Unit 2: Lookups and Reference Functions
I.VLOOKUP
A.Advanced Scenario Examples: Create An Invoice –Using If Function, VLOOKUP & Data Validation
B. Invoice, Part 1: Free Shipping
C. Invoice, Part 2: Using VLOOKUP
D. Invoice, Part 3: Fix Broken VLOOKUP
E. Invoice, Part 4: More Shipping Options
F. Invoice, Part 5: Data Validation
I.HLOOKUP
II.MATCH
III.INDEX
IV.CHOOSE
Unit 3: Data Validation
I.Data Validation Rule
II.Input Message
III.Error Alert
IV.Data Validation Result
Unit 4:What-If Analysis
I.Create different Scenarios
II.Scenario Summary
III.Goal Seek
IV.Data Tables
A. One Variable Data Table
B. Two Variable Data Table
Unit 5:PivotTables
I.Working with PivotTables
II.Modifying PivotTable data
III.Formatting PivotTables
IV.Using PivotCharts
Unit 6:Macros
I. Create a Macro
A. Developer Tab
B. Command Button
C. Assign a Macro
D. Visual Basic Editor
II. Recording and Running Macros
III. Changing the Security Level
Unit 7:Managing Data
I.Transposing Data from Rows to Columns
II.Using Text to Columns feature
III.Checking for Duplicates
IV.Consolidating Data
080 xxx

Similar adverts

Show more ads >>>
Contact for price
Last seen 3 weeks ago
Lagos State, Ifako-Ijaye, Region 35 Aganga Williams Street, Haruna Bus Stop, Off College Road, Ogba, Lagos, Nigeria
080 xxx
08067564943
Tell seller that you found ad on Jiji.ng
Please read safety tips
  • Do not pay in advance even for the delivery.
  • Please, check the background of the company!
  • DO NOT PAY for ANY certificates, form applications, etc.