Expertise in MS-Office
Get MS-Office 2016' Training Classes in Balasore
Gain a good business standard level of knowledge in key Microsoft Office programs – Windows, Internet, Word, Excel, PowerPoint.
Almost every business will use at least one Microsoft Office programme (Word, Excel, PowerPoint) in their day-to-day operations. Many will use the entire suite. As such, a good understanding of the software is essential for any office-based career.
'MS Office-Expert' Course Overview
Windows 10
- All About Windows
- Navigating Windows
- Working with Applications
- Working with Windows
- Shutting Down your Computer
- Working with Files or Folders
- Moving and Deleting Files or Folder
- Selecting Multiple Files or Folders
- Finding Files on your Computer
- Searching for Files
- Common computer tasks
- Keyboard shortcuts in Windows
INTERNET Basic
- Introduction to Internet
- What Can You Do Online ?
- What is the Cloud?
- What is a web app?
- Using a web browser
- Using search engines
- Understanding URLs
MS – Word 2016
- Menu Bars & Toolbars
- Page Setup
- Standard & Format Tool Bar
- Drawing Tools,Auto-format
- Inserting Objects & Pictures
- Newspaper style Columns
- Borders & Shading
- Headers & Footers
- Inserting Symbols
- Bullet & Numbering
- Thesaurus, Word Count
- Auto Text Entry
- Auto Correct, Tables
- Sorting, Mail Merge
MS – Excel 2016
- Electronic Spreadsheet Concept
- Formatting Fonts
- Numbers, Auto-Format
- Relative & Absolute Reference
- Date & Currency Formatting
- Formula charts & Graphs
- 2D/3D Graphs
- Pie, Line Cone
- Formatting Charts
- Data Values
- Sub Total Reports
- Auto Filters
- Password Protecting Worksheets
- Linking Multiple Sheets
MS – PowerPoint 2016
- Electronic Slide Presentation
- Slide Formatting
- Theme & Slide Layout
- Clip art Charts-Animation Effects
- Setting up a Slide Show & Giving Timings
- Linking Word & Excel
What will be the 'MS Office-Expert' Training Syllabus?
Windows 10
The desktop
Parts of a window
To move a window
To resize a window
Switching between windows
To shut down your computer
Restarting and Sleep mode
What is a file?
What is a folder?
File Explorer
To open a file
To move a file
To create a new folder
To rename a file or folder
To delete a file or folder
Selecting more than one file
Selecting all files
To create a shortcut
Common places to look for files
To search for a file
Tips for finding files
File menu commands
To copy and paste
To cut and paste
To copy and paste files
Undoing changes
Working with text
Working with files and applications
Internet shortcuts
Using the Alt key to navigate menus
Finding more keyboard shortcuts
INTERNET Basics
What is Internet ?
Learn the basics of using the Internet.
What Can You Do Online ?
Learn all the things you can do online.
Connecting to the Internet
Learn how to get Online and start using the Internet
Understanding the Cloud
Gain a greater understanding of the cloud and how it works.
Using a Web Browser
Use these tips so you can get the most out of your web browser.
Understanding Hyperlinks
Learn how hyperlinks work to connect various webpages
Downloading and Uploading
Learn how to upload and download files on your computer
Using Search Engine
Learn how search engines work, as well as how to use them.
Understanding URLs
Understand how URLs work and what they are.
MS-Word 2016
Getting Started with Word :
Get to know the Ribbon, Quick Access Toolbar, and Backstage view to produce Word 2016 documents.
Understanding OneDrive
Learn all about working with your Microsoft account and OneDrive.
Creating and Opening Documents
Learn all about opening existing documents and creating new ones.
Saving and Sharing Documents
Learn more about saving and sharing documents.
Text Basics
Learn how to add, delete, move, cut, copy, and paste text.
Formatting Text
Learn how to change font size, color, and text alignment.
Using Find and Replace
Learn more about using the Find and Replace features to search your document.
Indents and Tabs
Learn how to use the tab selector and horizontal ruler to set tabs and indents.
Line and Paragraph Spacing
Learn how to modify line and paragraph spacing in your documents.
Lists
Learn how to add and modify bulleted and numbered lists.
Hyperlinks
Learn how to add and modify hyperlinks.
Page Layout
Learn how to modify page orientation, margins, and size.
Printing Documents
Learn all about printing in Word 2016.
Breaks
Learn how to add page, section, and column breaks.
Columns
Learn all about working with columns.
Headers and Footers
Learn how to add and modify headers and footers.
Page Numbers
Learn how to add and modify page numbers.
Pictures and Text Wrapping
Learn how to add pictures and use the text wrapping feature.
Formatting Pictures
Learn more about formatting pictures, including removing the background from an image.
Shapes
Learn how to add and modify shapes in your document.
Text Boxes
Learn how to use text boxes in Word 2016.
Aligning, Ordering, and Grouping Objects
Learn how to align, group, order, and rotate objects.
Tables
Learn more about working with tables.
Charts
Learn how to add and modify charts.
Checking Spelling and Grammar
Learn how to use the review features available in Word 2016.
Track Changes and Comments
Learn how to track changes and comments when collaborating on documents.
Inspecting and Protecting Documents
Take these steps to inspect and protect your document.
SmartArt Graphics
Learn all about using SmartArt graphics in your document.
Applying and Modifying Styles
Learn how to apply and modify styles.
Mail Merge
Learn how to use the Mail Merge feature to produce letters, labels, and envelopes.
MS- Excel 2016
Getting Started with Excel
Learn your way around the Excel 2016 environment.
Understanding OneDrive
Learn all about working with your Microsoft account and OneDrive.
Creating and Opening Workbooks
Learn how to create and open Excel workbooks.
Saving and Sharing Workbooks
Learn how to save and share Excel workbooks.
Cell Basics
Learn how to insert and delete cells and cell content, drag and drop cells, use the fill handle, and use the cut, copy, and paste functions.
Modifying Columns, Rows, and Cells
Learn how to modify rows, columns, and cells in Excel.
Formatting Cells
Learn all about formatting text in Excel.
Understanding Number Formats
Learn all about formatting numbers in Excel.
Working with Multiple Worksheets
Learn how to add, delete, copy, and move worksheets, as well as group and ungroup worksheets.
Using Find & Replace
Learn how to use Excel’s Find and Replace features to search for specific data.
Checking Spelling
Learn how to use Excel’s spell check feature.
Page Layout and Printing
Learn how to use Excel commands that let you control the way your content will appear on a printed page.
Intro to Formulas
Learn how to use cell references to create a simple formula in Excel.
Creating More Complex Formulas
Learn how to create a complex formula in Excel.
Relative and Absolute Cell References
Learn all about absolute and relative cell references and how they’re used in Excel.
Functions
Learn the different parts of a function and how to create arguments to calculate values and cell references.
Basic Tips for Working with Data
Learn these basic tips for working with data to help you organize it and find what you need.
Freezing Panes and View Options
Learn how to freeze panes and split your worksheet so you’re only seeing certain parts of your worksheet.
Sorting Data
Learn how to sort data to better view and organize the contents of your spreadsheet.
Filtering Data
Learn how to filter the data in your worksheet to display only the information you need.
Groups and Subtotals
Learn how to organize data in groups, summarize different groups using the Subtotal command, and create an outline for your worksheet.
Tables
Learn how to use styles to format tables in Excel.
Charts
Learn how to insert and modify Excel charts to visualize comparisons in your data.
Conditional Formatting
Learn how to apply, modify, and delete conditional formatting rules in Excel.
Track Changes and Comments :
Learn how to use Excel’s track changes and comments features when proofreading workbooks.
Inspecting and Protecting Workbooks :
Learn how to inspect and protect your Excel workbook.
Intro to PivotTables :
Learn how to use PivotTables in Excel for stronger data analysis.
Doing More with PivotTables :
Learn how to do more with PivotTables in Excel to better summarize data.
What-if Analysis :
Learn how to use what-if analysis to answer different types of questions.
MS- PowerPoint 2016
Getting Started with PowerPoint
Get to know the PowerPoint 2016 interface.
Understanding OneDrive
Learn all about working with your Microsoft account and OneDrive.
Creating and Opening Presentations
Learn all about creating and opening presentations.
Saving Presentations
Learn how to save presentations.
Slide Basics
Learn the basics of working with slides.
Text Basics
Learn how to cut, copy, paste, and format text.
Applying Themes
Learn how to apply a theme to your slides.
Applying Transitions
Learn how to apply transitions to your slides.
Managing Slides
Learn the tools available to help organize and prepare your slide show.
Using Find & Replace
Learn how to find and replace text.
Printing
Learn how to print your slides.
Presenting Your Slide Show
Learn how to present your slide show to an audience.
Lists
Learn how to add numbered and bulleted lists.
Indents and Line Spacing
Learn how to use indents and line spacing.
Inserting Pictures
Learn how to insert and modify images.
Formatting Pictures
Learn how to format the images in your slides.
Shapes
Learn how to add and modify shapes.
Aligning, Ordering, and Grouping Objects
Learn how to align, group, and order objects.
Animating Text and Objects
Learn how to animate text and objects.
Inserting Videos
Learn how to add and edit videos within your slides.
Inserting Audio
Learn how to insert and edit audio in your slides.
Tables
Learn how to add and modify tables.
Charts
Learn how to add and modify charts.
SmartArt Graphics
Learn how to add and edit SmartArt graphics.
Checking Spelling and Grammar
Learn how to use the spelling and grammar check features.
Reviewing Presentations
Learn how to review presentations before you present them to an audience.
Inspecting and Protecting Presentations
Learn how to inspect and protect your presentation.
Modifying Themes
Learn all about modifying themes to mix and match colors and fonts.
Slide Master View
Learn how to use Slide Master view to ensure a consistent look.
Hyperlinks
Learn how to add and edit hyperlinks.
Action Buttons
Learn how to add and edit action buttons.
Rehearsing and Recording Your Presentation
Learn how to rehearse and record your presentation.
Sharing Your Presentation Online
Learn how to share your presentations online.
: MS-Office Materials :
Try Digital Marketing
[ A Div. of SWAYAM EDUCATION ]
Bhoisahi, Central School Road,
Near Siddhi Vinayak Public School,
Balasore, Odisha-756003 (INDIA)
eMail ID : contact@trydigitalmarket.com
Mob : 9437264738