MS Office (Advanced Excel) Certification Training
One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.
One of the most popular platforms in use today is Microsoft Office. Working understanding of MS Office is seen as being important regardless of whether one is a business leader or a complete novice in any field. In this sense, individuals from a variety of backgrounds and industry sectors can benefit greatly from training in Microsoft Office. Enrol today to earn your certification.
MS Office Training Course Syllabus
✔ What’s new in Word 2013
✔ How to open new documents and existing documents
✔ How to use templates
✔ Basic and advanced text, paragraph, and document formatting
✔ How to use Microsoft Word for desktop publishing
✔ How to create brochures, flyers, and even business cards using MS Word
✔ How to insert images, graphics, and video
✔ How to create even more impressive tables than ever before using new formatting tools
✔ How to solve mathematical equations using Word
✔ Mail Merge
✔ Create a spreadsheet
✔ Format cells, rows, columns, and entire worksheets so they fit and match your data
✔ Enter data into a spreadsheet
✔ Use formulas and functions for math, accounting, and totaling
✔ Create formulas and functions
✔ Create charts and diagrams for your data
✔ Create data lists and forms
✔ Create and use pivot tables and pivot charts
✔ Work with Excel templates
✔ Share and protect your worksheets and workbooks
✔ Use What-If Analysis to determine possible outcomes
✔ Navigate the PowerPoint 2013 interface
✔ Create new presentations from scratch – or use the beautiful template
✔ Add text, pictures, sounds, movies, and charts to your presentations
✔ Design slides using themes, colors, and special effects
✔ Animate objects on slides to bring them to life. We’ll even show you how to make a ball bounce on a slide!
✔ Add special effects to slide transitions to spice up your presentations
✔ Work with Master Slides to make editing your presentation easy
✔ Set up slide shows and rehearse timings for your slides
✔ Collaborate using social media and PowerPoint together
✔ Examine database concepts and explore the Microsoft Office Access environment.
✔ Design a simple database
✔ Build a new database with related tables
✔ Manage the data in a table
✔ Query a database using different methods
✔ Design a form.
✔ Generate a report.
✔ Import and export data.
✔ Access Basics
✔ Design a Database
✔ Build a Database
✔ Work with Forms
✔ Sort, Retrieve, Analyze Data
✔ Work With Reports
✔ Access with Other Applications
✔ Manage and Access Database
|Live Instructor Based Training With Software|
|Lifetime access and 24×7 support|
|Certification Oriented content|
|Hands-On complete Real-time training|
|Get a certificate on course completion|
|Live Recorded Videos Access|
|Study Material Provided|
MS Office Training - Upcoming Batches
Don't find suitable time ?
CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE
Live Virtual Training
Schedule your sessions at your comfortable timings.
Instructor-led training, Real-time projects
Complete set of live-online training sessions recorded videos.
Learn technology at your own pace.
Get access for lifetime.
Learn As A Full Day Schedule With Discussions, Exercises,
Practical Use Cases
Design Your Own Syllabus Based
MS Office Online Training FAQ'S
To connect with the cloud service on word 2013 you have to go to
a Main Menu Open One Drive click on sign in option enter the e-mail address and it will connect you with cloud service
To insert video into the word document you have to go to
INSERT a Online Video Media Enter the keyword or video you are looking for Press enter click on the video you want to add it To add or download video, click Insert
The video will appear on word as an image when the download is completed, click on play button to play your video
To make readers read or see only the part they are interested in, this function is very useful. To do this you have to first give a heading to your topic as heading 1, heading 2 ….from Home Menu. Once this is done a small icon will appear on the corner of the heading, on clicking on this icon it will merge the content and on re-clicking on it, it will expand the content back to its normal place.
Get ahead in your career by learning MS Office through VISWA Online Trainings
To edit PDF document in 2013,
- Click the file menu
- Click on Open icon
- Select the PDF file from your local disk
- Select the file and click Open
- When word displays the informational dialog, click ok
- If word display, the protected view bar at the top of the document, click enable editing
- You can edit PDF file now with word, once file is edited you can save it as PDF or in Word format
To add foot node, bring the cursor at the end of page where you want to add the foot node than go to main menu click on Reference Option click on Insert Footnotes. Likewise you can add end note by clicking on “Insert endnote”.