SumProduct - One of the interesting and advanced formulas in Excel

SumProduct Excel Formula

Formulas are the important core in Excel application. So, learning multiple Excel formulas can save a lot of time when we work in Excel for consolidating, combining reports.

Here in this article, we are going to see an interesting excel formula which is SumProduct. The name of this formula looks like a simple sum, but it has many advanced feature and tricks. The following link will take you to a YouTube page where you can watch the entire benefits of this formula. Handling of this formula is little tricky, so i recommend you to watch the entire series of videos to get familiar in this formula.

Click here to launch the video playlist

PrabasTech.in

Learn HLOOKUP in Excel - The basic comparison between HLOOKUP and VLOOKUP

Beautify or Format an Excel Chart - Tamil

It is important to know the ways we can format or beautify Microsoft Excel charts. Formatting an Excel is a necessary step before we present charts to the final presentation. As we discussed already charts are playing a very important role in all presentations.  The numbers need to be converted and presented as chart for all the meetings to to get more attention from the audience.


Watch out the following video to know about the ways of formatting or beautifying an Excel Chart

Basic Interface of Microsoft Word

Understand the Interface of Microsoft Word

In this video, we have explained about the Basic Interface of Microsoft Word 2016.  The followings are explained in this video, Title bar, Quick Access Toolbar, Close, Restore, Minimize, Tabs, Ribbon, Groups, Comments, Ruler, Status Bar and Working Area.

Prabakaran V 
Trainer and Senior Presentation Specialist

Cell: +91 9940261814

Email:  prabas.msoffice@gmail.com

How to open Microsoft Word - Tamil

How to Open Microsoft Word 2016 / 2013 / 2010

How to open Microsoft Word, Types of opening Microsoft Word. Different ways of open Microsoft Word Application and open the Doc / Docx files.

Prabakaran V  
Trainer and Senior Presentation Specialist 

Cell: +91 9940261814

Email:  prabas.msoffice@gmail.com

Overview of Microsoft Office

We are going to publish more videos on Microsoft Office in all concepts. Stay with us. 

Overview of Microsoft Office

This video is about the History, Benefits and Overview of Microsoft Office.  We are planning to publish more videos on all concept. Boost your career with Advanced Microsoft Training.

Prabakaran V 

Trainer and Senior Presentation Specialist

Cell: +91 9940261814 / +91 9789810270

Email:  prabas.msoffice@gmail.com

Advanced Level Microsoft Office Training (Online / Offline)

Want to learn MS Office at home from an Industry Standard Trainer and from an Expert.  Finding an Online Training from a Certified Experts.  Looking for More Scenario based Practicals.  Want to join a job with MS Office Skill.  Want to know the basics of MS Office.  Want to get placed in Documentation level BPOs. 

We provide Advisory, Support, Training for all levels.

1) Online Teaching

2) Personal MS OFFICE Course

3) Advance MS Office

4) Short Term MS OFFICE Course

5) Job Assurance MS OFFICE

6) Individual MS OFFICE

7) Advanced MS Word

8) Advance MS Excel

9) Advance MS PowerPoint

10) Basic Knowledge in MS Office

Microsoft Office is a commonly used software in almost all the industries.  From small-scale industry to the large-scale, it is an important application to improve the productivity of Reports, Presentation and Data Analytical capability of an Individual / Organization.  We provide the following services to the end users based on their needs and requirements.

Advisory – We Analyse and Recommend the preferred level of training to the users that will help us to focus the gaps and fulfil the needs of the user’s expectation.

Training – We provide Advanced Level & Industry Standard training to the end users which will help them to get placed in big companies.  We provide online / offline training from 2003.

Workshop Session: We conduct efficient technical workshop sessions to the users that will help them to understand the concepts and relate it to their business tasks and activities.

We cover all the major topics listed below, 

Microsoft Word

2003, 2007, 2010, 2013, 2016, Office 365 (doc, docx)

Page Setup, Printing, Working with Styles, Creating, Modifying Table of Contents, Working with Section Breaks, Creating Templates, Formatting Document, Inserting Objects (Power Point Slides, Excel Tables / Charts), Tables (Creating, Formatting), Page Layout In-depth, Working with Header, Footer, Editing Color Palettes, Compare the documents, Footnotes / End-notes, Hyperlinks, Main Merge, Working with Drawing Toolbar, Field Codes, Mail Merge, Keyboard Shortcuts, Special Characters, Symbols, Password Protection, Macros

Microsoft PowerPoint

2003, 2007, 2010, 2013, 2016, Office 365 (ppt, pptx)

Working with Templates, Creating and Editing Templates, Converting Power Point Presentation to different Template, Working with Drawing Toolbar, Creating Slide Design, Embedded Chart, Formatting Power Point Presentation, Advance Custom Animation, Inserting Objects (Excel Tables / Charts), Page Setup, Creating Organization Charts, Auto Shapes, Others

Microsoft Word

2003, 2007, 2010, 2013, 2016, Office 365 (xls, xlsx)

Copying, Cutting, Pasting data, Saving, Formatting, Styles; Auto Formats, Finding, Replacing Data, Numbers, Dates, Pivot Table, Boarders, Shading, Sorting, Filtering, Formatting, Pivot Chart, Conditional Formatting, Protection, Password, Sharing Methods, Validation, Macros, Etc.  Charts:  Column Chart, Line Chart, Pie Chart, Bar Chart, Area Chart, XY Scatter, Combination Chart, Bubble Chart, Share Price Chart, Floating Chart, Snake Chart, Water Fall Chart, Bubble with Pie Chart, Advance Level Charts: High Low Lines, Trend Line, Etc. Basic Functions:  IF Related Functions, Lookup, Reference Functions, VLOOKUP, HLOOKUP, Is Error, If with Vlookup, If with AVG, Countif, Sumif, Median, Countblank, Math Functions, Concatenate, Auto Calculate, Maximum, Minimum, Absolute referencing, Others. Text Related Function:  Proper, Upper, Lower, Replace, Substitute, Length, Trim, Time Related Function, Others

Important: 
Some companies are in Chennai providing jobs who has excellent knowledge in Microsoft Office. Our training will definitely help you to achieve your ambition.

RR Donnelley Global India Outsource Pvt Ltd

https://www.rrdonnelley.com/

Knowledge is Microsoft Office is must to get placed here.

McKinsey & Company

http://www.mckinsey.com/knowledge-network/chennai

Previous experience is must to get placed here

Amplexor

http://www.amplexor.com/

Good knowledge is Microsoft Office is must to get placed here.

Keep in Touch: We are going to publish more videos about tricks and trips in MS Office, stray there and support us. 

Prabakaran V 

Trainer and Senior Presentation Specialist

Cell: +91 9940261814

Email:  prabas.msoffice@gmail.com

Keywords: Ms-Office, Microsoft Office, MS Office Course, Advance MS Office Ms Word, Ms Excel, Ms PowerPoint, Online Class, Learn from Home, Office 2003 & 2007, Ms-Office, Ms Word, Ms Power point, Ms Excel, Templates, Projects, Reports, Clip Arts, Graphs, Charts, Advanced Ms office, Personal Training, Home Tuition, Computer Classes, Tables, worksheets, organisation charts, bar chart, pie chart, MS Office, Excel, Word, PowerPoint, Basic Computer Knowledge from home, MS Office Training from a Certified Training, MS Office Training from an Expert, Advanced MS Office, Advanced Excel, Advanced PPT, Advance Word, Office 2003, Office 2007, Office 2010, Office 2013, Office 2016, Office 365, Doc, Docx, PPT, PPTx, XLS, XLSx