Excel
Many data scientists view Excel as a secret weapon. It is a familiar tool that scientists can rely on to quickly sort, filter, and work with their data. It’s also on nearly every computer you come across, so data scientists can work from just about anywhere with Excel.
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.
- Best Python Training Institute and Python Course in Dehradun
- Best Data Science Training Institute and Data Science Course in Dehradun
Key Features:
- Named ranges for creating a makeshift database
- Sorting and filtering with one click to quickly and easily explore your dataset
- Use Advanced Filtering to filter your dataset based on criteria you specify in a different range
- Use pivot tables to cross-tabulate data and calculate counts, sums, and other metrics
- Visual Basic provides a variety of creative solutions