1

Pivot Table Jobs in Florida (NOW HIRING)

Experienced at using EXCEL to develop data reports and quotations (Formulas, VLOOKUP, Pivot Table). * Bi-Lingual/bi-Literate Spanish skills, a plus. Why Join American Wire Group? At American Wire ...

Apply Early

Senior Accountant

Melbourne, FL · On-site +1

$66K - $90K/yr

Ability to download large amounts of data and perform pivot table analysis in Excel. Identify and resolve issues in a timely manner * Proficiency with AP and expense software such as NetSuite or Bill ...

Senior Accountant

Melbourne, FL · On-site

$66K - $90K/yr

Ability to download large amounts of data and perform pivot table analysis in Excel. Identify and resolve issues in a timely manner * Proficiency with AP and expense software such as NetSuite or Bill ...

Senior Factory Financial Analyst

Ormond Beach, FL · On-site

$75K - $93K/yr

Strong Microsoft EXCEL (beyond basics functions as of as Pivot table, VLOOKUP, xlookups and sumifs) * Outstanding attention to detail, accuracy, and ability to multitask * Naturally engaged and ...

Senior Factory Financial Analyst

Ormond Beach, FL · On-site

$74K - $93K/yr

Strong Microsoft EXCEL (beyond basics functions as of as Pivot table, VLOOKUP, xlookups and sumifs) * Outstanding attention to detail, accuracy, and ability to multitask * Naturally engaged and ...

next page

Showing results 1-20

Pivot Table information

What are pivot tables?

Pivot tables are a powerful feature in spreadsheet applications like Microsoft Excel and Google Sheets that allow users to quickly summarize, analyze, and organize large sets of data. By dragging and dropping fields, you can create customized reports and view your data from different perspectives. Pivot tables are commonly used for tasks such as finding totals, averages, or trends within large datasets, making them valuable tools for data analysis and business reporting.

What is the difference between Pivot Table vs Data Analyst?

AspectPivot TableData Analyst
Primary RoleTool for data summarization and analysisInterprets data, creates reports, and provides insights
Required SkillsExcel proficiency, data organizationStatistical analysis, data visualization, Excel and SQL skills
Work EnvironmentExcel, spreadsheets, data management toolsData analysis software, spreadsheets, reporting tools
CertificationsExcel certifications (e.g., Microsoft Office Specialist)Data analysis certifications (e.g., Microsoft Data Analyst Associate)

While Pivot Tables are a key tool used within data analysis, a Data Analyst performs broader tasks including interpreting data, creating reports, and providing strategic insights. Pivot Tables are essential for quick data summarization, but Data Analysts utilize a variety of tools and skills to analyze data comprehensively.

What are the key skills and qualifications needed to thrive as a Data Analyst, and why are they important?

To thrive as a Data Analyst, you need strong analytical abilities, proficiency in data interpretation, and a background in statistics or a related field. Familiarity with Microsoft Excel (especially Pivot Tables), SQL, and data visualization tools like Tableau or Power BI is typically required. Attention to detail, problem-solving skills, and effective communication are vital soft skills for translating complex data into actionable insights. These skills ensure accurate data analysis, support informed decision-making, and help organizations achieve their strategic goals.

What are some common challenges faced by data analysts when using pivot tables in their workflow?

Data analysts frequently use pivot tables to summarize, analyze, and visualize large datasets, but they can encounter challenges such as managing data integrity, dealing with inconsistent formatting, and handling very large datasets that may slow down performance. It’s also common to face difficulties when updating pivot tables after changes in source data or when integrating with other analysis tools. Developing strong organizational habits and routinely cleaning data can help mitigate these challenges, leading to more accurate and efficient analysis.

Sr. Manager, General Ledger Accounting

L3HHCM20

Melbourne, FL • On-site

$120K - $223K/yr

Other

Medical, Retirement, PTO

Posted 23 days ago


Job description

Job Title: Sr. Manager, General Ledger Accounting 

Job Code: 37568

Job Location: Sacramento, CA (preferred), Canoga Park, CA, Huntsville, AL, or Melbourne, FL 

Job Schedule: 9/80: Employees work 9 out of every 14 days- totaling 80 hours worked- and have every other Friday off.

Job Description:

The Missile Solutions segment of L3Harris Technologies, Inc. is seeking a Manager, General Ledger Accounting, to join the General Ledger team, reporting to the Sr. Director, Missile Solutions Accounting.  This role will be part of the team responsible for providing rapid and high-quality financial information.  This role will also support ongoing integration initiatives, process improvement initiatives and other projects, as required.

Essential Functions:

  • Oversee general ledger accounting activities. Apply principles of accounting to review and analyze financial information detailing assets, liabilities, and capital to ensure the accurate delivery of financial reports.

  • Support monthly financial close and analysis functions, by leading the monthly close process, reviewing journal entries, including period end accruals to the general ledger, reviewing account reconciliations and related analysis.  Participate in Management's monthly review of financial statements.

  • Evaluate and implement improvements in processes and systems to enhance performance of job area. Communicate within and outside the organization as to changes in policies, practices or approaches.

  • Investigate the root cause of accounting discrepancies and/or problems, utilizing the resources available to our segment.  This may require a high degree of problem solving and innovation when information is more difficult to obtain.

  • Support audit activities and requests from external, internal and DCAA auditors, including annual walkthrough and testing of SOX controls.

  • Provide leadership and direction to experienced professionals, including guiding their growth and career development.

Qualifications:

  • Bachelor's Degree and minimum 12 years of prior relevant accounting experience. Graduate Degree and a minimum of 10 years of prior related accounting experience. In lieu of a degree, minimum of 16 years of prior Accounting experience required. 

Preferred Additional Skills:

  • Independent, self-motivated individual with strong organization skills and attention to detail.

  • Demonstrated ability to adapt to changing requirements and priorities, requiring flexibility in terms of daily activities.

  • Strong customer service approach, self-directed, and assertive, with a positive attitude.

  • Excellent communication and interpersonal skills with hands on approach to process improvement and effective problem resolution.

  • Ability to develop broad, cooperative relationships across the larger L3Harris organization.

  • Proficiency in Excel, including pivot table and lookup functionality.

  • Experience with Oracle ERP system.

  • MBA or CPA.

In compliance with pay transparency requirements, the salary range for this role in Colorado State, Hawaii, Illinois, Maryland, Minnesota, Vermont and New York State is $105,000-$195,000. For California, Seattle, Washington D.C., Maryland Greater Washington D.C. area, the city of Denver, Washington State, New Jersey, and New York City, the salary range for this role is $120,500 - $223,500. This is not a guarantee of compensation or salary, as final offer amount may vary based on factors including but not limited to experience and geographic location. L3Harris also offers a variety of benefits, including health and disability insurance, 401(k) match, flexible spending accounts, EAP, education assistance, parental leave, paid time off, and company-paid holidays. The specific programs and options available to an employee may vary depending on date of hire, schedule type, and the applicability of collective bargaining agreements.

#LI-SS3