MS Office Training
MS Office Training in Chennai
Description
We ensure that our MS Office training course gives you robust office management tools with the right mixture of usability, power, and flexibility, so you can manage your job more efficiently and productively. This course will cover MS Word, MS Excel, MS PowerPoint, Outlook & Project. Learn core and advanced Microsoft Office products through our MS office training classes and improve your skillset to meet the market demand.
- Getting started with Word
- Creating, Opening & Saving documents
- Text basics & formatting text
- Using Find & replace
- Indents & Tabs
- Printing layout & printing documents
- Breaks & Columns
- Headers & Footers
- Pictures & text wrapping
- Fomatting pictures
- Aligning, ordering & grouping
- Tables & charts
- Checking spelling & grammer
- Track changes & comments
- Inspecting & protecting documents
- Create a document
- Navigate through a document
- Format a document
- Customise options and views for documents
- Print and save documents
- Insert text and paragraphs
- Format text and paragraphs
- Order and group text and paragraphs
- Create a table
- Modify a table
- Create and modify a list
- Create and manage reference markers
- Create and manage simple references
- Insert graphic elements
- Format graphic elements
- Insert and format SmartArt graphics
- Manage documents and templates
- Prepare documents for review
- Manage document changes
- Perform advanced editing and formatting
- Create styles
- Create and manage indexes
- Create and manage references
- Manage forms, fields and Mail Merge operations
- Create and modify building blocks, macros and controls
- Create custom style sets and templates
- Prepare a document for internationalisation and accessibility
- A overview of the screen, navigation and basic spreadsheet concepts
- Understanding workbooks, worksheets, rows, columns, cells
- Various selection techniques
- Entering, Editing and Deleting Text, Numbers, Dates
- Using Auto Lists
- Moving and Copying data
- Using navigation techniques
- Using Workbook Views
- Selecting and Switching Between Worksheets
- Understading & working rows, columns and worksheets
- Concept of Formulae
- Creating Formulae, Editing Formulae
- Bodmas : Mathematical Order
- Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
- Basic conditional formatting
- Working with Styles
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Customise options and views for worksheets and workbooks
- Configure worksheets and workbooks for distribution
- Insert data in cells and ranges
- Format cells and ranges
- Summarise and organise data
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
- Summarise data by using functions
- Perform conditional operations by using functions
- Format and modify text by using functions
- Create charts
- Format graphic elements
- Insert and format objects
- Manage workbooks
- Manage workbook review
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Create and modify custom workbook elements
- Different levels of protection
- Setting permission & track changes
- Prepare a workbook for internationalisation
- Apply mathematical functions in formulas
- Look up data by using functions
- Advanced logical & text functions
- Apply advanced date and time functions
- Perform data analysis and business intelligence
- Troubleshoot formulas using error handling functions
- Define named ranges and objects
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
- Bar Charts / Pie Charts / Line Charts
- Planning a Dashboard
- Adding Tables to Dashboard
- Adding Charts to Dashboard
- Adding Dynamic Contents to Dashboard
- Getting started with Powerpoint
- Creating & Opening presentations
- Slide basics
- Text basics
- Applying themes & transitions
- Managing & printing slides
- Presenting your slideshow
- Lists
- Indents & Line spacing
- Inserting & Formatting pictures & shapes
- Aligning, ordering and grouping objects
- Animating texts & objetcs
- Checking spelling & grammer
- Reviewing presentations
- Inspecting & protecting presentations
- Create a presentation
- Insert and format slides
- Modify slides, handouts and notes
- Order and group slides
- Change presentation options and views
- Configure a presentation for print
- Configure and present a slide show
- Insert and format text
- Insert and format shapes and text boxes
- Insert and format images
- Order and group objects
- Insert and format tables
- Insert and format charts
- Insert and format SmartArt graphics
- Insert and manage media
- Apply slide transitions
- Insert slide transitions, set transition effect options
- Animate slide content
- Set timing for transitions and animations
- Merge content from multiple presentations
- Finalise presentations
- Customise settings
- Print and save information
- Perform search operations in Outlook
- Configure mail settings
- Create messages
- Format a message
- Organise and manage messages
- Create and manage calendars
- Create appointments, meetings and events
- Organise and manage appointments, meetings and events
- Create and manage notes and tasks
- Create and manage contacts
- Create and manage contact groups