HRDF Course -Advanced Excel Essential Training

Start mastering Excel, the world's most popular and powerful spreadsheet program. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools.
Topics include:

• Creating Pivot Tables
• Creating formulas and functions
• Finding and replacing data
• Using power functions such as IF and VLOOKUP
• Password-protecting worksheets and workbooks
• Analyzing data with Goal Seek and Solver
• Creating and running macros

Module 1 Pivot Table

• Creating Pivot Tables
• Sorting and Filtering Pivot Tables 
• Formatting Pivot Tables
• Creating PivotCharts

Module 2: Functions & Formulas

• Formula Shortcut Keys
• If and Related Functions
• Lookup and Reference Functions
• Power Functions
• Statistical Functions
• Math Functions
• Date and Time Functions
• Array Functions
• Text Functions

Module 3: Advanced Charts

• Creating Basic Charts
• Style Charts with Design Tabs
• Fine Tune Chart Elements
• Format Tab

Module 4 Data Analysis

• Installing Data Analysis Tool
• Goal Seeker & Solver
• Histogram
• Linear Regression
• Testing a Hypothesis
• Covariance and Correlation
• Bayesian Analysis

Dr. Zahra Nazemi has PhD in mathematical statistics from Universiti Putra Malaysia. Her research interests are applied statistics, medical statistics, Bayesian statistics, statistical inference and Software R. She has worked as the lecturer in different universities more than 4 years. She also consulted and worked on assignments for parametric and non-parametric analysis, univariate and multivariate regression analysis in various areas such as medical, economics and psychology. Her other skills are knowledge of research methodology, extensive experience with SPSS, AMOS, R and MINITAB and writing and presenting reports. Moreover, she conducted special training program in mathematical programming including optimization, advanced multivariate data analysis, and simulation techniques