Live Sessions and Courses

AI & Office Productivity Tools

The AI and Microsoft Office Suite course teaches participants how to integrate AI tools with essential Microsoft applications, including Word, Excel, PowerPoint, Microsoft Forms, Teams, and Outlook. Learners will discover how to enhance productivity, streamline tasks, and leverage AI features to improve efficiency. This practical course empowers individuals to harness technology for smarter work solutions.

Explore Outline

413,961 already enrolled!

Course Detail

AI Tools, Word, Excel, PowerPoint, Google Forms,

Course Features

  • Live Class Sessions.
  • Recorded videos (on course portal).
  • 24/7 Instructor Support.

Ernest Larbi Okai

Instructor

Okai Larbi Ernest is a seasoned professional with extensive experience in the IT Training using Power BI, Excel, Microsoft Word, PowerPoint, Outlook, Teams and other PowerApps

  • 20 hours on-demand video
  • Full Lifetime Access
  • Access on Mobile and TV
  • Certificate of Completion

Course Content

11 sections • 28 lecture • 19h 33m total length

Importing Data:

  • Importing CSV and Excel files.
  • Importing data from web and other external sources.

Data Cleaning:

  • Removing duplicates.
  • Handling missing values.
  • Text-to-Columns for parsing data.
  • Using Flash Fill for quick data formatting.

Sorting and Filtering:

  • Sorting data by single or multiple columns.
  • Filtering data using AutoFilter.

Conditional Formatting:

  • Highlighting cells based on rules.
  • Using data bars, color scales, and icon sets.

Basic Formulas:

  • Arithmetic operations (SUM, AVERAGE, MIN, MAX).
  • Counting functions (COUNT, COUNTA, COUNTIF).

Text Functions:

  • CONCATENATE (or CONCAT), TEXTJOIN.
  • LEFT, RIGHT, MID.
  • TRIM, LEN, FIND, SEARCH.

Logical Functions:

  • IF, AND, OR, NOT.
  • Nested IF statements.

Lookup and Reference Functions:

  • VLOOKUP, HLOOKUP.
  • INDEX and MATCH.

Date and Time Functions:

  • TODAY, NOW.
  • DATE, DATEDIF, YEAR, MONTH, DAY.

Array Formulas and Functions:

  • Basic introduction to array formulas.
  • Using array functions like TRANSPOSE, SEQUENCE.

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum volutpat volutpat pretium. Nulla eu massa rutrum, aliquam eros non, elementum erat. Maecenas vulputate risus id est sodales consequat. Praesent aliquet, enim at ornare placerat, mi turpis egestas elit, quis sodales leo arcu ut ex. 

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum volutpat volutpat pretium. Nulla eu massa rutrum, aliquam eros non, elementum erat. Maecenas vulputate risus id est sodales consequat. Praesent aliquet, enim at ornare placerat, mi turpis egestas elit, quis sodales leo arcu ut ex. 

Start Getting New Knowledge and Experience, Together!

Embark on a journey of discovery and growth as you explore new knowledge and experiences alongside others!

Register Now