This program aims to equip
experienced trainees with the essential skills to work in Microsoft Excel in
key areas: formulas, list management, and charts. It also covers Microsoft
PowerPoint, providing advanced features such as master slides, creating templates
and themes, and efficiently using media like video and audio.
By the end of this course, participants will be able to:
•
Work with
logical functions - create more complex formulas and functions.
•
Apply a range
of number formatting techniques to worksheet cells.
•
Implement
conditional formatting on ranges within a worksheet.
•
Use a variety
of search and replace methods.
•
Sort data in
a list on a worksheet - filter data in a table.
•
Utilize a
range of elements and features to enhance charts.
•
Protect data
in worksheets and workbooks.
•
Create and
edit PivotCharts - create macro modules.
•
Efficiently
work with themes and templates.
•
View and
modify master slides.
•
Create and
use (custom templates / tables / charts).
•
Insert and
edit images - work with various types of media.
•
Create
animated graphics in a presentation - save and protect presentations.
- Filling cells with numbers, dates, and formulas.
- Creating custom fill lists.
- Using IF with text - Using IF with numbers.
- LOOKUP function.
- Using counting functions - ROUNDUP and ROUNDDOWN.
- Date functions - Text functions.
- Search functions - Conditional sum and count functions.
- Understanding conditional formatting.
- Formatting cells containing values - Clearing conditional formatting.
- More cell formatting options.
- Working with table styles - Adding a data table.
- Chart formatting - Selecting the chart.
- Using shape styles - Understanding data validation.
- Creating data validation ranges - Data validation tests.
- Creating input messages - Creating error messages - Creating drop-down lists.
- Using formula-based validation criteria - Copying validation settings.
- Sharing workbooks - Saving to OneDrive.
- Enabling tracked changes - Accepting or rejecting changes.
- Disabling tracked changes - Adding worksheet comments.
- Editing worksheet comments - Deleting comments.
- Creating PivotTables - Defining PivotTable structure - Filtering PivotTables - Pivoting PivotTable fields.
- PivotTable formatting - Using calculated fields - Counting in PivotTables.
- Formatting PivotTable values - Aggregating in PivotTables - Creating calculated items.
- PivotTable options - Sorting in PivotTables.
- Inserting PivotCharts - Defining PivotChart structure.
- Changing PivotChart type using PivotChart filter field buttons - Moving PivotCharts to layout sheets.
- Extracting records with advanced filtering - Data filtering using formulas.
- Recording - Running a simple macro - Recorded macros.
- Running macros with relative references - Viewing macros - Editing macros.
- Assigning keyboard shortcuts to macros - Copying and deleting macros.
- Understanding features - Changing slide background.
- Understanding master slides - Viewing the master slide.
- Modifying slide layouts.
- Understanding templates - Using an existing template - Creating a template from a template.
- Inserting a new table - Adding rows and columns - Applying table style.
- Resizing and positioning the table - Formatting table data.
- Aligning table data - Using quick layouts.
- Changing chart element layouts - Applying chart style.
- Understanding chart format parts - Formatting chart elements.
- Editing data series - Hiding data series.
- Inserting an image from a file - Inserting an online picture - Inserting a clip art.
- Inserting a screenshot - Creating a photo album.
- Inserting an online video - Inserting an online audio clip.
- Formatting media clips - Editing audio clips.
- Setting up a self-running presentation - Timing for practice.
- Creating a custom show - Using presenter view.
- Saving a presentation as a video.
- Sending a presentation via email.
- Delivering a slide show online.
- Saving to OneDrive - Sharing presentations.