Advanced Microsoft Excel
Overview
Learn the Tools & Techniques you can apply in MS Excel to Analyze and Manage data to ensure that your work is well organized and helps you to calculate and visualize quantitative data thus helping you make important statistical and financial decisions at your workplace.
Learning outcomes include
- Apply advanced formatting options, such as conditional formatting and customized number formatting, and handle worksheets.
- Use functions such as those associated with logical, statistical, financial, and mathematical operations.
- Create charts and apply advanced chart formatting features.
- Work with tables and lists to analyze, filter, and sort data. Create and use scenarios.
- Collaborate on and review spreadsheets. Apply spreadsheet security features.
Duration: 20 Hours
Entry Requirement: Basic knowledge of MS- Office and MS–Excel.
Certificate: Certificate of participation in Advanced Microsoft Excel
Software Training: – MS Excel 2016
Course Location: Edulink International College Nairobi
Please Note:-
- Study Materials: Students will get a printable softcopy of the study materials developed by ICDL. Along with the study materials they will also get revision papers to assist in the preparation for exams.
- Exam Retakes: All of the above fees are inclusive of the ICDL registration and first exam attempt. A cost will be incurred for resits of the exams as required.
- Award of Certifications: After the completion/ passing of each exam module, the candidate will get certification from ICDL. These certificates will include a list of all the module exams passed by candidates to date.
- Faculty Qualifications: All of our teaching staff will attend special training organised by ICDL and will be certified by ICDL as a trainer.
Apply now: http://edulink.ac.ke/apply-now
Course Content Details:-
Sharing and Maintaining Workbook
- Explain the new features of Microsoft Excel 2016
- Explain customization of the Ribbon and the Quick Access Toolbar
- Explain the procedure to add data by using FlashFill, AutoFill, and AutoComplete
- Explain proofing and management of Add-ins
- Describe built-in and custom templates in Excel
- Describe worksheet protection and locking/unlocking of cells
- Explain the protection, finalization, and encryption of a workbook
- Explain the concept of shared workbooks
- Explain the procedure for change tracking in a shared workbook
- Explain the process of recovering unsaved versions of a file
Formulas and Functions
- Trace formula precedents and dependents
- Use the data validation tool and check for errors in a file
- Implement iterative calculations
- Use single-cell and multi-cell array formula
- Use SUMIFS(), COUNTIFS(), and basic counting functions
- Describe the Quick Analysis Tool for Data Analysis
- Describe Data consolidation
- Describe mathematical, trigonometry, statistical, and financial functions, Date, Time, Data Type, and Conversion Functions
- Describe Text, Logical, and LookUp functions
- Conditional Formatting
Advanced Chart Features
- Explain the importance of chart and the different types of chart
- Explain Recommended Charts
- Explain modification of chart elements, chart area, plot area, and chart axes
- Describe formatting of chart title, legend, and gridlines
- Explain the Trend line and data series
- Explain dual axes and chart templates
- Describe combination chart, error bars, and data tables
Presenting Data Visually
- Explain conditional formatting
- Explain Sparklines and list the steps to create it
- Describe the importance of Pivot Table and its various features
- Describe the procedure to create recommended PivotTables
- Explain the concept of PivotCharts and list the steps to customize it
- Explain slicers and list the steps to create it
- Describe the procedure to use Power View
Data Analysis
- Explain Analysis ToolPak
- Explain single-factor and two-factor tools with and without replication
- Describe Correlation and Covariance
- Explain F-Test two-sample for variances
- Describe Histogram and moving average
- Explain Random number generation
- Describe Regression, Sampling, Rank, and Percentile
- Describe Exponential Smoothing
Macros and Forms
- Describe Automatic Data Processing
- Explain the creation and running of a macro
- Explain assigning a macro to a command button
- Explain the creation of a custom macro button on the Quick Access Toolbar
- Describe macro security
- Describe Macro Add-ins
- Describe Form controls
- Use of Solver, Subtotal, Goal Seek, Scenario
- Describe the procedure to import and export XML data with Excel
Advanced Microsoft Excel – Course Overview
Overview
Learn the Tools & Techniques you can apply in MS Excel to Analyze and Manage data to ensure that your work is well organized and helps you to calculate and visualize quantitative data thus helping you make important statistical and financial decisions at your workplace.
Learning outcomes include
- Apply advanced formatting options, such as conditional formatting and customized number formatting, and handle worksheets.
- Use functions associated with logical, statistical, financial, and mathematical operations.
- Create charts and apply advanced chart formatting features.
- Work with tables and lists to analyze, filter, and sort data. Create and use scenarios.
- Collaborate on and review spreadsheets. Apply spreadsheet security features.
Duration: 20 Hours
Entry Requirement: Basic knowledge of MS- Office and MS–Excel.
Certificate: Certificate of participation in Advanced Microsoft Excel
Software Training: – MS Excel 2016
Course Location: Edulink International College Nairobi
Please Note:-
- Study Materials: Students will get a printable softcopy of the study materials developed by ICDL. Along with the study materials they will also get revision papers to assist in the preparation for exams.
- Exam Retakes: All of the above fees are inclusive of the ICDL registration and first exam attempt. A cost will be incurred for resits of the exams as required.
- Award of Certifications: After the completion/ passing of each exam module, the candidate will get certification from ICDL. These certificates will include a list of all the module exams candidates have passed.
- Faculty Qualifications: All of our teaching staff will attend special training organized by ICDL and will be certified by ICDL as a trainer.
Apply now: http://edulink.ac.ke/apply-now/
Advanced Microsoft Excel – Course Modules
Course Content Details:-
Sharing and Maintaining Workbook
- Explain the new features of MS Excel 2016
- Explain customization of the Ribbon and the Quick Access Toolbar
- Explain the procedure to add data by using FlashFill, AutoFill, and AutoComplete
- Explain proofing and management of Add-ins
- Describe built-in and custom templates in Excel
- Describe worksheet protection and locking/unlocking of cells
- Explain protection, finalization, and encryption of a workbook
- Explain the concept of shared workbooks
- Explain the procedure for change tracking in a shared workbook
- Explain the process of recovering unsaved versions of a file
Formulas and Functions
- Trace formula precedents and dependents
- Use the data validation tool and check for errors in a file
- Implement iterative calculations
- Use single-cell and multi-cell array formula
- Use SUMIFS(), COUNTIFS(), and basic counting functions
- Describe the Quick Analysis Tool for Data Analysis
- Describe Data consolidation
- Describe mathematical, trigonometry, statistical, and financial functions, Date, Time, Data Type, and Conversion Functions
- Describe Text, Logical, and LookUp functions
- Conditional Formatting
Advanced Chart Features
- Explain the importance of chart and the different types of chart
- Explain Recommended Charts
- Explain modification of chart elements, chart area, plot area, and chart axes
- Describe formatting of chart title, legend, and gridlines
- Explain the Trend line and data series
- Explain dual axes and chart templates
- Describe combination chart, error bars, and data tables
Presenting Data Visually
- Explain conditional formatting
- Explain Sparklines and list the steps to create it
- Describe the importance of Pivot Table and its various features
- Describe the procedure to create recommended PivotTables
- Explain the concept of PivotCharts and list the steps to customize it
- Explain slicers and list the steps to create it
- Describe the procedure to use Power View
Data Analysis
- Explain Analysis ToolPak
- Explain single-factor and two-factor tools with and without replication
- Describe Correlation and Covariance
- Explain F-Test two-sample for variances
- Describe Histogram and moving average
- Explain Random number generation
- Describe Regression, Sampling, Rank, and Percentile
- Describe Exponential Smoothing
Macros and Forms
- Describe Automatic Data Processing
- Explain the creation and running of a macro
- Explain assigning a macro to a command button
- Explain the creation of a custom macro button on the Quick Access Toolbar
- Describe macro security
- Describe Macro Add-ins
- Describe Form controls
- Use of Solver, Subtotal, Goal Seek, Scenario
- Describe the procedure to import and export XML data with Excel