1

Pivot Table Jobs (NOW HIRING)

RCM Billing Manager

Phoenix, AZ

$48.80K - $64.20K/yr

Experience working in Excel (advanced formulas, pivot table), PowerPoint, Word and Outlook. * High school diploma or GED required. BA/BS in Business Administration, Account, Finance or equivalent is ...

Assistant Admin II

Tulsa, OK

$16 - $21.50/hr

Must have advanced Excel experience including work experience with pivot table functions. * Must be able to type a minimum of 40 WPM. * Must have Intermediate Microsoft office skills. * Requires ...

RCM Billing Manager

Phoenix, AZ · On-site

$48.80K - $64.20K/yr

Experience working in Excel (advanced formulas, pivot table), PowerPoint, Word and Outlook. * High school diploma or GED required. BA/BS in Business Administration, Account, Finance or equivalent is ...

Logistics Billing Analyst

San Diego, CA · On-site

$51K - $67.90K/yr

A self-starter attitude with an ability to work well in a fast paced environment Experienced in Excel, especially in performing the v lookup function and pivot table Strong work ethic, accuracy and ...

... Excel (pivot table, vlookup formula, advanced charting,etc.) (REQUIRED) and proficient in MS PowerPoint • High level of attention to detail, accuracy and thoroughness • Must have strong ...

Assistant Admin II

Tulsa, OK

$15.50 - $21/hr

Must have advanced Excel experience including work experience with pivot table functions. * Must be able to type a minimum of 40 WPM. * Must have Intermediate Microsoft office skills. * Requires ...

Assistant Admin II

Tulsa, OK · On-site

$16 - $21.50/hr

Must have advanced Excel experience including work experience with pivot table functions. * Must be able to type a minimum of 40 WPM. * Must have Intermediate Microsoft office skills. * Requires ...

Proficient at Excel - pivot table knowledge * Experience in a team-oriented environment * Spanish is a plus Individual compensation offered for this position within this range will depend on many ...

Junior Accountant

Westbury, NY · On-site

$24 - $25/hr

Word, Excel, PowerPoint, familiar with Access, extensive pivot table experience * Ability to handle a multitude of tasks in a fast paced environment * Strong problem-solving capabilities * Ability to ...

Proficient at Excel - pivot table knowledge * Experience in a team-oriented environment * Spanish is a plus Individual compensation offered for this position within this range will depend on many ...

next page

Showing results 1-20

Pivot Table information

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.

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.

More about Pivot Table jobs
What cities are hiring for Pivot Table jobs? Cities with the most Pivot Table job openings:
What states have the most Pivot Table jobs? States with the most job openings for Pivot Table jobs include:
RCM Billing Manager

$48.80K - $64.20K/yr

Full-time

Medical, Dental, Vision, Retirement, PTO

Posted 11 days ago


American Vision Partners rating

6.6

Company rating: 6.6 out of 10

Based on 28 frontline employees who took The Breakroom Quiz


Job description

At American Vision Partners (AVP), we partner with the most respected ophthalmology practices in the country and integrate best-in-class management systems, operational infrastructure, and advanced technology to provide the highest quality patient care possible. Our practices include Barnet Dulaney Perkins Eye Center, Southwestern Eye Center, Retinal Consultants of Arizona, M&M Eye Institute, Abrams Eye Institute, Southwest Eye Institute, Aiello Eye Institute, Moretsky Cassidy Vision Correction, Wellish Vision Institute, West Texas Eye Associates and Vantage Eye Center. We are focused on building the nation’s largest and most comprehensive eye care practices and currently operate more than 100 eye care centers in Arizona, New Mexico, Nevada, California and Texas – including 25 ambulatory surgical centers.
At AVP we value teamwork, providing exceptional experiences, continuous improvement, financial strength, and hard work. We are committed to providing best-in-class patient care, pioneering research and technology, and most importantly, rewarding and recognizing our employees!


The Revenue Cycle Manger (RCM) of Acquisition and Training is responsible day-to-day operations of the RCM teams related to acquisitions, revenue cycle department training and quality assurance.


DUTIES AND RESPONSIBILITIES:

  • Manages the day to day operations of newly acquired revenue cycle teams to maximize cash flow by managing all aspects of the insurance billing and third-party collections while ensuring
    adherence to department policies and procedures.
  • May serve as the departmental liaison with all vendors, including but not limited to, clearinghouses, contracted business partners, third party payers, and information systems.
  • Provides project management, coordination, implementation, education, training, and oversight to approved RCM projects including but not limited to practice management system upgrades and
    RCM functions related to acquisitions, system integrations.
  • Identify any potential opportunities to increase EDI transactions with clearinghouses or business partners. Actively research and inquire any technology or product offering that improves RCM
    process efficiency and/or reduces cost with existing vendor partners
  • Onsite process mapping using workflow mapping software including Microsoft Visio.
  • Provide hands on training to new acquired RCM staff, mapping of roles and oversight of development.
  • Oversees the hiring, training, and supervision of department staff. Ensures that department policies are fairly administered by overseeing corrective action process, employee training, mentoring and
    coaching employees and supervisors as well as completing performance reviews.
  • Develop and maintain an annual assurance plan to proactively ensure accurate and optimal revenue capture, and seek to continually improve revenue cycle operational processes while
    assuring compliance with regulatory guidelines.
  • Monitor quality assurance results to identify risks, quality assurance opportunities and training needs.
  • Assist with development of the revenue cycle training programs and new hire orientation.
  • Remain knowledgeable on all HIPAA electronic transactions including claims (837), remits (835), eligibility (270/271), and claim status (276/277) Identify opportunities for implementation of HIPAA
    transactions
  • Meets or exceeds quality, productivity and deadlines standards as set by senior management.
  • Monitor and drive continuous improvement in key performance metrics around financial, activity and quality indicators; address performance gaps with team and processes.
  • Other duties as assigned.


GENERAL DUTIES:

  • Conducts self in accordance with the company’s standard values and policies.
  • Participates in a variety of educational programs, corporate and professional, to maintain current skill and competency levels.
  • Position may require occasional travel to newly acquired practices

Education and Experience:

  • Minimum five years in a leadership role within a healthcare revenue cycle department.
  • Previous supervisory experience with strong leadership skills and an ability to motivate others
    with a positive attitude.
  • Leadership capability and proven successful experience in managing medium to large A/R
    teams.
  • Experience working in Excel (advanced formulas, pivot table), PowerPoint, Word and Outlook.
  • High school diploma or GED required. BA/BS in Business Administration, Account, Finance or
    equivalent is preferred.
  • Must be able to travel to newly acquired practice to perform training and process mapping in
    addition to system integrations.
  •  

Essential Skills and Core competencies:

 

  • Strong background and experience in full Revenue Cycle Management.
  • Active knowledge of CMS guidelines contracted insurance guidelines and coding policies.
  • Demonstrated ability working in Excel (advanced formulas, pivot table).
  • Well-organized with attention to detail.
  • Ability to read and understand oral and written instructions.
  • Excellent math skills. Professional customer service skills.
  • Have a desire and dedication to work with self-discipline.
  • Maintains the strictest confidentiality: adheres to all HIPAA guidelines and regulations.
  • Ability to manage time in order to meet deadlines and deliverables
  • Experience with work flow and process mapping software.

Physical Abilities:

  • Ability to sit for long periods. Work requires walking, bending, standing, sitting, and reaching

Your health, happiness and your future matters! At AVP, we offer everything from medical and dental insurance, significant eye care discounts, child care assistance, pet insurance, continuing education funds, 401(k), paid holidays, PTO, Sick Time, opportunity for growth, and much more!


What American Vision Partners employees say

Pay

Benefits

Hours and flexibility

Workplace

Get the full story on Breakroom