Функции Excel.
-
Updated
Jul 19, 2018 - Shell
Функции Excel.
VBA functions to allow storage, retrieval and changing of an encrypted password within excel. Used in conjuction with excel's protect feature to design protected features or priviliges.
A Framework for Excel based reports to allow rapid & simple automation
This file contains advanced excel formulas and functions like Vlookup with match function, index and match function, offset & counta, logical operators, max if function, formula formatting, text functions, Date and time functions, data cleaning, etc. which I have worked on to take my excel skills at the high level.
This repository is for the beginners in ExcelSheet
Get NPV same as that of excel NPV calculations.
Sales analysis of the vrinda store for the better understanding of business and requirements.
A demonstration of refactoring Visual Basic for Applications (VBA) code to improve efficiency and performance within Microsoft Excel macros.
Used advanced Excel functions, created a pivot table and designed an interactive dashboard with custom formatting. Generated insights that Target women customer of age group (30-49) years living in Maharashtra, Karnataka and Uttar Pradesh by showing ads/offers/coupons available on Amazon, flipkart and Myntra.
Reference Repo - Coding Skills Practice
Excel is an important tool in the field of Data Science. It provides us with so many formulas and makes our time consuming and complicated calculations easy. So, here are some questions based on formulas like Sum, Sumif, Sumifs, Count, Countif, Countifs.
We all know the magic of Excel, hence, using this tool the most. Here are another few assignments with another important formulas of Excel called VOOKUP, IF, IFERROR, AND, OR, IFS and IFNA.
Excel has now become an important part of our professional as well as personal life because it can use easily and it provides many functions in one single tool. Here is another assignment based on very important, very interesting and very attractive feature i.e. Pivot Table and Pivot Charts.
Data Analysis of 200 trips of Travel Times Pvt. Ltd.
Data Analysis of Mandalle Restaurant with respect to different factors.
Prediction model for Delivery Time by Simple Linear Regression
Prediction model for Salary Hike by Simple Linear Regression
Add a description, image, and links to the excel-functions topic page so that developers can more easily learn about it.
To associate your repository with the excel-functions topic, visit your repo's landing page and select "manage topics."