Tools of the Trade: Day-To-Day Excel Hacks You Need To Know

certification logo17943       

CEU Approved | Pre Recorded

  • 75 minutes

The purpose of this webinar topic is to SAVE YOU TIME! These are the old-school tips and tricks that have been forgotten by so many Excel users. You will learn from a seasoned Excel trainer that still uses these amazing techniques on a daily basis

In this webinar, expert speaker Andy Lanning will give excel tips and tricks to navigate through large spreadsheets with a high volume of data. Upon completion of the course, you’ll be able to use Excel features and functions such as:

Session Highlights:

  • Split Screen

  • New Window

  • Watch Window

  • Split Text from One Column to Two

  • Combine Text from Two Columns to One

  • Auto Calculate Feature

  • Remove Duplicates

  • Transpose Data

  • Conditional Formatting 

  • Formula Auditing
  • Protect a Worksheet or Workbook

Why You Should Attend:

These amazing features have been around Excel since its inception, and yet hardly taught anymore. They are given new life in this webinar! They will change how you handle your spreadsheets and data projects and make you more efficient and productive in just one session.

Who Should Attend:

  • Accountants

  • Accounts

  • Audit

  • Aviation

  • Banking

  • CFOs

  • Controllers

  • CPAs

  • Education

  • Energy

  • FDA

  • Finance

  • Financial consultants

  • Human Resource

  • Insurance

  • Investments

  • IT

  • Logistics & Supply Chain

  • Marketing

  • Medical Devices

  • Pharmaceutical

  • Retail

  • Sales

  • Telecom

Advanced Preparation: None

Program Level: Intermediate

Prerequisites: Basic knowledge of Excel

Field of Study: Computer Software & Applications

*You may ask your Question directly to our expert during the Q&A session.
** You can buy On-Demand and view it as per your convenience.

Andy Lanning

Andy Lanning

Andy Lanning is the owner of Computer Software Training LLC, a computer consulting business. Ms. Lanning has over 20 years of experience teaching computer software in academic and corporate settings. She is a Certified Microsoft Office Specialist. Ms. Lanning is currently an instructor at Boise State University and previously at College of Western Idaho. She is a graduate of Boise State University.

No Reviews Found

Edupliance is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.

Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: For more information regarding administrative policies such as complaint and refund, please contact our offices at 844- 810-1151.

PLEASE NOTE: To receive credit through the NASBA for this program you MUST attend the Live program in its entirety and complete the required progress checks.

Number of CPE Credits Awarded for This Course: Computer Software & Applications – 1.0

Delivery Method: Group Internet Based

Want to attend in a Group? Call 844-810-1151 and Save upto 50%

  • $259.00

  • $164.00

  • $164.00

  • $164.00

  • Total : $00.00

Share this course with a friend


Get Notified about News, Webinars, Community & More