About Course
This course covers the basics of office application from Basic navigation
to Creating Documents through tabs, formatting ,creating Spreadsheets,
using worksheet, formulas and analysing data,Pivot Tables,Give
Electronic Presentation for your business work.
Who should attend the course
This Course is primarily designed for people who need to know how to use Basic
office application.This course can be attended by a Business man,HR,sales
and Marketing Managers and Executives,Students,Housewives,Engineers,Business
analyst,Auditor and all professionals and individuals.Our course methodology
includes training right from an absolute beginner to an expert level.This course
is also sutiable for individuals to upgrade their career.
Eligibility
No prior knowledge required,Person should have a general understanding of
personal computers and the windows operating system.
What will you learn?
Document
- Why Word?
- Using Word Interface
- Understanding Ribbon
- Customizing Quick Access Toolbar
- Use Navigation Pane
- Learn and use Backstage
- Creating,Opening,Saving,Printing Closing document
- Selecting Text using Mouse/Keyboard
- Rearraing using Cut,Copy,Paste
- Undo/Redo,Find and Replace
- Working with Fonts
- Working with Paragraphs
- Using Tables
- Insert picture,Smart Art,Chart,content from Excel
- Headers and Footers,cover page
- Setting Page margin,orientation and size Use columns,watermark,pageborders
colours ,Use Spell check,Autocorrect and Autoformat options
- Creating Resumes,Brochures,Flyers
Spreadsheet
- Exploring three common uses for Excel
- Touring the interface
- Finding the commands,you need using Backstage view or the File tab
- Maintaining file compatibility
- Creating worksheet
- Entering Date,Autofill
- Formulas and functions
- Sum,Autosum,UsingIF,Time and Date
- Preventing errors
- Conditional Formatting
- Marketing to fit in page
- Printing PDFS
- Sorting,Sub Total
- Charts
- Basics of Pivot,Lookup
Presentation
- Managing your presentation with Backstage
- Using the Office Ribbon
- Customizing the view
- Customizing the Office Ribbon
- Starting from Scratich
- Adding sildes and content
- Deleting slides and changing layouts
- Rearranging Slides
- Saving time with Outline mode
- Separating your show into sections
- Adding photos and clip art
- Saving a presentation ,Applying a theme
- Running the show
