Knowing Basic Excel formulas and functions with examples

The basics of Excel formulas

Before providing the basic Excel formulas list, let’s define the key terms just to make sure we are on the same page. So, what do we call an Excel formula and Excel function?

  • Formula is an expression that calculates the value of a cell.For example, =A2+A2+A3+A4 is a formula that adds up the values in cells A2 to A4.
  • Function is a predefined formula already available in Excel. Functions perform specific calculations in a particular order based on the specified values, called arguments, or parameters.

Best Excel Formulas & Functions: You Need to Know

What is a formula?

It is the simplest form, a formula is an expression made up of cell addresses and arithmetic operators. Formulas can also be made up of discrete values i.e. =6*3. Excel evaluates the formula to a value. An example of a formula looks as follows.

=A2 * D2 / 2

Excel shortcuts Keys for Windows

Shortcut                     Description
Tab                                  Move to the next cell, to the right of the currently selected cell.
Ctrl+A                            Select all contents of a worksheet.
Ctrl+B                            Bold all cells in the highlighted section.
Ctrl+C                            Copy all cells in the highlighted section.
Ctrl+D                            Fill down. Fills the cell beneath with the contents of the selected cell. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select multiple cells. Then press Ctrl+D to fill them with the contents of the original cell.

How to become an iOS developer: A cheat sheet

If you are interested in pursuing a career in mobile development and don’t know where to start, here’s your go-to guide for salaries, skills, and the best programming languages to learn.

As more companies adopt a mobile-first approach, iOS developers who build apps for Apple devices are in high demand, with talent shortages leading to large salaries for many of those in the field. Developers who know the necessary programming languages and other skills can create apps that enterprises and consumers use every day to make their lives more productive.

The signs indicates that – You are in Wrong Job

 

It’s all too easy to lose yourself in your daily tasks at work and ignore the larger question of whether or not you should be doing them in the first place. But the warning signs you’re in the wrong job could be creeping all around you: maybe your role has subtly shifted into something you no longer recognize, maybe your relationship with the boss isn’t what it used to be, or maybe you’ve taken on four roles when you’re only being compensated for only one. Whatever the case, here are the 20 biggest red flags that are screaming for you to throw in the towel immediately.

Best Job Interview Tips for Job-Seekers

Best Job Interview Tips” Job Interview is the most important thing for a job seeker. If you go for an interview you must be well prepared for this because you don’t get a second chance to make a great first impression. Here we provide some strategies to improve your interview skills:

Top 10 Job Interview Tips

  1. Be punctual for a job interview. An employer knows that if you can’t show up on time for a job interview, you can’t do it for work either.
  2. Prepare in advance even if you think you don’t require any preparation. The preparation you did for previous job interviews can’t be an excuse for not preparing for the one you are about to attend today

Personal Etiquette Tips

A first impression is essential for professional and personal success. Its often the only opportunity you have to sell yourself to a potential employer or business partner. Your personal etiquette represents how you feel about yourself and the outside world.

Interview Questions and Best Answers

It’s important to be prepared to respond effectively to the interview questions that employers typically ask at job interviews. Since these questions are so common, hiring managers will expect you to be able to answer them smoothly and without hesitation.

How To Download HD YouTube Videos On Android with KeepVid

video when you have time as opposed to in the middle of the work day. The download feature lets you save a video offline and view it when you don’t have internet. Between these two features, there is still a need to download videos from YouTube. It goes without saying that YouTube doesn’t have a download option. There are however plenty of apps on just about every platform that let you download videos from YouTube. The same holds true for Android. You’re spoiled for choice when it comes to downloading videos from YouTube and it’s hard to decide which app is the best. KeepVid is a