Microsoft Excel Intermediate
Microsoft Excel Intermediate Training
Level: Intermediate, Age 18+, Course Fee: 6,000 Taka
Duration: 3 Days (12 Hours)
Entry requirements: You need to have basic understanding of Excel. This course is suitable for people who are interested to learn more advanced features of excel and how to use them for everyday work.
Details:
The following topics will be covered in the course:
Recap of basic concepts
Working with cells:
Absolute and relative cell references
Naming cells and ranges
Referring to named cells and ranges in formulae
Editing named cells and ranges
Linking cells, spreadsheets and workbooks together
Graphs and Charts:
Creating and formatting charts
Adding trend lines to the chart
Customising a chart
Customising chart data and data axis
Adding Sparklines to view trends in the data
Conditional Statements:
If statements to assist decision making
If statements and calculations
Analysing data with conditional formatting features
Lookup functions:
Using vlookup & hlookup statements to retrieve data
Editing lookups and ensuring accuracy in returned data
Using multiple lookup function in a formula
Data Validation:
Setting up data validation to ensure integrity of the data
Creating data Lists
Editing Lists
Sorting and Filtering:
Sorting data numerically and alphabetically
Filtering data for range and precision analysis
Using various reset sort features
Security:
Attaching security to a spreadsheet
Cell protection
Spreadsheet protection
Setting up password
Facilitator(s):
Abir Mallick, FCoT (Lon), PGDip(Lon), PGCE(Lon), MCA(B,lore), Adobe Certified Educator, Chartered London Teacher. With over fifteen years of training and teaching experience in different countries; Abir (http://www.linkedin.com/in/abirmallick) has trained participants of all ages from primary school to University
level. He is a Chartered London Teacher award winner for excellence in teaching and learning. He has been working as a trainer for various professional courses at London, India and Bangladesh. He runs a successful consultancy company www.subjectsupport.com providing cutting edge professional development courses in London.
Mr. M. Haq Sagar, M.Sc Comp (JU), MBA (SEU), has many years of experience in teaching various computing and IT courses to participants of all ages. He works as an IT trainer for office applications, graphics design, website design, computer hardware and networking at different institutions.