Online Education

12/11/2020

Dear All, Recently i opened a small Software Company. Our Company work on WebSite and Web Application(Static & Dynamic), as well as Android(Hybrid & Native) Application. In you and your Contact required to Freelance the project or work. please contact to us.

In SNG Technologies, we have a dedicated and skilled team of developers and designers who has a wide experience in this field. We believe to enhance the satisfaction of our clients by providing best in class services and deliver their project on given time period. Technology has the power to transfo...

31/12/2018

Happy New Year All my friends. Alwida 2018 and Welcome 2019

10/03/2018

Also You contact with us whatsUp No.
+91-9958976908

How to Calculate Actual Year , Month and Days in Between Two dates.

03/03/2018

https://youtu.be/byx95pXQl3M

how to change excel data in lower, how to change excel data in upper, how to change excel data in proper case.

11/04/2017

Dear All,
Today I am Sharing with you a very Interesting and Good Example in Excel.

Q. How to Seperate String and Number in Excel Cell which are merged in single cell. We have two Solution first using Text to Column(In Case Number first then Name otherwise use second solution) and Second i am sharing with you.

also i am sharing with you Example.

Example:-
A1
neeraj kumar9958976908
Shasi kumar2323586383
Anil Goyal23286383
Shwati Aggarwal439709847463

How to do this. like that.....
C1 D1
neeraj kumar 9958976908
Shasi kumar 2323586383
Anil Goyal 23286383
Shwati Aggarwal 439709847463

A. Follow this step:-
A1 Column = Your All the values/Entry.
B1 column type is formula and copy paste. = =MIN(FIND({0,1,2,3,4,5,6,7,8,9},A2&"0123456789"))
C1 column type is formula and copy paste. = =LEFT(A2,B2-1)
D1 column type is formula and copy paste. = =RIGHT(A2,LEN(A2)-B2+1)

finally get all the values(copy,PasteSpecial and Values). and delete the B1 Column.
Regading any query post here.

I Hope you Understand.....

27/03/2017

Dear All,

Q. How to Find Total Days in Particular two Dates. Its very easy and Very Short.
A. A1 = 1/15/1988
A2 = 3/27/2017

=NETWORKDAYS(K9,K10)

Result = 7617

I hope you Understand. Is there any query post here...

Regards
Online Education Group

13/03/2017

होली के इस पावन पर्व पर
आपके सभी दुख दर्दो का
होली के साथ दहन हो।
आप सदैव स्वस्थ रहे एवं
आपके जीवन मे सतरंगी खुशियो की बहार हो ।
जीवन में आने वाली समस्याओं से तप कर आप और मजबूत ओर सशक्त बने।

होली की हार्दिक शुभकामनाएं
From
Online Education Group

25/02/2017

Very Good Morning to Dear All,

Q. How to find Excel or any kind of Software of Shortcut key.
A. Open Excel then Press Alt, now you can see the top of Menu bar show the lots of Character key on header. then press one key which you are seen, again see lots of character that is called the Shortcut key of Excel. this process you can try any kind of Desktop Application.

I hope you Understand......

Regards
Online Education Group

22/02/2017

Dear All,
Thanks for the Supporting My Online Education Work. Right now We Start the WhatsApp Group to Better Facility and helping to you directly P2P Connection. If You are agreed to Send you number On my(9958976908) Whatsapp No.

Regards
Online Education Group....

02/01/2017

Good Morning Dear All Friends.
Q. How we can make dash board in ms excel with changing flags
A. Dear All, I am sharing with you some Tutorial of DashBoard, Firstly tell you one thing Understand name of DashBoard, basically this is the Part of Pivot Table. How to Customise or Present the data in Tabular form. Now i am sharing with you Some example.
http://www.launchexcel.com/excel-drop-down-for-dashboards/
https://www.youtube.com/watch?v=gBNdlBcNyjI

i hope you understand very well.

Are you looking for ways to make your Excel spreadsheets interactive but you don’t want to use VBA? For instance, what if you want to create a simple Excel dashboard where you make selections…

26/12/2016

Good Morning Dear All,
Shorkut key of Column and Row insert in Excel.
Column Insert.
Alt+I+C
Row Insert
Alt+I+R

I Hope you Understand....

21/12/2016

Dear All,
Thanks for Appreciating My work.
Q. Shortkut Key of Format shell.
Ctrl+Shift+p and Ctrl+Shift+f;
Q. Close Current Excel Sheet.
Ctrl+w;

I hope you understand...