Microsoft Excel from Beginner to Advanced

Overview

Microsoft Excel is a powerful tool you can use to create and format spreadsheets and analyze and share information to make more informed decisions. As you participate in master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics. At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace.

Course Objectives

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Microsoft PowerPoint from Beginner to advanced

PowerPoint is one of the best and most popular tools today for creating great presentations. Whether you are an IT Pro or just casual Office PowerPoint user, this course, Using Office PowerPoint 2016, will teach you the latest additions and features of PowerPoint 2016. First, you will learn how to set up your PowerPoint presentation. Next, you'll learn all about features and functions you can integrate into the presentation for a rich and dynamic experience. Finally, you'll learn about the different ways to present, publish, and share a finished PowerPoint presentation. By the end of this course, you'll be able to use PowerPoint like a pro and give fantastic presentations every time. At completion of this course you will master PowerPoint skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks.

Course Objectives

  • Create a PowerPoint presentation from scratch
  • Add animation to text, shapes and pictures
  • Learn how to create handouts and speaker notes
  • Zip around in your presentation fast with numerous shortcuts
  • Go further with more advanced animation including motion paths