There is no item in your cart
Excel Data Analyst Internship
Training Program
We are launching a BRAND NEW, first of its kind virtual Excel Data Analyst Internship Training Program! We will be partnering with an existing client, who is multi-million dollar NPO (non-profit organization) who is in need of reports and lots of them. The organization wants eXcelerate to train students on how to create their desired reports in Excel. Once we are done training, our team of instructors will be converted to your program’s project managers and will guide you on how to create the reports our client is looking for. The organization wants students to be able to create fully functional reports that will include key performance indicators (better known as KPIs) that can contribute in helping them with developing a long term strategy to increase customer experience, sales, profit margins, and overhead expenses.
This program will provide students with the opportunity to not only become an Excel master, but it will help them get full visibility into what’s it’s like to be a data analyst. The program will allow them to immerse themselves into the day to day of a data analyst and what it takes to be a successful data analyst.
The internship will be UNPAID. With that being said, students will gain a plethora of knowledge that will provide them with the skillset to be day one ready for their future first role as a data analyst. Employment is not guaranteed at the completion of the program. The purpose of the program is to expose students to the data analyst experience. Instead of wondering, “What exactly does a data analyst do?”, students will finally get to live it!
Applications are now open through 11:59p EST Sunday, July 28th. All selected candidates will be notified of their acceptance status by Tuesday, July 30th.
Check out the program timeline and schedule below:
Check out additional program details below:
Frequently Asked Questions
Program Overview and Organization Details
In the program, you will get to truly experience the day to day of being a data analyst. Not only will you be responsible for producing complex Excel reports, but you will gain exposure into the following:
– Asking the right questions: We will teach students how to ask the right questions to truly get the data that is needed.
– Collecting the correct data to satisfy business requirements: You will learn how to accurately collect data from end users.
– Communicating effectively: You will learn how to communicate with team members and managers to truly deliver reports that cater to the needs of the end user(s).
– Documenting your reporting processes: Documenting all steps in your reporting process is key! Our team will walk you through how to do this effectively to ensure all reports are delivered successfully and fully functioning.
– Presenting your findings: Once your designated reports are complete, our team will train you on how to create an end of project deliverable as well as instruct you on how to present your findings in the final deliverable.
– Identifying appropriate KPIs: You will learn how to help managers know what to look for in their data and guide them on the appropriate questions that should be asked when analyzing data in reports.
– Lots of Microsoft Excel training: You will receive close to 50 hours of intense Microsoft Excel training from our instructing team.
The partnering organization is a non-profit organization located in the Southeast region that specializes in the arts and entertainment industry, who has generated over $20M in revenue (2023) , has contributed close to $50M in economic tourism impact in its local community during this time, and hosts over 100 events per year. The organization has been around for close to 100 years and is continuing to flourish with the exponential growth they have experienced in the last few years. The organization has various departments which will receive support from the reports selected interns will provide. The departments include:
– Human Resources/Payroll
– Hospitality/Food & Beverage
– Marketing
– Philanthropy
– Production
The name of the organization will be provided to all selected students within 24 – 48 business hours of their program payment.
The organization has a TON of data and needs a team of interns to help them make sense of the data. Because the organization have experienced exponential growth over the last 4 – 5 years, they need the data to help them strategize long-term growth and efficiency initiatives pertaining to sales, operations, VIP members, cost benefit analysis, and labor reporting.
No, as all organizations we are partnering with are classified as non-profit organizations.
In this program, not only will you gain invaluable training on what’s it is like to be a data analyst, but you will also be trained by experts in the field who know data in and out. While you are receiving this experience, you will also receive a vast amount of training from our team of instructors who will serve as your program’s project managers.
This program goes beyond Excel training. You will receive over 50 hours of reporting, KPI, and presentation data analyst presentation training as well. You will also have real world experience of what it is like to be a data analyst via the communication with the organization’s COO, reporting deliverables, and report findings!
No, this program does not guarantee employment. The program’s primary objective is to successfully train and develop aspiring data analysts in the making, along with exposing them to a realistic 360 degree view of what it is truly like to be a data analyst.
Check our resumes! We are a 7 year old company who has a long list of Fortune 500, non-profit organizations, and government entities as our clients.
We have trained over 5,000 students during this time frame who have received quality SQL, Excel, Power BI, and Tableau training to name a few. Also, feel free to check out our Google reviews (located on the homepage of our site or through a quick Google search: eXcelerate classes Atlanta).
Would a multi-million dollar organization partner with us if they didn’t trust our work? Just saying………………………WE ARE VERIFIED!
Yes, it is a requirement of the sponsoring organization due to sensitive sales and customer data that will be provided.
Applications open on Thursday, July 25th.
Applications close on Sunday, July 28th.
Selected candidates will be notified within 48 business hours of their submission.
You will learn the following Excel functions:
– Xlookups
– If statements
– Complex nested statements
– Filter functions
– Multi criteria conditions in Filter and Xlookup formulas
– Picklists
– Automations
– Basic macros
– Error correcting formulas
– Data modeling
– Formatting overview
– Filtering
– Sorting
– Sumifs
– Top category formulas
Pricing, Payment Plans, and Refund Policy
The program is $599.
All selected candidates will be required to pay at least 50% of tuition within 48 hours of being selected into the program. The remaining 50% will be due by Wednesday, August 7th. If your program is not paid in full by this date, then your spot will be offered to a waitlisted student. All payments are NON-REFUNDABLE.
Yes, all selected candidates who pay in full will receive a 15% discount. All payments are NON-REFUNDABLE.
If my circumstances change and will no longer be able to attend the program, can I receive a refund?
No, as all payments are NON-REFUNDABLE.
Schedule and Attendance Requirements
We require all selected candidates to attend at least 70% of meetings and training sessions. Students who dip below the minimum requirement will receive a warning. After the warning and if tardiness/absences still continue, then your registration will be terminated. No refunds will be provided to students who do not adhere to the program’s policies and requirements.
ALL STUDENTS ARE REQUIRED TO ATTEND ALL SCHEDULED KICKOFF MEETINGS (Scheduled for Monday, August 19th and Tuesday, August 20th). THERE WILL BE NO EXCEPTIONS.
- All meetings and training sessions will be recorded. We will upload all meetings and training sessions to the program’s shared folders. If you have any outstanding questions, you can talk with your program’s project managers.
- Check out the schedule HERE.
The entire program will span close to 100 hours. During the training process (August through October), we advise students to allocate roughly 2 to 3 hours per week honing their Excel skills and applying taught skills to weekly exercises that will be provided.
After the training portion of the program, we advise students to spend roughly 4 to 6 hours per week preparing for their final report deliveries and project presentations.
Selection Process
That is true! We have over 100 students on our waiting list and 75 who have signed up for our info session. We will only be able to accept 16 candidates to participate in the program. We will not be able to exceed this number.
We are looking for the following:
- – Students with a true passion for data and interested in becoming a data analyst
- – No excuses
- – True hard workers
- This program will not be easy. It will require a lot of time, hard work, and dedication.
- – Students who can proficiently use a computer
- – Students who type at least 30 word per minute
- -Typing test will be provided in the application
- – Students with basic Excel skills that include the following:
- -Spreadsheet navigation
- -Creating new worksheets
- -Hiding worksheets
- -Deleting worksheets
- -Locating a cell
- -Data entry (inputting data into a cell)
- -Know the difference between columns and rows
- -Copying and pasting data
- -Opening a workbook
- -Know the difference between a workbook vs. worksheet
- -Saving a workbook
- -Inserting and deleting rows and columns
IF YOU DO NOT HAVE THESE EXCEL SKILLS, PLEASE DO NOT APPLY. AN EXCEL SKILLS TEST WILL BE GIVEN AS A PREREQUISITE TO ALL SELECTED STUDENTS.
Don’t worry about having formula experience as we will teach you all formulas you will need to learn!
Software requirements and access
- – High speed internet/WiFi
- – Functional and reliable laptop
- – Experience using Zoom
- – Latest version of Office (Office 365)
- -We will not provide an Office license as this will be the responsibility of the candidate.
Yes, you will receive access to the following to successfully complete the program:
– Secured organization issued email address
- -All email correspondence will be required to be communicated through the provided company issued email domain for privacy reasons. Any email communication that is completed outside of our company issued email will result in an immediate termination of your program registration.
- – Shared drive folder access
- – Project management collaboration software (Smartsheet)
- -During the reporting phase of the program, you will be required to document all data requirements, progress, and process through Smartsheet. This will allow you and your team to properly manage all reporting requests that are being requested through the pipeline.
Classroom Environment General Questions
All training will be conducted virtually via Zoom.
Please refer to the training schedule HERE.
Meetings with management and designated teams will be determined by the organization and will take place on weekday afternoons. We will do our best to provide students with at least a two weeks notice of management meeting dates. Due to business demands, there may be instances where the meeting times/dates may have to be rearranged.
All training and non-managerial meetings will take place weeknights from 7:30p to 9:45p EST Mondays through Wednesdays (August through October) and from 7:30p to 9:45p EST Mondays through Thursdays (November).
Yes, all training sessions are recorded and available for up to 30 days after the last day of the program.
Yes, this is a requirement of the program as we want this to be as realistic as possible. You can’t be a successful data analyst without team collaboration!
Of course! Your program will be allocated two instructors, who will serve as your training instructors during the training phase of the program and will serve as project managers towards the end of the program. They will be your go-to guides if you have any questions or complications with completing your work. Any company related questions can be asked to the sponsoring organization’s management team.
Yes, during the month of November, your entire focus will be on your assigned reporting projects. During this time, your program’s project managers will schedule a great deal of 1:1s with your team to ensure all students are on the right track. We are here to help you succeed in any way we can.
End of Program Deliverables
At the end of the program, students will receive the following:
- – Certificate of completion
- – LinkedIn recommendation
- – Letter of recommendation
- – LinkedIn and resume description
- – Program portfolio
- -Will include all assigned projects, presentations, and project lifecycle documentation
