About 82% of jobs require Excel skills and/or experience with productivity software.
Where is Excel mostly used?
Excel is most commonly used in business settings. For example, it is used in business analysis, human resource management, operations management and performance reporting. Excel uses a large collection of cells formatted to organize and manipulate data and solve mathematical functions.
Date(s):
15 - 18 April 2024 (Week days)
(Mon - Wed)18:00 - 20:00
Venue:
NamCloud Training Center
(Windhoek West, Puccini Street)
Cost:
N$ 800
Included:
Training Manual, Stationary and Certificate
Pre-Requirements
Be able to work on a computer (Navigate)
Starting Excel, Cell references, Aligning, Resizing cells, Saving workbooks,Inserting rows/columns
Entering values (dates, numbers. currencies), Working with Ranges, Renaming Sheets, Manipulating Sheets (move/copy),
Formulas - Operators, Relative / Absolute referencing, Copying formulas, Functions-Max,Min,Sum,Average,Count,CountA,IF,
Formatting tables, Inserting Pics, manipulating graphics, applying table themes
Inserting Charts, Manipulating Charts
Setup Printing preferences, Prining
Date(s):
06 - 07 April (Weekend)
(Sat & Sun)10:00 - 14:00
Venue:
NamCloud Training Center
(Windhoek West, Puccini Street)
Cost:
N$ 1200
Included:
Training Manual, Stationary and Certificate
Pre-Requirements
Complete or be comfortable utilising the topics covered in the beginners/intermediate course
DATE FUNCTIONS
• TODAY / DAY
• MONTH / YEAR
• RANK
GENERIC FUNCTIONS
• IF
• SUMIF / IFS
• ROUNDUP/DOWN
• COUNT / A/ IF
• COUNTIF
• Nested Functions
TEXT FUNCTIONS
• PROPER
• UPPER
• LOWER
• CONCATENATE
• Conditional Formatting
FINANCIAL FUNCTIONS
• FV
• NPV
• PMT
• PV
• RATE
DATA FUNCTIONS
• HLOOKUP
• VLOOKUP
• DATA RULES
• AND
• OR
GENERIC TOOLS
• PIVOT TABLES
• PIVOT CHARTS
• AUDITING TOOLS
Payments can be made at our office in Cash /EasyWallet/Ewallet/EFT. We can also generate Invoices to your institution if needed.
05 Sept
(10:00 - 16:00)
(264) 61225355
(264) 81 288 248 3