K2's 2023 Excel Essentials For Staff Accountants WEBCAST

3 weeks ago


Woodstock, United States Washington Society of CPAs Full time

Staff accountants have specific needs when working with Excel - needs that are often not met by their existing Excel knowledge. Chief among these are the needs to quickly summarize data, prepare accurate and aesthetically pleasing reports, and create accounting-centric calculations for elements such as depreciation, amortization, and interest. By participating in this eight-hour session, you will gain the essential skills they need to maximize their efficiency and accuracy when working with Excel. This session begins with a quick overview of Excel best practices. It then progresses rapidly into discussions that address PivotTables, sophisticated formulas, Tables, formatting, and working with dates in Excel. Throughout the course, you will learn from accounting-centric examples to reinforce key learning points. In this session, you will learn in a “laptop-friendly” environment, and participants will have access to all the demonstration files used in the session. In sum, this seminar is a “must” for all staff accountants seeking to improve their efficiency and accuracy when working with Excel. Highlights

Best practices for creating and working with Excel workbooks. Effectively using Excel functions when creating formulas. The importance of PivotTables in modern reporting environments. Best practices for formatting your workbooks. Prerequisites

Fundamental knowledge of Microsoft Office Excel 2019 or newer. Designed For

Accounting and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data. Objectives

List five critical best practices associated with creating workbooks and construct workbooks that comply with these principles. Utilize PivotTables and PivotCharts to summarize and present data quickly, without writing formulas. Build sophisticated formulas to assist with reporting and analysis, including formulas that use functions such as VLOOKUP, XLOOKUP, SUMIFS, CHOOSE, XNPV, XIRR, PMT, IPMT, ACCRINT, and TRIM. Create Tables from ranges of Excel data and identify the primary advantages of working with Tables. Apply formats quickly and efficiently to Excel reports and understand the importance of features such as the Accounting format, Accounting Underlines, Precision as Displayed, Center Across Selection, and Flash Fill. Work with date-oriented data in Excel and create calculations - such as those involving depreciation expense and interest accruals - that involve the passage of time. Preparation

None. Notice

None. Fees

Member Price

$225.00 Non-Member Price

$275.00 Credits

8.0 Credits Technical/Computer Software and Applcations (8.0)

#J-18808-Ljbffr


  • Staff Accountant

    5 days ago


    Woodstock, United States Searchlogic Recruiting, LLC Full time

    Job DescriptionJob DescriptionWork close to home in Woodstock, GA with a fast growing firm!  Immediate growth related opportunity for a Staff Accountant.  Job DescriptionThe Staff Accountant provides support to the Controller and Assistant Controller in carrying out the responsibilities of the Accounting & Finance Department.ESSENTIAL...

  • Staff Accountant

    4 weeks ago


    Woodstock, United States Searchlogic Recruiting, LLC Full time

    Job DescriptionJob DescriptionWork close to home in Woodstock, GA with a fast growing firm!  Immediate growth related opportunity for a Staff Accountant.  Job DescriptionThe Staff Accountant provides support to the Controller and Assistant Controller in carrying out the responsibilities of the Accounting & Finance Department.ESSENTIAL...

  • Tax Accountant

    5 days ago


    Woodstock, United States Searchlogic Recruiting, LLC Full time

    Job DescriptionJob DescriptionAbout Us: Our client has been a trusted partner in the North Atlanta Area for over 20 years, providing exceptional tax planning and preparation services to both businesses and individual customers. As a reputable CPA firm, they take pride in our commitment to excellence and personalized service.Position Overview: We are seeking...

  • Tax Accountant

    1 week ago


    Woodstock, United States Searchlogic Recruiting, LLC Full time

    Job DescriptionJob DescriptionAbout Us: Our client has been a trusted partner in the North Atlanta Area for over 20 years, providing exceptional tax planning and preparation services to both businesses and individual customers. As a reputable CPA firm, they take pride in our commitment to excellence and personalized service.Position Overview: We are seeking...

  • Tax Accountant

    7 hours ago


    Woodstock, United States Searchlogic Recruiting, LLC Full time

    Job DescriptionJob DescriptionAbout Us: Our client has been a trusted partner in the North Atlanta Area for over 20 years, providing exceptional tax planning and preparation services to both businesses and individual customers. As a reputable CPA firm, they take pride in our commitment to excellence and personalized service.Position Overview: We are seeking...


  • Woodstock, United States The Erosion Company Full time

    The Erosion Company (TEC) is currently hiring an **Accounts Receivable Coordinator** for our Woodstock, GA location. We are the largest and most experienced Erosion Control contractor in the Southeast, offering comprehensive erosion control, specialty materials, forestry and other site clean-up / control services to a wide variety of clients. The AR...

  • Account Manager

    3 weeks ago


    Woodstock, United States Savant LLC Full time

    Job DescriptionJob Description Job Description:The purpose of the Account Manager position is to increase the existing customer base for the company. The primary focus of the Account Manager is to locate and qualify new prospects by generating interest in the company’s services and products. Basic Functions:· Responsible for prospecting and qualifying...


  • Woodstock, United States W3Global Full time

    We are a Veteran owned CPA firm, is looking for a Senior Tax Accountant. We are the fastest growing, innovative CPA firm in Woodstock, GA and looking for a Tax professional who is heavily experienced in business taxes (1120S, 1065, 1120), personal taxes (1040), and IRS representation. We are looking for someone who is ambitious and can complete tasks quickly...

  • Registered Nurse

    4 weeks ago


    Woodstock, United States Equus Full time

    Job DescriptionJob DescriptionCompany DescriptionOur Job Corps programs provide life-changing services that help young people succeed in school, obtain good jobs, excel in their chosen fields, and serve as contributing members of their communities. We accomplish this through an intense commitment to safety, quality service, excellence, and partnerships.Job...


  • Woodstock, United States The McHenry County ROE Application Consortium Full time

    Position Type: Support StaffDate Posted: 3/11/2024Location: Clay AcademyDistrict: Woodstock Community Unit School District 200 - websiteThis is a part-time position for the 2023-2024 school year, 6.25 hours per day, 5 days per week, 9 months per year, $20.00 per hour. Attachment(s):Registered Behavior Technician job descript 06 06 23.pdf

  • Welding Instructor

    4 weeks ago


    Woodstock, United States Equus Full time

    Job DescriptionJob DescriptionCompany DescriptionOur Job Corps programs provide life-changing services that help young people succeed in school, obtain good jobs, excel in their chosen fields, and serve as contributing members of their communities. We accomplish this through an intense commitment to safety, quality service, excellence, and partnerships.Job...


  • Woodstock, United States MD Staff, LLC Full time

    Looking for Pulmonology Physician to fill a locums coverage in Ohio Duration: ASAP - Ongoing Shift(s) Description: Office M-TH 8-4/ Fri 8-12p; inpatient rounds on weekends with call Rates: Daily Night call Callback EMR: Epic The pulmonologist will conduct admissions, the staffed hospitalist will admit pulmonary patients to the hospital. Located near...

  • Accounting Manager

    6 days ago


    Woodstock, United States Rising Star Roofing Full time

    Apply Job Type Full-time Description Northpoint Roofing Systems, a renowned roofing company known for its commitment to excellence, customer satisfaction and ranked 653 on the prestigious Inc. 5000 list along with a 26th position in the competitive construction sector is looking for a highly organized, multitasker with hands-on QuickBooks Online experience...

  • Accounting Manager

    1 week ago


    Woodstock, United States Northpoint Roofing Systems Full time

    Job Type Full-time Description Northpoint Roofing Systems, a renowned roofing company known for its commitment to excellence, customer satisfaction and ranked 653 on the prestigious Inc. 5000 list along with a 26th position in the competitive construction sector is looking for a highly organized, multitasker with hands-on QuickBooks Online experience to join...


  • Woodstock, Georgia, United States MD Staff, LLC Full time

    Looking for Pulmonology Physician to fill a locums coverage in Ohio Duration: ASAP - Ongoing Shift(s)Description: Office M-TH 8-4/ Fri 8-12p; inpatient rounds on weekends with call Rates: Daily Night call CallbackEMR:Epic The pulmonologist will conduct admissions, the staffed hospitalist will admit pulmonary patients to the hospital. Located near WOODSTOCK,...


  • Woodstock, United States City of Woodstock Illinois Full time

    Job DescriptionJob DescriptionARE YOU A GO-GETTER?We are looking for a dynamic candidate who WOWS and can seamlessly join our team!If you are a master at leading strategic initiatives, driving revenue, fostering community engagement and relationships, and are brimming with creativity that will turn opportunities into triumphs, we want to talk to you! We are...

  • Car Wash Attendant

    13 hours ago


    Woodstock, United States Carriage Kia of Woodstock Full time

    Job DescriptionJob DescriptionJob Title: Car Wash AttendantDepartment: Car WashReports To: Car Wash ManagerSummary:We are looking for a hard-working and motivated individual to join our team as a Car Wash Attendant. In this role, you will be responsible for cleaning the exterior and interior of vehicles to the highest standards. You will also be responsible...


  • Woodstock, United States City of Woodstock Illinois Full time

    Job DescriptionJob DescriptionPOSITION SUMMARY and ESSENTIAL FUNCTIONSThe position is responsible to assist the Engineering staff by conducting inspections, surveys, measuring quantities, collecting and implementing GIS data, mapping assistance, preparing reports and calculations, and performing research for various project types which may include roadway...

  • Lead Teacher

    2 weeks ago


    Woodstock, United States LUMA LEARNING CENTER Full time

    Job DescriptionJob DescriptionDirect children in activities designed to promote intellectual and creative growthCreate a fun and inviting classroom environmentCreate and develop lesson plans based on monthly themesEstablish and maintain positive relationships with peers and parentsCommunicate with parents on students' growth and progressEnsure the health...

  • Accounting Manager

    3 days ago


    Woodstock, United States Creative Financial Staffing Full time

    Creative Financial Staffing has partnered with a leading manufacturer and fabricator of specialized industrial products. They are looking to add an Accounting Manager to their team and will move quickly for the right candidate Highlights of the Accounting Manager Opportunity: The Accounting Manager will be a business partner to the leadership team and will...