- Microsoft Excel, the spreadsheet app, lets you create, view, edit, and share your files quickly and easily. Manage spreadsheets, tables and workbooks attached to email messages from your phone with this powerful productivity app. Work in data analysis, accounting, auditing, or other fields confid.
- Essential Excel Functions. There are a few functions that most people couldn't do without.
Microsoft Office is a set of interrelated desktop applications, servers and services, collectively referred to as an office suite, for the Microsoft Windows and macOS operating systems.
Microsoft Excel is one of the most popular program with over a billion users. It is being used for creating charts, tables, reports, identifying trends, and arranging data, etc. Though, it comes with some brilliant functions that enhances productivity and after learning some useful tricks anyone can master Microsoft Excel, it has its own.
This list contains all the programs that are, or have been, in Microsoft Office since it has been started.
Office 365 Applications[edit]
Product Name | Release Date | Desktop | Online Service | Mobile 2btc to usd. App |
---|---|---|---|---|
Access | November 1992 | Yes | No | No |
Excel | 1987 | Yes | Yes | Yes |
OneNote | November 19, 2003 | Yes | Yes | Yes |
Outlook | January 16, 1997 | Yes | Yes | Yes |
PowerPoint | May 22, 1990 | Yes | Yes | Yes |
Power BI | July 11, 2012 | Yes | Yes | Yes |
Project | 1984 | Yes | No | No |
Publisher | 1991 | Yes | No | No |
Visio | 1992 | Yes | Yes | Yes [1] |
OneDrive for Business | Yes | Yes | Yes | |
Sway | 2014 | Yes | Yes | No |
Word | October 25, 1983 | Yes | Yes | Yes |
Forms | June 20, 2016 | No | Yes | No |
Bookings | July 20, 2016 | No | Yes | Yes |
Classroom | April 14, 2016 | No | Yes | No |
Docs.com | April 21, 2010 | No | Yes | No |
Delve | March 2015 | No | Yes | Yes |
GroupMe | May 2010 | No | Yes | Yes |
MyAnalytics | May 15, 2019 | No | Yes | No |
Office Online | June 7, 2010 | No | Yes | No |
OneDrive | August 1, 2007 | Yes | Yes | Yes |
Outlook.com | July 4, 1996 | No | Yes | No |
Planner | June 6, 2016 | No | Yes | Yes |
Microsoft PowerApps | October 2016 | No | Yes | Yes |
Microsoft Stream | June 20, 2017 | No | Yes | No |
Microsoft Teams | November 2, 2016 | Yes | Yes | Yes |
SharePoint | March 28, 2001 | Yes | Yes | Yes |
Microsoft To-Do | April 2017 | Yes | Yes | Yes |
Skype | August 29, 2003 | Yes | Yes | Yes |
Yammer | March 10, 2008 | Yes | Yes | Yes |
Fluid Framework | TBA | TBA | TBA | TBA |
Project Cortex | TBA | TBA | TBA | TBA |
Server applications[edit]
Name | Release Date |
---|---|
Microsoft Exchange Server | April 11, 1996 1997 |
Microsoft Project Server | 2000 |
Office Web Apps Server | |
SharePoint | March 28, 2001 2010 https://btpm.over-blog.com/2021/01/ip-web-camera-recording-software.html. November 19, 2003 |
Skype for Business Server | December 29, 2003 |
Discontinued programs[edit]
Name | Release Date | Discontinued |
---|---|---|
Microsoft Binder | August 24, 1995 | August 19, 2003 |
Microsoft Clip Organizer | ||
Microsoft Data Analyzer | ||
Microsoft Entourage | ||
Microsoft Equation Editor | ||
Microsoft Exchange Client | ||
Microsoft FrontPage | ||
Gigjam Preview | ||
Microsoft InfoPath | ||
Microsoft InterConnect | ||
Microsoft Mail | ||
Microsoft MapPoint | ||
Microsoft Mathematics (formerly Microsoft Math) | ||
Microsoft Office Accounting | ||
Microsoft Office Document Imaging | ||
Microsoft Office Document Scanning | ||
Microsoft Office Live | ||
Microsoft Office Live Meeting | ||
Microsoft Office PerformancePoint Server | ||
Microsoft Office Picture Manager | ||
Microsoft Office Project Portfolio Server | ||
Microsoft Outlook Hotmail Connector | ||
Microsoft PhotoDraw | ||
Microsoft Photo Editor | ||
Microsoft Schedule+ | ||
Microsoft Search Server | ||
Microsoft SharePoint Designer | ||
Microsoft SharePoint Foundation | ||
Microsoft SharePoint Workspace (formerly Microsoft Office Groove) | ||
Microsoft Vizact | ||
Office Assistant | ||
Office Web Components |
See also[edit]
- Microsoft Education Edition
References[edit]
External links[edit]
Microsoft Excel is a spreadsheet program included in the Microsoft Office Suite of applications. Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. Microsoft Excel performs all basic functions of a spreadsheet. It can present columnar data quickly and easily. Also, it eliminates the need for doing time-consuming calculations.
Open in pdf format. It can be used to create a worksheet which once created can be edited. Rows and columns in a worksheet can be altered with the results getting automatically recalculated. There are many uses of MS Excel, for example, it helps in building great charts, conditional formatting, identifying trends, bringing data together, etc.
Starting MS Excel
Microsoft Excel can be started by two methods. Depending on your computer setup you can choose any one of them.
Method 1
- Start Windows
- If the desktop displays the Excel icon, double-click on it
- Maximize the Excel window, if it is not on the full screen
Method 2
- Start Windows and click on the Start button to access the Start menu.
- Point to Programs.
- Move onto the Microsoft Excel in the programs menu and click on it to start Excel.
- Maximize the Excel window on the screen.
If your computer has the complete Microsoft office package installed in it, the option for MS Excel may lie in the Microsoft Office Program Group. In such a case, move the pointer to this group icon in the programs menu. A submenu will appear showing Microsoft word, Microsoft Excel, Microsoft PowerPoint, etc. Click on the Microsoft Excel option to start the program and then maximize the window.
Types of Data that can be entered in MS Excel
In MS Excel when data is entered, it directly goes into cells. The cells can contain formulae or constant values, which can be 225 characters long. These values can be text, numbers, dates and logical (true or false) values. Following are the different types of data that can be entered in a spreadsheet using MS Excel:
- Text: The text data can contain alphabetic characters, numbers or special characters or a combination of these. Examples of text data are: Sonia, B48, Airbus300, etc.
- Numbers: This kind of data can include numbers (0-9), exponent symbols, decimal points or plus or minus sign. For example, 50%, +, – etc.
- Dates: This type of data is used to enter any date which contains numbers and a slash sign in the form of mm/dd/yy.
- Formulae: Any formulae written in excel is used for calculations. All the formulae must start with an ‘=' sign; otherwise, it will be considered as a text or a number entry. While writing a formula the address of the cells to be calculated is required to be given along with mathematical signs required for calculations. For example, to add the contents of cells, B1, B2 and B3, the formula would be, = B1+B2+B3.
Features of MS Excel
Following are some interesting features of MS Excel: Where to get ms paint.
What Is Microsoft Excel
- One of the most important features of MS Excel is the pivot table. It helps you in creating complex reports, charts and calculations. Therefore, it saves a lot of time and that is why people are in love with this feature of MS Excel.
- Another important feature of MS Excel is the lookup formulas. It is very useful as it helps you in locating information in your workbook based on the input criteria. If you know how to write the lookup formulas, then you can build dashboards, makes interactive charts, and creative effective models.
- Next is Excel charts. This feature is also very useful and has its own importance. It is sometimes hard to work with Excel charts but then it helps you to communicate insights and information with ease.
- Conditional formatting is one of the useful features of MS Excel; it can be used to make the workbook look more interesting with the help of its new features data bars, color scales, and icon sets.
- The most important feature of MS Excel is power pivot because it turns out to be very helpful to excel when it struggles in analyzing certain types of data.
- One of the unique features of MS Excel is visual basic applications. Visual basic applications are a language that excel speaks so if a person learns this language then it can make excel do a lot of things easily, like automatic emailing and generating monthly reports.
MS Excel saves a lot of time for the people and it makes it easy for the people to analyze data. It is useful in a lot of ways, like helping make a boring workbook all the more interesting, communicating insights and information, building dashboards and making interactive charts, creating effective models, among others. It has the ability to do automatic calculations and therefore, it is often used in accounting and finance.
What Kind Of Program Is Ms Excel Function
Excel tables are one of the most important and useful features of MS Excel, as it is used for administrative as well as other purposes. People love using this feature because it saves a lot of time of the people. Excel charts are also very useful. For example, one can make charts of his or her income statement and then they can see it anytime. This will help them in knowing that how much they have spent and how much of the income is left. In this way, their time will also get saved.