Description

Microsoft Excel is an essential application in today’s work environment. Microsoft Excel is a tool for the creation of spreadsheets and graphs, for performing calculations, data analysis and much more. . 

Microsoft Excel is useful for the company’s financial administration and monitoring and can also be useful in sales, expense monitoring, creation of lists, converting data into visuals (graphs) etc.

This course is the first of a series of two courses and covers the basic features of the application.

Seminar Scope

Upon completion the participants will be able to:

• Create tables
• Format tables
• Insert and format columns and rows
• Create simple formulae and functions
• Insert Graphics and Graphs
• Print

Best Suitable for

This course is for beginners wishing to gain the basic knowledge in Excel

More Information

Content:

Unit1: Creating a Formula

• The Syntax of a formula

• Making Calculations

• Working with Relative and Absolute References

• Creating a table with calculations (semi-absolute references)

Unit2: Working with Statistical and Mathematical Functions

• Calculating Sum, Average, Min and Maximum

• Counting Blank, Number and text cells using conditions

• Sum a set of numbers based on conditions

• Rounding Numbers to a specified number of digits

Unit3: Working with Dates

• Calculating Deadlines

• Calculating days and working days

• Working with Years, Months and Days