ted-learning-logo

Functions and Formulas in Microsoft Excel

Formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

Free

2 days
All levels
0 lessons
0 quizzes
0 students

Course Info

They are what make a spreadsheet a spreadsheet. This one-of-a-kind course delivers all the tips and techniques one needs to maximize one of the most powerful spreadsheet tools: formulas. The more you know about formulas, the better your spreadsheets will be. Hence the course is to aim to get the most out of worksheet formulas.

What Will I Learn From This Course?

Learn how to think like Excel, and write powerful and dynamic formulas from scratch

Automate, streamline, and completely revolutionize your workflow with Excel

Master unique tips, tools and case studies that you won't find in any other course, guaranteed

Explore fun, interactive, and highly effective lessons from a best-selling Excel instructor

Build formulas to analyse dates, text fields, values and arrays

Methodology

This course is Instructor led group-paced, hands-on classroom-training with activities. Manuals are provided for each student for after-class reference.

Pre-requisites

Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training and to expand their analytics skill set, work more efficiently with data, and take their career to a new level.

Course Outline for This Programme

a. SLN
b. SYD
c. FV
d. PMT

a. IF
b. NESTED IF
c. AND
d. OR

a. CONCATENATE
b. LEFT
c. MID
d. RIGHT
e. LOWER
f. PROPER
g. UPPER

a. TODAY
b. NOW
c. DATEDIF
d. DAYS360
e. YEAR
f. YEARFRAC
g. WEEKDAY
h. WEEKNUMB

a. VLOOKUP
b. HLOOKUP
c. INDEX & MATCH

a. POWER
b. PRODUCT
c. CEILING
d. FLOOR
e. ROUND
f. ROUNDDOWN
g. ROUNDUP
h. SUBTOTAL
i. SUMIF

a. COUNT
b. COUNTA
c. COUNTIF
d. COUNTBLANK

Curriculum is empty
Julian

Academic Qualifications
  • Diploma in Accountancy
  • ACCA (Association of Chartered Certified Accountants), UK

Professional Certifications
  • Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer
  • Microsoft Certified Trainer (MCT)

Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications

whatsapp-icons
whatsapp-icons