Sentences with phrase «creating pivot tables»

Just when you thought you've mastered Microsoft Excel — creating pivot tables, VLOOKUPs and the rest — you discover the feature you never knew was there.

«If you know how to create pivot tables, you'd definitely want to put that on your resume.»

For example: You could create a video on how to create pivot tables, or how to create project plans, or how to organize your email.

They include things like knowing how to create pivot tables in Microsoft Excel.

Not exact matches

But think about the buzz that summer intern created when he made that pivot table or did a mail merge or constructed a shared calendar.

It generally consists of massive Salesforce exports, pivot table exercises (* shudder *), and manually creating charts and PowerPoint slides to present the findings.

I track everything coming in and going out from my checking account, and use a pivot table to create a chart where I can drill - down into each category of expenses.

Computer Skills Advanced knowledge of MS Excel (macros, pivot tables, data visualization) Proficient in MS Access (creating and modifying databases, tables, queries and forms; reports)

Scrutinized matured products and presented results by using functions such as vlookup, index match and pivot table to extract data and created graph to illustrate results

Improved Excel skill in pivot table and other functions when creating annuitization quote tool

c) Create, manipulate and edit 500 + reports and pivot tables in Excel on a daily basis to improve operational efficiency, data accuracy, and reporting consistency.

Coordinated, created and provided reports to management while manipulating data using pivot tables and macros.

Work extensively with various databases to create customized reports utilizing MS Query functions, vlookup, pivot tables and SQL Server

Example: Created complex Excel workbook using macros and pivot tables to capture and calculate inventory values for over 2,500 unique items.

Must be able to create spreadsheets - some knowledge of pivot tables a plus.

Created innovative new reports for senior management, incorporating Pivot Tables to demonstrate training productivity during SAP implementations within Finance and HR.

Qualifications * In Depth Data Analysis * Excellent Templates and Workbook skills * Strong Analytical and Financial modeling skills * Proficient in MS Office (Excel Vlookup, Hlookup, Pivot Table, Macro Expert) * Strong Verbal and Communication Skills * Bilingual (English / Spanish) Accomplishments * Created complex ad hoc management reports extracting data from Datamarts writing queries from Hyperion and TM1 * Managed Accoun...

Barnes and Noble Distribution Center (Memphis, TN) 12/2001 — 6/2004 Logistic Analyst • Developed KPI and methods for monitoring the Logistics in S&OP areas • Created weekly and monthly reports, charts, and pivot tables for various KPI's • Applied Process Excellence tools to identify and evaluate business challenges • Designed and implemented business operation, process, and system improvement measures • Maintained interfaces between ordering system and warehouse management system • Provided internal technical support for the WMS system • Developed new modules and WMS system enhancements • Oversaw creation of customized reports in Cognos to support business needs • Executed validation change control process and escalation of issues