### 12 Basic Excel Formulas & Functions To Supercharge Your Reporting Skills

Below are 12 basic functions and formulas that everyone should know.

I need to design a report tool in **Excel** sheet using Macros & **Formulas**. More details will be provided to selected candidate on private chat box. Max budget is $30.

$3 / hr
(Avg Bid)

Implementation of Q-Factor [Knowledge of RL (reinforcement learning) is necessary ]
6 days left

VERIFIED

...data (this thread is not active yet))
• I want to add some functions in existing code(That I will provide you), which is running well.
• I will also provide the function **formulas**.
Following implementation is required in Python
• Data traffic which will be two types. One Constant bitrate (i.e., 1Kb)and constant frequency (i.e., data packet send after

$372
(Avg Bid)

Excel Spreadsheet within programming and macros
6 days left

Advanced **Excel** Skills
Advanced **Formulas**.
Tables & Formatting.
Conditional Formatting.
Advanced Charting.
Pivot tables & Pivot Reporting.
VBA & Macros.
Using **Excel** Productively.
Data Tables, Simulations & Solver.
The spread sheet will be managed by an administrators and used by office staff with little to no **excel** experience.
Two levels of access

$1785
(Avg Bid)

...the “table 2: data” to calculate a critical value for each store.
I provide the answer of this critical value per store in a separate sheet using a conbination of different **formulas**, but the idea is to create just one for each store to use in one cell....

$21
(Avg Bid)

...individual sheets transposed and consolidated into an existing sheet in **Excel**. This can be achieved through copy and pasting or a simple macro but non-standard row positions make using macros a little challenging. Approximately 150 copy and pastes per sheet are required. Or can use **excel** **formulas** which dramatically reduces the need for copy pasting. It is very

$139
(Avg Bid)

We need this **excel** template tied to the mail merge document in word.
We’d like the word document to pull the clients name and any documents associated with their name, as well as account number, estimated delivery date, e-delivery and the type of document.
We need this ready by Monday. We just need the **formulas** and template ready with dummy data

$10 / hr
(Avg Bid)

i need help with this plugin Uni CPO – WooCommerce Options and Price Calculation **Formulas**. please dont contact me before you read the pdf file.

$31
(Avg Bid)

...data (this thread is not active yet))
• I want to add some functions in existing code(That I will provide you), which is running well.
• I will also provide the function **formulas**.
Following implementation is required in Python
• Data traffic which will be two types. One Constant bitrate (i.e., 1Kb)and constant frequency (i.e., data packet send after

$504
(Avg Bid)

I need an **excel** formula that i can use to calculate the areas of multiple arches for buildings in a construction project.
I will always have the radius and some dimensions. But I will never have the degrees if the arch.
see attached sketch for the dimensions I will have:
A. top width
B. bottom width may only have one of the dimensions as the angle of

$36
(Avg Bid)

Build simple excel & word mail merge template.
5 days left

We need this **excel** template tied to the mail merge document in word.
We’d like the word document to pull the clients name and any documents associated with their name, as well as account number, estimated delivery date, e-delivery and the type of document.
We need this ready by Monday. We just need the **formulas** and template ready with dummy data

$12 / hr
(Avg Bid)

Build simple excel & word mail merge template.
5 days left

We need this **excel** template tied to the mail merge document in word.
We’d like the word document to pull the clients name and any documents associated with their name, as well as account number, estimated delivery date, e-delivery and the type of document.
We need this ready by Monday. We just need the **formulas** and template ready with dummy data

$18 / hr
(Avg Bid)

...per the text that can be translated: elements such as **formulas**, tables, drawings will be just inserted in the new document as they are. Many of the pages contain such elements, so we expect to be charged only for the elements that can be translated (header of the table, words mentioned in **formulas** that have correspondent in German etc).
Last but not

$612
(Avg Bid)

Excel- holiday form- holiday allowance
4 days left

I need to create **formulas** for holiday allowance

$21
(Avg Bid)

I need to get an android app which will have some mathematical **formulas** like ROI calculation, discount calculation and some more.
Also it will have currency converter, Unit converter, calculator and scientific calculator.
I also want to have a banner on top with slider for changing photos for advertisement.
Also want google adsence or pay per click

$67
(Avg Bid)

I need a KPI Dashboard in Excel
3 days left

I am looking to hire a professional **Excel** Dashboard designer who can use my **excel** data and create a professional looking dashboard, I will need the job delivered in 3 days time upon the confirmation. I will need a full explanation of how the dashboard was done and any **formulas** used.
Looking forward to get your proposals and kick start the project

$208
(Avg Bid)

Excel- holiday form
3 days left

I need to create **formulas** for holiday requests from a set of data and sort by calendar year

$9 / hr
(Avg Bid)

business software for money exchange company
3 days left

i want a software which keeps the record of base currency and keep the stock of foreighn currency..it should manage ...amount in local [login to view URL] attaching an excell file on which we are already doing the same job...what i want is to convert this excell sheet into a form of software...all **formulas** which are to be used are already in the excell sheet.

$319
(Avg Bid)

Excel Formulas to Existing Report
2 days left

I have an existing **excel** document with raw data linking into a report (a range of graphs).
When I report each month ( add the new column of data for the new month), I have to go through each graph and re-select the new range and relevant fields.
I believe you can resolve this through defining names etc, however I don't have the time to set this all

$83
(Avg Bid)

We do epoxy flooring, and currently we use an **excel** spreadsheet to work out what it will cost to do the work. However as more people begin to use it, it becomes tricky as some of the **formulas** can be deleted, and you can't tell when another person is using it. This calculator essentially carries all the information over to another page called Proposal

$765
(Avg Bid)

Build a program to translate Autocad DXF file
2 days left

I need to get a program that will import and output an Autocad 3D DXF vector file and translate the X Y coordinates from a local grid to a UTM grid,...output an Autocad 3D DXF vector file and translate the X Y coordinates from a local grid to a UTM grid, and from a UTM grid to a local grid. I have the transformation **formulas** in an **excel** spreadsheet.

$530
(Avg Bid)

Build a Excel VBA
1 day left

I use **excel** to do the purchase order, and I want to make VBA to make the process easier.
I want to pre-defined some class and variations for each individual product, so the VBA will base on the product's class and variations to perform different calculations.
I have included an example **excel** sheet. It has the detail explanations of what I want with

$12 / hr
(Avg Bid)

...be used for a presentation document. Attached is the spreadsheet.
Globals have been included, though it may be faster to re-design the spreadsheet and re-enter numbers / **formulas** to make sure it's perfectly functional.
Project is for a book series called Porter the Hoarder. Design and concept info for the series can be found at:
https://porterthehoarder

$137
(Avg Bid)

I need Data entry person
1 day left

I am looking for someone to build me an **Excel** budget template that I can use to cost out projects.
As well as having **formulas** and macros it will need to be excellently presented and be able to be external facing.
The turnaround for this project is few days

$26 / hr
(Avg Bid)

Build me an Excel Template
1 day left

I am looking for someone to build me an **Excel** budget template that I can use to cost out projects.
As well as having **formulas** and macros it will need to be excellently presented and be able to be external facing.
The turnaround for this project is 2 weeks.

$435
(Avg Bid)

modify and make additions to exis...costing file to the data base to cost out **formulas**. this would involve adding a cost per kg, per unit size to existing file, and to calculate the final cost per unit.
-modify existing formulation file to link back to the individual source ingredients
-change current export of reports from pdf export format to **excel**

$93
(Avg Bid)

NDA

Update a table in Excel based on basic criteria - data entry or excel specialist needed
19 hours left

...individual sheets transposed and consolidated into an existing sheet in **Excel**. This can be achieved through copy and pasting or a simple macro but non-standard row positions make using macros a little challenging. Approximately 150 copy and pastes per sheet are required. Or can use **excel** **formulas** which dramatically reduces the need for copy pasting. It is very

$135
(Avg Bid)

...looking for a logo for our company that commercializes digital support with state-certified nutritionist dietitians.
It is a completely digital service that includes three **formulas**.
A prenium formula for support and follow-up personalize with 2 video conference per month with a dietician.
A basic formula to access our thinning method which includes

$112
(Avg Bid)

i need help to understand business finance **formulas**, is there any body who can teach me

$4 / hr
(Avg Bid)

Cumulative sum formula
Ended

Hello I am struggling to get the cumulative **formulas** showing on attached spreadsheet - AO6:AN29, please can someone help for £5? Many thanks

$14
(Avg Bid)

i need help to understand business finance **formulas**. Milestone will be created.

$6 / hr
(Avg Bid)

Excel function
Ended

...cells.
Attached is **Excel** file.
Page 1 (Times) includes a lot of **formulas**. I want all data from all cells on "I" to "AF" to be mirrored to the cells on the page "Times_print" where they are on colums "A" to "X".
Note! All cells and **formulas** stay as they are on page "Times". On page "Times_print" all fun...

$22
(Avg Bid)

I have a google sheet that is a form for Per Diems for staff.
1. I need **formulas** to calculate $Total Claim, based on user selection of their Pay Bracket, Accommodation, Breakfast, Lunch, Dinner and Incidentals, for the total to be reimbursed, to calculate from the 2nd sheet a price form a table based on those selections.
2. I need to then have the

$77
(Avg Bid)

...existing microsoft access database files that have been created for formulating chemical products. the requirements are to:
-add a costing file to the data base to cost out **formulas**. this would involve adding a cost per kg, per unit size to existing file, and to calculate the final cost per unit.
-modify existing formulation file to link back to the individual

$78
(Avg Bid)

Odoo 12 Partner and Shares Management
We just started using odoo comminty edition. (Because of our company has very simple requirements, odoo community edition enough fo...see first period (january, february, march)
financial position of the company means summary of company expenses and income. Also calculate A,B,C,D,E,F,G,H,M,K fields by **formulas**.

$815
(Avg Bid)

I need a python script that performs calculations with .tif raster files according to set **formulas**.
The calculations include selection en processing of country-wide topographical data.
Firther instructions and data files will be shared after agreement.

$181
(Avg Bid)

...from a simple application which makes estimates based on inputs the user introduces, and in the end it produces a respective report. It has all variables set (relationships, **formulas**, etc.).
All I need from you is to make it work just on access, by introducing those forms in Access, where I need to introduce the inputs and make it produce the reports

$151
(Avg Bid)

...completed so I can understand what's happening in the background once it's built, and perhaps understand how I can create additional code myself later by copying and adapting any **formulas**.
There is a lot to this one, so most likely I will only choose those with good English test results because communication is important to me, and your reply project quote

$288
(Avg Bid)

Build macros
Ended

I want the ability to click on a button that will either insert a row where a row is highlighted, add a header where the row is highlighted, and add a data row where **formulas** and conditional formatting integrities are maintained.

$28
(Avg Bid)

I need someone to add **formulas** inside my **excel** file

$23
(Avg Bid)

Ms **Excel** with following features
1. Log In Page
2. Calculation Worksheets will be provided , some Tidying up of few **formulas** for better calculations .
4 . Dependent worksheets to be generated from Calculation worksheets . Details will be provided.

$102
(Avg Bid)

...distribute paychecks
• Distribute paychecks on a bi-weekly basis.
Requirements:
• Advanced knowledge of Microsoft Office Word and **Excel**
• **Excel** - must be able to create and maintain spreadsheets with basic **formulas**
• Word - must be able to create and maintain word documents
• Able to work on confidential items and maintain a level of profession...

$449
(Avg Bid)

I need an excel expert
Ended

Hello! My project requires me to make a pivot table and some slicers. I just need help cleaning up the data and I don't have the proper knowledge of shortcuts in **formulas** to get the data cleaned quicker. I will attach the two sheets I am working with. The first, entitled KAREN H MID PROJECT, is my example that I need to base my work on. The first Dashboard

$80
(Avg Bid)

...data (this thread is not active yet))
• I want to add some functions in existing code(That I will provide you), which is running well.
• I will also provide the function **formulas**.
Following implementation is required in Python
• Data traffic which will be two types. One Constant bitrate (i.e., 1Kb)and constant frequency (i.e., data packet send after

$389
(Avg Bid)

...Cash Flow model in **Excel** that was used in a business case to support the build and operation of a University's Student Accommodation. Ideally also provide the business case report that the modelling supported. Please note, I do not want to you build a model, rather, I want you to find a completed **Excel** model, that includes all **formulas**, is appropriately

$89
(Avg Bid)

...calculators are nothing but online form where user puts in their details like age, weight, height etc and based on input, an output number is given. We will provide all the **formulas** and demos.
- Sign in/Register using Facebook and Gmail login methods
- "Our Team" section
- Simple three grid pricing plan
- Members Profile Page
More details here:
https://www

$380
(Avg Bid)

Need Excel expert to help build a complex financial model. Must know VBA, Macro, Dashboards etc
Ended

...I need an **Excel** expert to help build a complex financial forecasting / budgeting / sensitivity analysis model. It will require some macro automation, easy data input, dashboard , styling etc.
You must know **Excel** back to front, VBA and **formulas** such as Lookup, Index & Match etc
Don't apply for this project if you only know bits of **Excel** and you think

$34 / hr
(Avg Bid)

I need an individual filtered report by agent with the following need a count of each agent transaction and with the total of BF and Premium(Not together).

$26
(Avg Bid)

We need a expert with **excel**& **formulas** to do data entry for item listings and inventory.
and all data entry related for online marketplaces like Amazon, Walamrt

$4 / hr
(Avg Bid)

...found this piece of code that I'm injecting into the footer of my site but I don't know how to apply it to multiple images. I've only achieved 2 images but when I copy the **formulas** again again things start to get messy (2 gifs activate at the same time or the images change order within the page)
Here is the initial code:
<script>
(function()

$106
(Avg Bid)

Below are 12 basic functions and formulas that everyone should know.