Saudi Arabia
Egypt
UAE
Canada
Microsoft: Excel - PowerPoint
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.
