Not exact matches
As much as analysts thirst for
spreadsheets and
pivot tables, they also desire team members who can guide the decision making process.
This resource has: a) Ideas for investigating the Phase 10 Data (Ten Investigations using CensusAtSchool Phase 10 Data.doc), b) A
spreadsheet containing the counts and percentages of the results from Phase 10 up to February 2011 (CensusAtSchool Phase 10 summary
spreadsheet.xls), c) A learners» worksheet to help them plan their investigation (CensusAtSchool Planning Worksheet.doc), d) An instruction sheet to use
Pivot Tables in Excel (
Pivot Tables in Excel.doc) e) A
spreadsheet to be used with the
Pivot Tables in Excel worksheet (
Pivot Tables in Excel.xls).
Of course, Dora's shot straight to the top of the «
Spreadsheet Society», «Excel Ecstasy» and «
Pivot Table Paradise» groups!
Most lawyers however, fall firmly into the «I prefer words to numbers» category, and so before you switch off, let me give you a 100 % money back guarantee that there will be no data analysis,
spreadsheets, pie charts or
pivot tables in this post.
Your training will introduce everything from the novice's perspective, working your knowledge from basics up to more complicated tasks like formatting custom
spreadsheets and understanding how to use tools like
pivot tables effectively.
• Strong knowledge of complex Excel
spreadsheets,
Pivot Tables and macro generation.
• Strong Excel
spreadsheet and macro generation experience, able to build
pivot tables and complex
spreadsheets for data generation.
Example: An advanced Excel user should be able to: Customize the work area; Use advanced functions (Names, VLOOKUP, IF, IS); Work with
Pivot Tables; Use
spreadsheet Web components; Manage Macro commands: concepts, planning, operations, execution, modification, interruption; Use personalized toolbars; and Perform some programming in VBA.
Must be able to create
spreadsheets - some knowledge of
pivot tables a plus.
accounting, Adobe Acrobat, Adobe Photoshop, AS 400, customer service, data collection, database, financial, financial analysis, government regulations, insurance, MS Internet Explorer, inventory levels, Macintosh, director, Access, Excel, Microsoft Office, PowerPoint, Windows, Word, radar, navigation, Operating Systems, personnel management,
Pivot Tables, policies, processes, receiving, reporting, scanning,
spreadsheet, SQL, SunOS, Ultrix, UNIX
PROFESSIONAL EXPERIENCE Vulcan Materials Co., Atlanta • GA 1997 — 2012 Job Title Provide clerical support and service with office management oversight providing strong knowledge of complex Excel
spreadsheets,
Pivot Tables and macro generation.