Microsoft Advanced Excel 2013 Training

For sale by REINAGOLD TECHNOLOGIES LIMITED - VERIFIED SELLER VERIFIED23 Jan 4:45 pmIkeja, Lagos

25,000

Enrol for Microsoft Advanced Excel 2013 Training.
Upgrade your Analytical Skills. Work Smart! Increase your productivity.
Training Curriculum:
Unit 1: Working with data
I. Sorting data
II. Filtering data
III. Groups and subtotals
IV. Sparklines
Unit 2: Advanced functions and formulas

I. Logical functions – IF, AND, OR
II. Financial functions – PMT, RATE, NPER, PV, FV
III. Text functions – LEFT, RIGHT, LEN, FIND, SUBSTITUTE, CONCATENATE, PROPER
IV. Date and time functions – YEAR, MONTH, DAY | DATE FUNCTION | CURRENT DATE & TIME | HOUR, MIN & SEC | TIME FUNCTION
V. Array formulas

Unit 3: Lookups and Reference Functions
I. VLOOKUP
II. HLOOKUP
III. MATCH
IV. INDEX
V. CHOOSE

Unit 4: Data Validation
I. Data Validation Rule
II. Input Message
III. Error Alert
IV. Data Validation Result

Unit 5: What-If Analysis
I. Create different Scenarios
II. Scenerio Summary
III. Goal Seek
IV. Data Tables

Unit 6: PivotTables
I. Working with PivotTables
II. Modifying PivotTable data
III. Formatting PivotTables
IV. Using PivotCharts

Unit 7: Macros
I. Running and recording a macro
II. Changing the security level

Unit 8: Managing Data
I. Transposing Data from Rows to Columns
II. Using Text to Columns feature
III. Checking for Duplicates
IV. Consolidating Data

I do not want to be contacted by telemarketers.


Tuition type:
Coaching / Training
Report this ad

Contact

  • 08023601081
  • 08067564943

 

Stay safe!

  • Always meet the seller in person
  • Don't pay for anything until you have seen what you are getting
  • Don't send or wire money to anyone you don't know
  • Do not make partial payments for goods before delivery.

Watch out for:

  • Unrealistic prices
  • Extra fees
  • Requests for advance payments
  • Requests for personal information

More on staying safe


Share this ad

Similar ads