MS. Office

MS Office : Overview

Microsoft Excel still remains the top Business Intelligence tool in use today, and it will continue its reign despite marketing efforts of other BI technology vendors. It is also interesting to note that most BI products in the market use an "export to Excel" feature as their selling proposition. That is because when it comes to buying a BI solution, end users look for the ability of product  to export data to Excel as a major criteria for selection. Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self service BI capability and tend to create their own BI solution intuitively without much dependence on IT.
In most businesses, irrespective of their size and scale, users prefer Microsoft Excel to perform analysis. This approach limits the capabilities and the extent to which end users can access enterprise data sources. Not only that, it can compromise data consistency and integrity.
Business Intelligence for Excel Course ensures that you get accurate, complete and timely reports from your enterprise system.

Word : Overview

This course builds upon the initial Microsoft Office 2007/2010 knowledge & skills. It focuses on the enhanced features of MS Office 2016, which students want to leverage to improve the way they manage, organize, present, and distribute their company’s data and information. There are lots of new features added in MS Word 2016 such as ability to create, open, edit and save files in the cloud directly from user’s desktop, a new search tool added for commands available in word, PowerPoint, Excel and outlook named "Tell Me" & "Send as" options in MS Word and PowerPoint, and co-authoring in real time with users connected to office online.

Who should do Introduction to Word 2016 Training Course?

Anyone migrating from earlier Office version to Office 2016

Individual interested to learn Microsoft word 2016

MS. Word

Course Outline 

Module 1: Creating a Microsoft Word Document 

                  This module explains how to get started creating Microsoft Word documents. 

Lessons     Starting a Microsoft Document

                  Creating a Document 

                  Saving a Document 

                  Importing a File 

                  The Status Bar 

                  Closing a Document 

Exercise:   Create a Microsoft Word Document 

                  After completing this module, students will be able to: 

                  Start Microsoft Word. 

                  Create a Microsoft Word document. 

                  Save a Microsoft Word document. 

                  Understand the Status Bar. 

                  Close a Microsoft Word document. 

Module 2: The Ribbon 

                  This module explains how to work with the Ribbon in Microsoft Word. 

Lessons     The Ribbon

                  Tabs 

                  Groups 

                  Commands 

Exercise:    Exploring the Ribbon 

                  After completing this module, students will be able to: 

                  Work with tabs. 

                  Work with groups. 

                  Work with commands 

                  Understand which groups and commands are found on which tabs. 

Module 3: The Backstage View ﴾The File Menu﴿ 

                  This module explains how to work with the many features located in the Backstage view. 

Lessons     Introduction to the Backstage View

                  Opening a Document 

Exercise:   Open a Document 

                  New Documents and Word Templates 

Exercise:   Write a Thank You Letter Using a Template Letter 

                  Configuring Documents to Print 

Exercise:   Print a Document 

                  Adding Your Name to Microsoft Word 

                  Adding Values to Document Properties 

                  Working with Autosaved Versions of Documents 

                  After completing this module, students will be able to: 

                  Understand how to work with the Backstage view. 

                  Open a Microsoft Word Document. 

                  Start a new Microsoft Word document. 

                  Use Microsoft Word templates. 

                  Print a Microsoft Word document. 

                  Personalize their copy of Microsoft Word. 

Module 4: The Quick Access Toolbar 

                  This module explains how to work with the Quick Access Toolbar in Microsoft Word. 

Lessons  :   Adding Common Commands

                  Adding Additional Commands wtih the Customize Dialog Box 

                  Adding Ribbon Commands and Groups 

                  Placement 

Exercise:   Customize the Quick Access Toolbar 

                  After completing this module, students will be able to: 

                  Customize the Quick Access Toolbar. 

Module 5:  Formatting Microsoft Word Documents 

                   This module explains how work with formatting in Microsoft Word. 

Lessons      Selecting Text

                   Selecting Fonts 

Exercise:    Working with Fonts 

                   Working with Lists 

Exercise :   Working with Lists 

                   Inserting a Hyperlink in a Document 

Exercise:    Inserting a Hyperlink 

                   Using Styles 

Exercise:    Applying and Creating Custom Styles 

                   Using Themes 

                   Using the Ruler 

Exercise:    Using Tabs 

                   Setting Margins 

Exercise:    Setting Margins 

                   After completing this module, students will be able to: 

                  Add, remove, and change fonts in Microsoft Word documents. 

                  Work with lists. 

                  Add hyperlinks in a document. 

                  Apply styles in Microsoft Word documents. 

                  Use themes. 

                  Use the Ruler within Microsoft Word. 

                  Set margins within Microsoft Word. 

Module 6:  Editing Documents 

                  This module explains how to edit documents in Microsoft Word. 

Lessons     Find

                  Find and Replace 

                  Find and Replace Tips 

                  Appending Text to a Document 

Exercise:   Using Find and Replace 

                  Using the Clipboard 

Exercise:   Using the Clipboard 

                  After completing this module, students will be able to: 

                  Locate information in your document using Find. 

                  Use Find and Replace to quickly replace words or phrases with other words or phrases. 

                  Use the Cut, Copy, Paste and Format Painter commands to edit documents. 

Module 7:  Finalizing Microsoft Word Documents 

                  This module explains how to use various features to finalize Microsoft Word documents. 

Lessons :   Adding Page Numbers 

Exercise:   Adding Page Numbers 

                  Headers and Footers 

Exercise:  Using Headers and Footers 

                 Checking Spelling and Grammar 

Exercise:  Checking Spelling and Grammar 

                 After completing this module, students will be able to: 

                 Add page numbers to a Microsoft Word document. 

                 Add and customize headers and footers. 

                 Find and correct spelling mistakes. 

                 Find and correct grammar mistakes. 

Module 8: Microsoft Word New Features Since 2013 

                 This module explains how to use the Read Mode and the Object Zoom feature, which                            were   new since 2013. 

Lessons    Using Read Mode

                 Object Zoom Feature 

Exercise:  Exploring the Read Mde and Object Zoom 

                 After completing this module, students will be able to: 

                 Use Read Mode. 

                 Use the Object Zoom Feature 

Module 9: New Features in Word 2016 

                  This module explains how to the Tell Me and Smart Look up features, new to 2016. 

Lessons :   Tell Me

                  Smart Lookup 

MS. Excel 

Module 1: Power Pivot 

                 Introduction to Data model in Excel

                 2013 Introduction to Power Pivot Data 

                 loading from different sources in Excel 

                 Data modeling best practices 

Module 2: DAX Fundamentals  Using 

                 DAX to create calculated 

                 columns and Measures 

Module 3: Power View Introduction to 

                  Power View Visualizing 

                  Data with Power View

Module 4: Power Query Basic Understanding 

                 Query Web Query Working with  

                 Other sources 

Module 5:  Data Mining Overview of 

                  Data Mining Creating a

                  Data Mining Solution

                  Validating a Data Mining Model 

Module 6:  OLAP Integration OLAP with

                  Excel OLAP with Power Pivot 

                  MDX and Excel Offline OLAP Cube 

Module 7: Excel Dashboard and Reports 

                 Excel Chart basics Going Beyond

                 Tables and Charts Creating Advanced Dashboard Components 

                  

 Email  Us :-samarthcompedu@gmail.com

Contact Us:-9898550168

Tally

Our Tally course incorporates fundamental to cutting edge level and our Tally course is intended to get the arrangement in great MNC organizations in Chandkheda Ahmedabad as fast as once you finish the Tally confirmation instructional class. Our Tally coaches are Tally confirmed specialists and experienced working experts with hands on constant different Tally ventures information. We have outlined our Tally course substance and syllabus in view of understudies necessity to accomplish everybody's vocation objective. In our Tally preparing program, you will learn Basics of Accounting, Types of Accounting in Tally, Process of Accounting, Accounting Transactions, Manual Accounting, Trading Account, Bank Reconciliation Statement, Cost Center and Cost Category, Interest Calculation, Multicurrency, Bill Wise Details, Inventory Introduction, Actual and Billed Quantity, Price List, bill of material, cluster shrewd subtle elements, Value Added Tax [vat], Tax Deducted Source [tds], Service Tax, Tax Collected Source [tcs], Printing Tally continuous undertaking and Tally situation preparing.

Our Tally preparing focuses are furnished with lab offices and fantastic framework. We likewise give Tally confirmation preparing way to our understudies in Chandkheda Ahmedabad we have prepared more than 200+ Tally understudies and gave situation at Samarth Computer Education. We are granted as the best Tally Training Institute in Chandkheda Our Tally course charge is an incentive for cash and tailor-made course expense in view of the every understudy's preparation prerequisites. Count preparing in chandkheda directed on day time classes, end of the week instructional courses, evening clump classes and quick track instructional courses.

Tally Trainer profile

· More than 12 Years of experience in Tally Technologies

· Has worked on many real time Tally projects

· Trained 200+ Students so far.

· Strong Theoretical & Practical Knowledge

· Tally certified Professionals

Tally Training Chandkheda Benefits

· Real Time Trainers

· Small Training Batch

· Flexible Timings

· Practical Guidance

· Excellent Lab Facility

· Tally Resume Preparation

· Hands on Experience

· Tally Certification Support

· Video Tutorials will be provided

Email Us:-samarthcompedu@gmail.com

Contact Us:-9898550168