Lookup Functions Masterclass
Join us for this uniquely fun, interactive and practical session, where we'll deep dive into one of the most useful yet misunderstood Excel functions - VLOOKUP. We'll also demonstrate how the new XLOOKUP function is more efficient, flexible and robust than its older cousin VLOOKUP.
Event hosted by
Excel Academy
Excel Academy
Ideal for
Continuing Professional Development (CPD)
Date
18 April 2023
Time (SAST)
09h00-10h00
-
The outcomes of the live events has been mapped to the following competencies: Digital Impact, Digital Affinity, Digital Familiarity
-
The live event is ideal for Continuing Professional Development and where required the necessary CPD accreditation is obtained from the professional body. For more information contact us.
-
We offer bulk registration discounts for group bookings on our live events. Please view our standard group registration rate card here.
The index below represents the structure of the Live Event. You will be able to access the information contained within the index once registered. On the day of the event, you will head over to section 2 below where the Live Event will be streamed.
Drag to resize
EXCEL ACADEMY BUNDLE OFFER
Become the expert in Excel
Get access to all three courses by Excel Academy (Excel 101: Fundamentals, Excel 202: Advanced Data Analysis and Excel 303: Macros and VBA). Instead of buying them separately, rather take advantage of this bundled offer and save.
Meet the instructors
Avi Levy
Avi finds efficient and simple solutions to complex problems by leveraging the power of Excel. He is passionate about Inspiring people to do the same. That’s why he joined Excel Academy, where he has the opportunity to help people become more productive and confident in their work.
Dan Stillerman
Dan Stillerman founded Excel Academy in 2014. This came after 4 years of working as an Actuary and pushing Excel to the limits, in the process transforming from an Excel disaster to an “Excel Master”. To date, the team has impacted tens of thousands people around the world through their fun and interactive training.
Live Event series for trainees
Outcomes
- What is Microsoft office 365?
- Introduction to excel and how you will be using excel as a first year trainee accountant.
- Important excel functions you will use daily.
- What is working papers and how does this work in excel?
Live Event series for trainees
Outcomes
The financial statement assertions and audit evidence:
- Understanding the financial statement assertions and their relevance in performing audit procedures.
- Understanding the requirements for sufficient appropriate audit evidence to prove the assertions.
Live Event series for trainees
Outcomes
Ethics masterclass dealing specifically with professional ethics:
- What are professional ethics?
- Why are professional ethics important for you?
- How do you make the right professional choices?
Live Event series for trainees
Outcomes
- Why is Cyber security important.
- What can go wrong?
- Email best practices with reference to cyber security.
- What to look out for, how to evaluate authenticity of emails etc.
- Like farming, phishing, click bait, malware.
Live Event series for trainees
Outcomes
- Why a personal budget is important?
- How to prepare your budget and what tools are available.
- How to use excel for this.
- Top 3 tips in personal finance!
Live Event series for trainees
Outcomes
- Operating within a remote/hybrid work environment internally and with clients.
- What is the change curve and how this relate to your new role as trainee accountant.
- Mastering time management within your new role as trainee accountant - use outlook calendar to your advantage!
- Your health is important – Understand the important of sleep, exercise and brain care.
Live Event series for trainees
Outcomes
- Operating within a remote/hybrid work environment internally and with clients.
- What is the change curve and how this relate to your new role as trainee accountant.
- Mastering time management within your new role as trainee accountant-use outlook calendar to your advantage!
- Your health is important –Understand the importance of sleep, exercise and brain care.
Live Event series for trainees
Outcomes
Risk of material misstatement:
- Understanding what audit risk is, and the three components that affect it.
- Understanding the impact of Risk of Material Misstatement on the nature, timing and extent of substantive audit procedures.
Live Event series for trainees
Outcomes
- In this master class trainees will touch on professional skills directly linked to developing their relational acumen and Winning with People.
- Communication skills, People skills, Relationship-building skills
Live Event series for trainees
Outcomes
- Introduction to Microsoft PowerPoint and Word.
- How to prepare a presentation in PowerPoint.
- How to prepare reports, letters and communications in word in a professional manner.
- .Tips and tricks to be more efficient in Word and PowerPoint.
Live Event series for trainees
Outcomes
Getting the most out of your CA2025 training contract experience:
- Understanding how the CA2025 training programme works.
- Developing the right attitude towards your training contract and the importance of regular reflection during the contract term.
- How assessment works and what to do to ensure that you get signed off at the end of the training contract as proficient.
Live Event series for trainees
Outcomes
- In this master class trainees will touch on professional skills directly linked to developing their relational acumen and managing people.
- Leadership skills, Managing others, Teamwork
Live Event series for trainees
Outcomes
Ethics masterclass dealing specifically with business ethics:
- What are business ethics?
- Why is understanding business ethics important for you?
- How do you evaluate the right business choices?
Live Event series for trainees
Outcomes
- What is emotional intelligence?
- Understand and manage your emotions.
- Understand the emotions of others working with you.
- How to get your emotions to work for you,not against you.
Live Event series for trainees
Outcomes
Developing effective communication skills:
- Understand the importance of effective communication in the workplace (written and verbal).
- Introduction to business writing for first year trainee accountants (including email etiquette).
- How to use Microsoft Outlook and draft professional business emails.
- How to use a translator if English is not your first language.
Live Event series for trainees
Outcomes
Ethics masterclass dealing specifically with personal ethics:
- What are personal ethics?
- Why are personal ethics important for you?
- How do you make the right personal choices?
Live Event series for trainees
Outcomes
Introduction to auditing:
- Why are audits conducted?
- What happens when auditors get it wrong?
- How are audits conducted?
- Where do I fit in this process?
- What is expected of me during the first year?
Dave Loxton
Bio
Dave is currently a partner at Schindlers Attorneys and the CEO of Schindlers Forensics (Pty) LTD.He was previously a partner/ director and head of the forensics departments at several of South Africa’s largest and most prestigious law firms, including ENSAfrica, Werksmans, Bowmans,as well as a brief stint at Dentons, and also spent several years as in-house counsel for one of South Africa’s largest blue-chip listed companies, specialising in employment law and litigation.He started his career as a State (Federal) Prosecutor, and prosecuted the complete range of street crimes, including rape, murder, robbery, drug-dealing, fraud, theft, forgery and uttering, and numerous other crimes. In private practice he has extensive experience in litigation matters, forensic due diligence, prosecution and his focus areas are fraud risk assessment and fraud prevention, ABC compliance, white-collar crime investigations, detection and prevention. He also conducts highly sensitive investigations for the board and chief executive officers of numerous private sector companies and provides regulatory advice and training to the private and public sectors. He is also considered an expert in Cyber Crime as well as Employment Law. David is considered a leader in his field and has been regularly recognised by independent legal directories including the Chambers and Partners Global Guide as well as Best Lawyer.He has been widely and regularly interviewed in the media on fraud, corruption and white-collar crime and cyber-crime and regularly shares his insights at conferences and seminars both inside and outside of South Africa.
Lizette Volkwyn
Bio
Lizette Volkwyn is a master life coach, published author, international keynote speaker, and one of only two certified PEI human lie detectors in South Africa.
She was born in Ladysmith, Kwazulu-Natal, and attended school in Germiston. Unable to attend university due to family circumstances, she started working as an administrative clerk and typist at a bank. Her passion for sales and marketing was sparked when she completed her estate agent diploma and joined the real estate industry, and her stint as realtor was followed by a corporate career in Office Automation and IT spanning more than two decades.
Despite her success, Lizette felt compelled to use her skills and knowledge to uplift others and help them realise their potential. This was the catalyst for the launch of her own consultancy. She embarked on a journey to obtain the necessary qualifications, completing her Master Life Coach course in 2012. This included a masters NLP Practitioner course. She also obtained her Positive Psychology certificate in 2020. In addition, she undertook the rigorous training involved in becoming a human lie detector to better understand her clients and to help them to rapidly achieve their desired results.
Today, in addition to her work as a human lie detector, Lizette offers personal life coaching, sales, leadership and communication training, self-discovery workshops, group coaching, and online marketing training. She has completed more than 25 000 one-on-one coaching hours with clients in more than 20 countries, and authored a book about self-discovery and exploration titled, Finding Me, which has sold more than 2 500 copies.
As a speaker Lizette has presented talks all over the world and has shared the stage with international thought leaders such as Robin Banks, Russell Fox, and Justin Cohen. She is also a regular guest on national radio stations, magazines, and international podcasts.
Lizette is often recognised for her work – in 2018 she was named one of the top three emerging entrepreneurs by Businesswomen of South Africa and was a Margaret Hirsch’s Businesswoman of the Year finalist. This was followed with a nomination for Changemaker SA in 2019, and Extraordinary Changemaker Africa in 2021. In 2021 she received a Business Excellence Award for Coaches and Mentors.
Lizette currently resides in Kempton Park with her husband of 36 years. The couple has three children and five grandchildren.
Dr Jerry Chetty
Bio
Dr Jerry Chetty is a Senior Manager at Santam’s Business Integrity Unit and manages the Forensics, Ethics and Intelligence teams. Jerry has over 20 years investigation experience and knowledge in the detection, prevention, and investigation of insurance crime. Jerry is regarded as a subject matter expert on insurance crime within the short-term insurance sector and has spoken at several conferences both locally and internationally. Jerry is an avid researcher on the topic of insurance crime and believes that research and knowledge sharingare powerful tools for forensic investigators. Jerry is currently redefining investigation methodology and creating the next generation forensic investigator at Santam to incorporate technology as a standard investigation tool.
Qualifications
Jerry has a PhD in Criminology, a LLM, LLB, BIuris, ND: Police Administration, Diploma in Victimology, Certificate in Anti-Money Laundering.
Professional membership
Jerry is:
Qualifications
Jerry has a PhD in Criminology, a LLM, LLB, BIuris, ND: Police Administration, Diploma in Victimology, Certificate in Anti-Money Laundering.
Professional membership
Jerry is:
- An Admitted Advocate of the High Court
- Chairperson of the Institute of Commercial Forensic Practitioners
- Forensic Practitioner (SA)
- Certified Fraud Examine
- Certified Ethics Officer
Annemari Krügel
Bio
Annemari is a Director in the Forensic Services Department at BDO and leads a team that makes a
pivotal contribution through our National Risk Advisory Service to all our business sectors. She
joined BDO in 2018 with the objective to establish a professional forensics team that could serve
the Southern African market. Her team at BDO, with the support of BDO International, provides a
comprehensive, integrated suite of Forensic Services, that specialise in fraud investigations, anticorruption
compliance, forensic technology services and financial reporting disputes.
Prior to her appointment at BDO, Annemari held various senior positions as a director or forensic
consultant.
Annemari started her career in the South African Department of Justice in 1984. By the time she
left the Department to join a Labour Law Practice, she was both an experienced senior prosecutor
and an experienced Magistrate. Her interest in labour related matters graduated to forensic
investigations when she immersed herself in matters where she collaborated with the South African
Police Service. These included several high-profile projects in Gauteng and the North West
Province, on behalf of Local and Provincial Government, that successfully exposed and prosecuted
corruption, fraud, statutory and other related offences where she acted as lead forensic
investigator. Subsequently, she presided over and initiated in a multitude of disciplinary matters on
behalf of the Auditor-General, Teta, Provincial Treasuries in the North West, Limpopo and Gauteng,
Department of Health, Department of Sport and Recreation, City Power and Autopax in cases that
involved the misuse or misappropriation of billions of rands. These positions often included work
associations with preeminent law firms throughout Southern Africa. She is a valued member of the
Executive Team with experience that spans more than forty years in criminal justice, forensic
investigations and prosecutions.
Qualifications
Qualifications
- B. Iuris Labour Law and Human Rights
- M.Phil. Labour and Workplace Law
- Certified Fraud Examiner (CFE)
Advocate Stefanie Fick
Bio<