Microsoft Excel Powerpivot Jobs

62 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 - 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
Fixed-Price - Expert ($$$) - Est. Budget: $150 - Posted
Hi- I have census data i need analyzed very quickly- today if possible. - Very small amount of census data -must put on our slide - must provide the excel data as well In particular, I want to update the 2 slides in demo slide update (and move them into our new format) that show the US corporate sector broken down by revenue size of firm for number of firms, employment and total revenues – rolled up for middle market which is $10-100MM and broken into finer categories. The excel files contain the 2012 data and one has the breakdown for >$100MM in revenues.
Skills: Microsoft Excel PowerPivot Microsoft Excel
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