Weekend Lessons

This event has passed

Basic to Intermediate Excel for Work | Two-day Workshop

Start
June 1, 2024
End
June 2, 2024
Time
9:00 am - 5:00 pm
Timezone
UTC-5
Address
Online ( Instructor-Led)   View map
TIME ZONE:
U.S. Eastern Standard Time

$295.00

Availability: 25 in stock

Status

Sign yourself up (or your staff) for a comprehensive 2-day, 16-hour hands-on Excel workshop designed to make you more efficient at work. Become a needed and more productive member of your team. Excel is a highly-demanded skill set to have in office settings when working with data in office administration and other clerical tasks.

We will train you using a hands-on method that challenges you to actually learn the subject. This includes practices and a final test that we will grade at the end to measure what you have learned. At the workshop end, you’ll possess the proficiency to solve up to intermediate level problems using Excel.

Example Use Cases:

  • Administrative assistant
  • Virtual assistant
  • Keeping records and reports
  • Data entry
  • Organizing data
  • Accounting clerk
  • Business analyst
  • Cost estimator
  • Data analyst
  • Project manager
  • Market research
  • Information clerk

 

Takeaways:

 

Basics/Fundamentals

  • Basic mathematic operations
  • BODMAS (brack of division, multiplication, addition and subtraction)
  • Relative and absolute cell reference
  • Sorting
  •  Filtering
  • Data validation
  • Conditional formating
  • Functions (sum, count, if-conditions, countif, sumif, max, min, and, or, transpose, ifError, sumProduct, concat)

Intermediate

  • Vlookup
  • Macros
  • What-if-anaylysis
  • Forecasting
  • Index match

Our Teaching Method:

  • We will teach and explain concepts with practical examples
  • Students will be given practice exercises to complete during class
  • Hands-on practicals are designed to keep learners engaged
  • Graded tests at the end to measure each student’s learning
  • Students will use graded test results to know what to revise more

 

Preparation:

  • No prior knowledge of Excel is required.
  • Basic computer literacy and familiarity with using the web.
  • For more in-depth tasks, access to Excel Desktop version. The latest version (as of 2016) provides a robust platform for learning and mastering Excel. The online version doesn’t support features like macros, VBA (Visual Basic for Applications), advanced charting , advanced dashboarding, forecasting sheet and certain data analysis.
  • Willingness to learn and engage in hands-on practical exercises.
  • Ability to follow instructions and actively participate in the learning process.
  • Access to a computer with internet connectivity for accessing course materials and completing assignments.
  • A certificate will be awarded for completing this training.

Total Course Hours:

16 hours spread over 2 days.

Refunds:

Sometimes plans change. We recognize that. Should you find yourself unable to attend a class or workshop, kindly notify us via email at least 7 days prior to the scheduled event date. Please note that cancellations made within a week of the class or workshop will not be eligible for refunds.

Need Custom Date/Time for Your Team?

We can customize workshop dates/times specifically for your team to fit your operation. Simply contact us with your request.

Shopping Cart