Microsoft Office COURSE TRAINING IN HYDERABAD

About LearnAi.co.in

Learnai.co.in offers a comprehensive range of professional IT and Non-IT courses that are designed to cater to an aspiring group of professionals who went a tailored program on making them career ready. Our programs are driven by a constant need to be job achieving by following industry-oriented course curriculum and stimulating, taking into consideration the dynamic nature of technology with practical knowledge work on different modules, tools and are taught by world-class professionals with specific domain expertise. Simply one stop learning for all trending technologies.

Upcoming Batches

Course	Branch	Training Type	Week	Day
Data Science	Dilsukhnagar	Hybrid	1st	Wednesday
Data Science	Dilsukhnagar	Hybrid	2nd	Monday
Data Science	Dilsukhnagar	Hybrid	3rd	Wednesday
Data Science	Dilsukhnagar	Hybrid	4th	Monday

About Microsoft Office:

Microsoft Office is a set of computer applications mainly used for business or office purposes. ... MS Office helps simplify basic office tasks and improve work productivity. Each application is designed to address specific tasks, such as word processing, data management, making presentations and organizing emails.

Top Reasons to Learn Microsoft Office

• Microsoft Office is used by 90% of Companies Worldwide. Statistically, this means that over 1.2 billion people and most businesses are currently using Microsoft Office. ...
• Employment. ...
• Cloud Service. ...
• Different Features and Support. ...
• Trust and Reliability. ...
• Highly User-Friendly Interface and Features.

Who can Pursue Artificial Intelligence?

Any Degree pursuing or Graduated,
 Bachelor’s, Master’s, PhD, and
 Anyone interested in course

Enroll to Course Now

Services	Essential Course Package	Mid-Level Career Booster	Mastery Career Package
Members	>20	<15	<10
Duration	3 Months	7 Months	7 Months + 1 Year
Portal
Course Completion Certificate
One to One
Resume Preparation
Mock Interviews
Job Assistance
Internship
Job Guarantee

COURSE CURRICULUM

MS WORD

•	Introduction to MS word
•	Basics
•	Formatting text
•	Editing text
•	Formatting paragraph in ms office
•	Spelling and grammar
•	Customize Ribbon
•	Templates
•	Auto correct features
•	Tables
•	Ms word insert shapes
•	Insert pictures
•	Format picures
•	Insert objects
•	Convert pdf to word
•	Convert word to webpage
•	Watermark
•	Page background
•	Page setup
•	Header and footer for slides
•	Restrict editing
•	Mail merge
•	Export document
•	Styles and document
•	Sections
•	Interactive form

MS Excel

o	MS Excel introduction
o	MS Excel Basics
o	Create & Close Files
o	Tabs & Groups
o	Editing Data
o	Formatting
o	Characteristics of Cell
o	Cell Preference
o	Speak Cells
o	Text to Cells
o	Comments
o	Copying and Filing
o	Advanced Fill
o	Fill Series
o	Flash Fill
o	Viewing worksheets
o	Custom View
o	Adjusting worksheet
o	Working with Worksheets
o	Compare two sheets
o	View files side by side
o	Logical test
o	IF function and Nested IF & AND function
o	Not and If error
o	Auditing Tools
o	Text Functions
o	Date Functions
o	Name Range and Name range with Formulas
o	Basic Formulas
o	Count Functions
o	Statistical Functions
o	Math and trigonometry
o	VLOOKUP approximate match
o	VLOOKUP with trim
o	H-Lookup 
o	VLOOKUP rules
o	Lookup Function
o	Lookup full record
o	Index record
o	Match function
o	Protect cells
o	Protect workbook
o	Hyperlink --sheet & File & Webpage & update
o	Print page setup & print data tips
o	Header & Footer
o	Data Sorting
o	Advanced Filters
o	Filtering Data
o	Basic tables
o	Advanced Tables
o	Sub total
o	Column Chart
o	Pie & Bar & Column & line chart
o	XY Scatter chart
o	Spark line chart
o	Pivot chart 
o	Pivot tables
o	Pivot table Grouping
o	Pivot table Slicing
o	Pivot Table Timeline
o	Consolidation
o	Consolidation extended
o	Conditional Formatting
o	Advanced Conditional Formatting
o	Data Validation
o	Data Validation Error Alert
o	Dependent Dropdown List
o	Import live data from web to excel
o	Insert Objects and Create Objects
o	Shortcuts Ctrl +A to Ctrl +Z
o	Shortcuts Alt +A to Alt +Z
o	Shortcuts Alt to single key
o	Shortcuts Shift+F1 to Shift+F12
o	Shortcuts Shift +single key
o	Shortcuts Ctrl+F1 to Ctrl+F12
o	Shortcuts Ctrl +Special Characters
o	Shortcuts Ctrl +Single key
o	Shortcuts Ctrl +Shift +A to Ctrl +Shift +Z
o	Shortcuts Ctrl +Shift +Special Characters
o	Shortcuts Ctrl +Shift +Single Key
o	Shortcuts Ctrl+Shift+F1 to Ctrl+Shift+F12
o	Shortcuts Alt+F1 to Alt+F12

Job Roles

•	To provide data entry support to superiors.
•	To prepare communication, reports, presentations and other products by operating Microsoft Word, Excel, and Powerpoint.
•	To oversee the clerical support function of an office, business or based on client specific requirements.

Components of Microsoft Office?

 •	Microsoft Word.
•	Microsoft Excel.
•	Microsoft PowerPoint.
•	Microsoft OneNote.
•	Microsoft Outlook.
•	Microsoft Publisher.
•	Microsoft Access.
•	Skype for Business.