ORT Jet | Excel Power Hour Series with Excel Academy

Thu Feb 25, 08:30 - Thu Mar 18, 09:30

Event is online

ABOUT

In this fun and interactive 4-part Excel series, exclusive to ORT Jet, you can look forward to discovering many practical tips, techniques and best-practices for working smarter in Excel on a day-to-day basis.


You are guaranteed to learn something new in each session, regardless of whether you consider yourself a beginner or a seasoned Excel jockey.


Session 1: Excel fundamentals - Thu 25 Feb 8:30 - 9:30 SAST


Building a solid foundation in Excel is critical – so many of us are self-taught and have major gaps in our knowledge. This session will help to lay that solid base on which to build and expand your skills in the upcoming sessions. Topics include:



  • Navigating the Excel interface
  • Working with data – inputting and editing
  • Creating lists of hundreds or thousands of cells in a matter of seconds
  • Appreciating keyboard shortcuts and the value of becoming a keyboard person


Session 2: Fundamentals of formulas - Thu 4 Mar 8:30 - 9:30 SAST



  • The building blocks of any formula in Excel
  • Difference between a formula and a function
  • Some basic mathematical and text functions, such as SUM, AVERAGE, MAX, MIN, PROPER, TRIM.


Session 3: Data structure and formatting - Thu 11 Mar 8:30 - 9:30 SAST



  • Working in Table mode
  • Formatting your data so it looks professional and tells the right story
  • Text to columns and the CONCAT function to split/join data in columns


Session 4: PivotTables and PivotCharts - Thu 18 Mar 8:30 - 9:30 SAST



  • How to convert your data into beautiful PivotTable dashboards and reports, so that you can make better business decisions.
  • Formatting your PivotTable so it looks slick and professional
  • Converting a PivotTable into a PivotChart
  • Drilling down into your PivotTable