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.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

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

How to navigate the Word 2013 interface

✔ 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
✔ Macro

MS Excel (MS Office)

✔ 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

MS Powerpoint

✔ 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

MS Access

✔ 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
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

MS Office Training - Upcoming Batches

7th NOV 2022

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

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
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

MS Office Online Training FAQ'S

How you can connect with cloud service on word 2013 ?

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

How you can insert video in Microsoft Word 2013 ?

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

How you can collapse or expand parts of a document?

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

How to edit PDF document in 2013?

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
How to add foot-node & end note in word?

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”.

Reviews

Quick Links