AAR-CODES Institute

98
88
39
32
46

Advance Excel Course

What you’ll learn

  • How to become Professional at Data Entry as a complete beginner?
  • How to make PDF and image conversion job example?
  • LIVE DEMO of Data Entry and Web Research
  • Become skilled at your work and Build your portfolio
  • Gain a better understanding of fundamentals of data entry industry
  • How to use MS Excel advance
  • How to create and modify worksheet formulas
  • Learn how to classify data
  • Learn how to protect data
  • Learn how to manage workbooks and their respective properties
  • Gain sufficient amount of knowledge and skills to work as a professional within IT industry
  • Learn how to use statistical packages in Data Entry
    MS Excel
  • Cell properties,Autofill value and text.,Autofill date,Operators based Equation,Official Reports,Operators based Equation,Math Function,Text Function - Upper, Lower, Proper, Trim,Text Function - Right, Left,Text Function - Find and task,Text Function – Concatenate,Text Function – Replace,Text Function - Replace task,Text Function - Len, Rept, Excat, Search,Text to column,Hide Formulas and unlocked Cell,Hyperlink,Protect File with password,If Function - Logical Test,If Function - with Equation,If Function - Nested If,AND , OR Function,AND, OR, IF Nested,Pivot Table – Intro,Pivot Table – chart,Goal seek,Scenario manager,PMT function - EMI calculator,Chart Preperation,Data Validation,Vlookup Function,Hlookup,Macro Recording ,Conditional Formatting,Filters,Hyperlink,Print area,Watch Window,Define name,Subtotal





Time

Day

Time

Hour

Time

Minute

Second

Seconds

USE CODE:AAR123