Microsoft Excel Powerpivot Jobs

37 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I need someone to develop a basic cloud based database to manage our property income and accountant. currently we doing this task using a shared excel file in Google drive. but we want something bit professionals - It should have two different admin and user (read only) access - List of tenant (including pay due and paid ) - culculate income and expenses - Report - it has only 14 users (no public access internal use only) -web interface for database could be a solution. Happy to hear all suggestions and solution from candidates detailed information will be available once we start discussing the job
Skills: Microsoft Excel PowerPivot Certified Public Accountant (CPA) Cloud Foundry database programming
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I need someone to develop a basic cloud based database to manage our property income and accountant. currently we doing this task using a shared excel file in Google drive. but we want something bit professionals - It should have two different admin and user (read only) access - List of tenant (including pay due and paid ) - culculate income and expenses - Report - it has only 14 users (no public access internal use only) -web interface for database could be a solution. Happy to hear all suggestions and solution from candidates detailed information will be available once we start discussing the job
Skills: Microsoft Excel PowerPivot Certified Public Accountant (CPA) Cloud Foundry database programming
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
I need someone who can develop a work flow chart showing strategic priorities. Additionally, this work flow chart needs to be set up so that it can easily be updated and edited for additional information. Plus, I would like to be able to have it in pptx and set up so it can be updated when need to be. I also need this by the end of the day today, 8 pm CST.
Skills: Microsoft Excel PowerPivot Microsoft Excel
Hourly - Expert ($$$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
We are a growing company - we would like to analyze our Stripe transactions data to analyze monthly sales by type of sale, store, and time period. This data is currently extracted from a CSV file exported into Excel from Stripe. As we have grown this process is too cumbersome to do manually. We need this information to measure effectiveness of marketing programs and to track store growth progress and customer use of the stores. We would like to be able to extract data from Stripe on a weekly basis and use this data to create weekly and monthly sales reports for our team to monitor store progress. We would like to work with a consultant that can analyze our reporting needs and recommend the best way to proceed in the shortest amount of time possible, and also implement their solution. Attached is a sample of our sales transaction data for three months. We would like to calculate the following, and present it in a report: - Total sales per month per location - Total number of images sold per month per location (sum of number_images_purchased column) - Total number of buy all sales per month per location (sum of number_shoots_purchased column) - Total weekly sales per location (sum of all orders for a location in the time period) - Total number of images sold weekly per location - Total single image sales per week per location (sum of number_images_purchased column) - Total buy all sales weekly per location (sum of number_shoots_purchased column) - Total number of reservations per week per location (count of rows where purchase_type = reservation)
Skills: Microsoft Excel PowerPivot Excel VBA Microsoft Excel
Hourly - Entry Level ($) - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
English-based, online business seeks a data-entry worker for content library. We are looking for sharp, Web-savvy worker for viable subject matter content and helping import into our site. This is a GREAT "moonlight" gig for someone who is interested in learning more about the startup world, hospitality market, and loves a challenge. Our task can be addictive to anyone who loves searching the Web. Only serious inquiries will be considered.
  • Number of freelancers needed: 2
Skills: Microsoft Excel PowerPivot Full-text Search Engines Hospitality
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
i have a large working spreadsheet which I think would be easier to manage if each user listed had a drop down of all their information attached to them, instead of scrolling across many columns find the information (maybe a pivot table???) time consuming at present so need a more efficent way of collating the data for each user. (refer full employee listing tab and existing telstra optus tab. Would also like help in how to maintain it once you have found the best solution for this
Skills: Microsoft Excel PowerPivot Microsoft Excel Microsoft Exchange Server
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
looking for some one who have good knowledge on Microsoft excel to create a pivot template for weekly report, calculate total time taken to resolve an issue excluding holidays and weekends and working hours.
Skills: Microsoft Excel PowerPivot
Hourly - Entry Level ($) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Data Visualization with Excel Power Map- Building a Dynamic Heat Map for Incident analytics Looking for experienced BIG DATA, BI techie guy who can create the below: Data analysis skills -data visualizations Creating an Excel Power Map- (Building a Dynamic Heat Map) Excel's tool for exploring map and time-based data in 3D Building Dynamic Heat Map and shows how to reconstruct the visualization using Power Map. Reviewing the dataset and standardize the location data, (using TRIM and PROPER plus IF and CONCATENATE to combine fields.) Add a PivotTable to create a new or supplementary data source. Build a Power Map image with INDIRECT (Using named ranges and Using IF map references ) to visualize geospatial data: incidents options in different times and locations. Linking data to the map images with HYPERLINK- Using the INDIRECT, Using IF tab names and HYPERLINK functions. Good knowledge with Excel , Big DATA and BI • Setting up the heat map project • Using functions such as WEEKDAY and VLOOKUP • Adding conditional statements • Formatting with the color-scale feature • Aggregating data with SUM • Adding dynamic filters • Creating formula-based formatting rules • Adding additional analytics Date and Time Functions o DATEVALUE o Categorization o WEEKDAY o VLOOKUP o EOMONTH o YEARFRAC Conditional Statements and Logical Operators o True Season o Accident type o Using ISBLANK Building a Basic Heat Map o Heat map framework o COUNTIFS o Color scale formatting o Aggregate data SUM o Quick QA: Identifying and eliminating inaccurate data Adding Dynamic Filters to the Map o Data validation o Accident type COUNTIFS o SEASON filter Creating Formula-Based Formatting Rules o Using the NOW and TODAY functions o Formatting with ROW and COLUMN functions o Highlighting a current moment in time
Skills: Microsoft Excel PowerPivot Big Data Business intelligence