Posted on by

panel_start Microsoft Excel panel_end

Microsoft Excel is Microsoft’s latest version of its very popular business productivity application for the management and manipulation of data. With the right training and understanding of Excel, businesses and individual users can unlock the world of opportunities that this powerful business application offers.

Topics to be Covered:

  • Customizing the Quick Access Toolbar
  • Creating and Using Templates
  • Manipulating Data using Data Names and Ranges, Filters and Sort, and Validation Lists
  • Using and Formatting Tables
  •  Formulas and Use of Functions
Function writing (Syntax & Arguments)
Popular functions in Excel and its uses
Sorting
Excel Shortcuts
Conditional & Logical Functions
  • Lookup Functionality
Vlookup
Hlookup
Lookup
Various Calculation Modes and How to use them
Formula Errors and how to handle them
  • Charts and Graphs
Type of Charts
Parts of Charts
How to create Charts
  • Pivot Table
Intro of Pivot Table
Creating Pivot Table
Formatting of Pivot Table
Pivot Charts

Data Validation

Uses of Data Validation
Using drop-down box to validate
Dependent drop-down List
Using Formulas
  • Conditional Formatting
Quickly Identify Duplicates using Conditional Formatting
Highlight Cells with Value Greater/Less than a Number in a Dataset
Highlighting Top/Bottom 10 values in a Dataset
Highlighting Errors/Blanks using Conditional Formatting
Search and Highlight using Conditional Formatting

Extra Functions

Group, Ungroup and Subtotal
Convert Numbers Stored as Text into Numbers
Change Text to Lower/Upper/Proper Case
Data Using Text to Column
Consolidate

panel_start Microsoft Powerpoint panel_end

The purpose of this section of this course is to help you understand what PowerPoint can do for you, One of the most noticeable changes is the new user interface called the Microsoft Office Fluent which allows for the creation of dynamic, professional presentations in a much shorter period of time than earlier versions of PowerPoint. The Fluent interface has all commands, toolbars and task panes categorized into tabs and related groups.

Among the many new options offered by PowerPoint  are new themes and quick styles, custom slide layouts, Smart Art graphics, more advanced graphic effects for text, pictures, objects, charts, graphs and tables, more effective proofing tools, user-friendly collaboration and permission features, and much more. This course will walk you through PowerPoint , beginning with the basics and lead you through to some of the most advanced features available, offering additional helpful tips and hints along the way.

  • Working with Themes and Styles
  • Shortcuts & Tricks
  • Create symmetrically aligned duplicates
  • Group and UnGroup objects
  • Ungrouping a smart-art and using its components individually
  • Drawing straight lines, perfect circle and 90% squares
  • creating flow charts
  • use of red dotted lines
  • Converting text and pictures into smart art.
  • Creating translosent shapes
  • Use of soft edges on a picture
  • Table features
  • Understanding different aspects of a Table
  • Highlighting specific table information
  • Creating comparison tables
  • Creating footnotes for lengthy explanations

•            Working with Charts, Graphs, & Tables

  • Understanding different aspects of a chart
  • understanding combo chart
  • Secondary Axis

•            Object Animations

  • Understanding all types of animations effects.
  • Breaking objects and apply multiple effects on the same

panel_start Microsoft Word panel_end

It doesn’t matter if you’re new to MS Word or an experienced user, this comprehensive course teaches the most basic features as well as focuses on the more advanced tools that you will find useful.  Additionally, this course introduces new features exclusive to MS Word, as well as includes detailed instructions on how to use them. You’ll learn your way around the toolbars and menus, basic editing features, how to insert items into a document, how to create and edit tables to use the same .

  • Basic Editing
  • Formatting
  • Copying and Moving Text and Object
  • Editing Features
  • Paragraph Formatting
  • Tables
  • Lists
  • Page Formatting
  • Inserting Graphics, Pictures, and Table of Contents
  • Advanced Tools

http://princetonacademy.in/resource

https://www.microsoft.com/en-in

panel_start How to Register panel_end

  • Fees: Rs. 3,500/- + 18% GST Per Person 
  • Please write to register@princetonacademy.co.in
  • Call or WhatsApp on 9769963790 / 9769579090
  • Mention the name of participant, company, contact details.
  • You will Receive a Certificate of course completion
  • The course structure will be just like in the face to face workshops. 
  • All you need is an internet connection and a quiet, comfortable space for yourself.