A better platform to learn MS office, digital marketing, web development, graphic designing, English grammar and standard educational classes for all subjects.
Sometimes, About excel seems too good to be true.
All I have to do is enter a formula, and pretty much anything I'd ever need to
do manually can be done automatically. Need to merge two sheets with similar
data? Excel can do it. Need to do simple math? Excel can do it. Need to combine the information in multiple cells? Excel can do it. Here we will learn much more about excel.
Best tips and tricks about Excel
If you experience a circumstance where you have to physically refresh your information, you're most likely passing up an excel that can do it for you. Before putting in a really long time checking cells or reordering information, search for a convenient solution on Excel - you'll likely discover one.
In the soul of
working all the more proficiently and staying away from dull, manual work, here
are a couple Excel traps to kick you off with how to utilize Excel.
How to use excel - (Step by Step)
If you
are just a beginner learning about excel
then there are a few basic tips mentioned here below:-
How
to create a spreadsheet from scratch
How
to do basic computations such as adding, subtracting, multiplying, and diving into
spreadsheets.
How
to delete single columns, rows etc.
How
to add things like new columns and rows.
Create
a Spreadsheet:- About Excel
1.First
we have to open a spreadsheet.
2.Now
look at the top in the left corner there are rows and columns A1 and B1.
3.If
you notice then every column has a capital letter to show what column it is.
4.Each
row has a number to show what row it is.
5.Now
we can type something in cell A1 or B1 such as anything.
For Example:-
Ms Excel
Now you see here Column A cell has item
and B1 has cost like this we can create any data here by using these cells.
Basic
Computation like adding and subtracting etc. – About Excel
1.Add
– it is like adding numbers all together like it may be sum or count in excel.
Microsoft Excel
1.Subtracting
– It is like a number has to be deducted from another number in excel.
Microsoft Excel
That’s how we got this value after subtracting here.
Delete
columns – About Excel
1. To delete any column, we have to select the column and press the right click
from the mouse and click the delete button which is shown in the small dialogue box.
2.Either
we can delete the column by using the keyboard as well, Press CTRL+(-):- Select the column and press these keys altogether and
will be deleted.
Microsoft Excel
3.In
the same way rows also can be deleted anyway.
Adding new columns and rows –
About Excel
1.For
Adding new columns and rows, put the cursor where we want to add a new column or
row and press right-click from the mouse and it will give us the INSERT button to add a new column or row.
That s how we can easily do it.
2Another way also there to add new columns
and rows, through the keyboard, it can be done too. Press CTRL+(+) altogether for adding a new column or row in excel.
When we talk about basics or advanced of Ms excel then there are a few functions which could be added here from base to top means from basics to advanced like Vlook-up, Pivot-Table, Conditional Formatting, Data Validation, Left & Right function, Sum, Sumif, Sumifs functions, Count, Count, Countif.
Vlookup is basically used for finding a value in any data or huge data vertically. This is the most important function or feature of ms excel that we of course need to learn.
In the same way, we use Hlookup also to find values in any data in excel Horizontally.
The functions we are talking about here are the best features of ms excel which make users like magicians work in excel, Users can easily play with any huge data if he or they know better about at least these functions to use as mentioned above.
Dashboard in excel is an interesting feature which could be used to summarize any huge data in excel.
All we need to do is go through from the basics to advanced ones to be an expert in excel.
This privacy policy has been compiled to better serve those who are concerned with how their ‘Personally Identifiable Information’ (PII) is being used online. PII, as described in US privacy law and information security, is information that can be used on its own or with other information to identify, contact, or locate a single person, or to identify an individual in context. Please read our privacy policy carefully to get a clear understanding of how we collect, use, protect or otherwise handle your Personally Identifiable Information in accordance with our website.
What personal information do we collect from the people that visit our blog, website or app?
When ordering or registering on our site, as appropriate, you may be asked to enter your name, email address or other details to help you with your experience.
When do we collect information?
We collect information from you when you subscribe to a newsletter or enter information on our site.
How do we use your information?
We may use the information we collect from you when you register, make a purchase, sign up for our newsletter, respond to a survey or marketing communication, surf the website, or use certain other site features in the following ways:
• To improve our website in order to better serve you.
• To allow us to better service you in responding to your customer service requests.
How do we protect your information?
We do not use vulnerability scanning or scanning to PCI standards.
We only provide articles and information. We never ask for credit card numbers.
We do not use Malware Scanning.
Your personal information is contained behind secured networks and is only accessible by a limited number of persons who have special access rights to such systems, and are required to keep the information confidential. In addition, all sensitive/credit information you supply is encrypted via Secure Socket Layer (SSL) technology.
We implement a variety of security measures when a user enters, submits, or accesses their information to maintain the safety of your personal information.
All transactions are processed through a gateway provider and are not stored or processed on our servers.
Do we use ‘cookies’?
We use cookies for tracking purposes
You can choose to have your computer warn you each time a cookie is being sent, or you can choose to turn off all cookies. You do this through your browser settings. Since browser is a little different, look at your browser’s Help Menu to learn the correct way to modify your cookies.
If you turn cookies off, Some of the features that make your site experience more efficient may not function properly. That make your site experience more efficient and may not function properly.
Third-party disclosure
We do not sell, trade, or otherwise transfer to outside parties your Personally Identifiable Information.
Third-party links
Occasionally, at our discretion, we may include or offer third-party products or services on our website. These third-party sites have separate and independent privacy policies. We therefore have no responsibility or liability for the content and activities of these linked sites. Nonetheless, we seek to protect the integrity of our site and welcome any feedback about these sites.
Google
Google’s advertising requirements can be summed up by Google’s Advertising Principles. They are put in place to provide a positive experience for users. https://support.google.com/adwordspolicy/answer/1316548?hl=en
We use Google AdSense Advertising on our website.
Google, as a third-party vendor, uses cookies to serve ads on our site. Google’s use of the DART cookie enables it to serve ads to our users based on previous visits to our site and other sites on the Internet. Users may opt-out of the use of the DART cookie by visiting the Google Ad and Content Network privacy policy.
We have implemented the following:
• Remarketing with Google AdSense
• Google Display Network Impression Reporting
• Demographics and Interests Reporting
• DoubleClick Platform Integration
We, along with third-party vendors such as Google use first-party cookies (such as the Google Analytics cookies) and third-party cookies (such as the DoubleClick cookie) or other third-party identifiers together to compile data regarding user interactions with ad impressions and other ad service functions as they relate to our website.
Opting out:
Users can set preferences for how Google advertises to you using the Google Ad Settings page. Alternatively, you can opt out by visiting the Network Advertising Initiative Opt Out page or by using the Google Analytics Opt Out Browser add on.
COPPA (Children Online Privacy Protection Act)
When it comes to the collection of personal information from children under the age of 13 years old, the Children’s Online Privacy Protection Act (COPPA) puts parents in control. The Federal Trade Commission, United States’ consumer protection agency, enforces the COPPA Rule, which spells out what operators of websites and online services must do to protect children’s privacy and safety online.
We market to
We do not collect information from children under 13
Children under 13.
Do we let third-parties, including ad networks or plug-ins collect PII from children under 13?
No
In order to remove your child’s information please contact the following personnel:
We adhere to the following COPPA tenants:
• Parents can review, delete, manage or refuse with whom their child’s information is shared through contacting us directly.
or contacting us directly.
Fair Information Practices:-
The Fair Information Practices Principles form the backbone of privacy law in the United States and the concepts they include have played a significant role in the development of data protection laws around the globe. Understanding the Fair Information Practice Principles and how they should be implemented is critical to comply with the various privacy laws that protect personal information.
In order to be in line with Fair Information Practices we will take the following responsive action, should a data breach occur:
We will notify you via email
• Other
when any new update
We will notify the users via in-site notification
• Other
when any new update
We also agree to the Individual Redress Principle which requires that individuals have the right to legally pursue enforceable rights against data collectors and processors who fail to adhere to the law. This principle requires not only that individuals have enforceable rights against data users, but also that individuals have recourse to courts or government agencies to investigate and/or prosecute non-compliance by data processors.
CAN SPAM ACT
The CAN-SPAM Act is a law that sets the rules for commercial email, establishes requirements for commercial messages, gives recipients the right to have emails stopped from being sent to them, and spells out tough penalties for violations.
We collect your email address in order to:
• Send information; respond to inquiries, and/or other requests or questions
To be in accordance with CANSPAM, we agree to the following:
• Not use false or misleading subjects or email addresses.
• Identify the message as an advertisement in some reasonable way.
• Honour opt-out/unsubscribe requests quickly.
• Allow users to unsubscribe by using the link at the bottom of each email.
If at any time you would like to unsubscribe from receiving future emails, you can email us at
Amit@audicitechnologies.comand we will promptly remove you from all correspondence.
All the information on this website is published in good faith and for general information purpose only. https://www.mytechplans.comdoes not make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information you find on this website (https://www.mytechplans.com), is strictly at your own risk. https://www.mytechplans.comwill not be liable for any losses and/or damages in connection with the use of our website.
From our website, you can visit other websites by following hyperlinks to such external sites. While we strive to provide only quality links to useful and ethical websites, we have no control over the content and nature of these sites. These links to other websites do not imply a recommendation for all the content found on these sites. Site owners and content may change without notice and may occur before we have the opportunity to remove a link which may have gone ‘bad’.
Please be also aware that when you leave our website, other sites may have different privacy policies and terms which are beyond our control. Please be sure to check the Privacy Policies of these sites as well as their “Terms of Service” before engaging in any business or uploading any information.
Consent
By using our website, you hereby consent to our disclaimer and agree to its terms.
Update
This site disclaimer was last updated on: 26 May 2019. Should we update, amend or make any changes to this document, those changes will be prominently posted here.