Enter your keyword

Office 2019 Course in surat

Office 2019

CCC Training Institute in Surat

office 2019 training course in surat

Manage presentations

Modify slide masters, handout masters, and note masters
* change the slide master theme or background
* modify slide master content
* create slide layouts
* modify slide layouts
* modify the handout master
* modify the notes master

Change presentation options and views
* change slide size
* display presentations in different views
* set basic file properties

Configure print settings for presentations
* print all or part of a presentation
* print notes pages
* print handouts
* print in color, grayscale, or black and white

Configure and present slide shows
* create custom slide shows
* configure slide show options
* rehearse slide show timing
* set up slide show recording options
* present slide shows by using Presenter View

Prepare presentations for collaboration
* mark presentations as final
* protect presentations by using passwords
* inspect presentations for issues
* add and manage comments
* preserve presentation content
* export presentations to other formats

Manage slides

Insert slides
* import Word document outlines
* insert slides from another presentation
* insert slides and select slide layouts
* insert Summary Zoom slides
* duplicate slides

Modify slides
* hide and unhide slides
* modify individual slide backgrounds
* insert slide headers, footers, and page numbers

Order and group slides
* create sections
* modify slide order
* rename sections

Insert and format text, shapes, and images

Format text
* apply formatting and styles to text
* format text in multiple columns
* create bulleted and numbered lists

Insert links
* insert hyperlinks
* insert Section Zoom links and Slide Zoom links

Insert and format images
* resize and crop images
* apply built-in styles and effects to images
* insert screenshots and screen clippings

Insert and format graphic elements
* insert and change shapes
* draw by using digital ink
* add text to shapes and text boxes
* resize shapes and text boxes
* format shapes and text boxes
* apply built-in styles to shapes and text boxes
* add alt text to graphic elements for accessibility

Order and group objects on slides
* order shapes, images, and text boxes
* align shapes, images, and text boxes
* group shapes and images
* display alignment tools

Insert tables, charts, smartArt, 3D models, and media

Insert and format tables
* create and insert tables
* insert and delete table rows and columns
* apply built-in table styles

Insert and modify charts
* create and insert charts
* modify charts

Insert and format SmartArt graphics
* insert SmartArt graphics
* convert lists to SmartArt graphics
* add and modify SmartArt graphic content

Insert and modify 3D models
* insert 3D models
* modify 3D models

Insert and manage media
* insert audio and video clips
* create and insert screen recordings
* configure media playback options

Apply transitions and animations

Apply and configure slide transitions
* apply basic and 3D slide transitions
* configure transition effects

Animate slide content
* animate text and graphic elements
* animate 3D models
* configure animation effects
* configure animation paths
* reorder animations on a slide

Set timing for transitions
* set transition effect duration
* configure transition start and finish options

Manage workbook options and settings

Manage workbooks
* copy macros between workbooks
* reference data in other workbooks
* enable macros in a workbook
* manage workbook versions

Prepare workbooks for collaboration
* restrict editing
* protect worksheets and cell ranges
* protect workbook structure
* configure formula calculation options
* manage comments

Use and configure language options
* configure editing and display languages
* use language-specific features

Manage and format data

Fill cells based on existing data
* fill cells by using Flash Fill
* fill cells by using advanced Fill Series options

Format and validate data
* create custom number formats
* configure data validation
* group and ungroup data
* calculate data by inserting subtotals and totals
* remove duplicate records

Apply advanced conditional formatting and filtering
* create custom conditional formatting rules
* create conditional formatting rules that use formulas
* manage conditional formatting rules

Create advanced formulas and macros

Perform logical operations in formulas
* perform logical operations by using nested functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR(), and NOT() functions

Look up data by using functions
* look up data by using the VLOOKUP(), HLOOKUP(), MATCH(), and INDEX() functions

Use advanced date and time functions
* reference date and time by using the NOW() and TODAY() functions
* calculate dates by using the WEEKDAY() and WORKDAY() functions

Perform data analysis
* summarize data from multiple ranges by using the Consolidate feature
* perform what-if analysis by using Goal Seek and Scenario Manager
* forecast data by using the AND(), IF(), and NPER() functions
* calculate financial data by using the PMT() function

Troubleshoot formulas
* trace precedence and dependence
* monitor cells and formulas by using the Watch Window
* validate formulas by using error checking rules
* evaluate formulas

Create and modify simple macros
* record simple macros
* name simple macros
* edit simple macros

Manage advanced charts and tables

Create and modify advanced charts
* create and modify dual axis charts
* create and modify charts including Box & Whisker, Combo, Funnel, Histogram, Map, Sunburst, and Waterfall charts

Create and modify PivotTables
* create PivotTables
* modify field selections and options
* create slicers
* group PivotTable data
* add calculated fields
* format data

Create and modify PivotCharts
* create PivotCharts
* manipulate options in existing PivotCharts
* apply styles to PivotCharts
* drill down into PivotChart details

Manage documents

Navigate within documents
* Search for text
* Link to locations within documents
* Move to specific locations and objects in documents
* Show and hide formatting symbols and hidden text

Format documents
* Set up document pages
* Apply style sets
* Insert and modify headers and footers
* Configure page background elements

Save and share documents
* Save documents in alternative file formats
* Modify basic document properties
* Modify print settings
* Share documents electronically

Inspect documents for issues
* Locate and remove hidden properties and personal information
* Locate and correct accessibility issues
* Locate and correct compatibility issues

Insert and format text, paragraphs, and sections

Insert text and paragraphs
* Find and replace text
* Insert symbols and special characters

Format text and paragraphs
* Apply text effects
* Apply formatting by using Format Painter
* Set line and paragraph spacing and indentation
* Apply built-in styles to text
* Clear formatting

Create and configure document sections
* Format text in multiple columns
* Insert page, section, and column breaks
* Change page setup options for a section

Manage tables and lists

Create tables
* Convert text to tables
* Convert tables to text
* Create tables by specifying rows and columns

Modify tables
* Sort table data
* Configure cell margins and spacing
* Merge and split cells
* Resize tables, rows, and columns
* Split tables
* Configure a repeating row header

Create and modify lists
* Format paragraphs as numbered and bulleted lists
* Change bullet characters and number formats
* Define custom bullet characters and number formats
* Increase and decrease list levels
* Restart and continue list numbering
* Set starting number values

Create and manage references

Create and manage reference elements
* Insert footnotes and endnotes
* Modify footnote and endnote properties
* Create and modify bibliography citation sources
* Insert citations for bibliographies

Create and manage reference tables
* Insert tables of contents
* Customize tables of contents
* Insert bibliographies

Insert and format graphic elements

Insert illustrations and text boxes
* Insert shapes
* Insert pictures
* Insert 3D models
* Insert SmartArt graphics
* Insert screenshots and screen clippings
* Insert text boxes

Format illustrations and text boxes
* Apply artistic effects
* Apply picture effects and picture styles
* Remove picture backgrounds
* Format graphic elements
* Format SmartArt graphics
* Format 3D models

Add text to graphic elements
* Add and modify text in text boxes
* Add and modify text in shapes
* Add and modify SmartArt graphic content

Modify graphic elements
* Position objects
* Wrap text around objects
* Add alternative text to objects for accessibility

Manage document collaboration

Add and manage comments
* Add comments
* Review and reply to comments
* Resolve comments
* Delete comments

Manage change tracking
* Track changes
* Review tracked changes
* Accept and reject tracked changes
* Lock and unlock change tracking

Apart from Techradix’s Certification, also get prepared for globally recognized certifications like:

Exam MO-100: Microsoft Word (Word and Word 2019)
Exam MO-200: Microsoft Excel (Excel and Excel 2019)
Exam MO-300: Microsoft PowerPoint (PowerPoint and PowerPoint 2019)