Microsoft Excel – Basic to Intermediate

By RKY Tutor Categories: Microsoft
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Our Basic to Intermediate Excel Training is designed for everyone!

Microsoft Excel is an essential tool and the most popular spreadsheet software across
different job roles and levels worldwide. This class enables you to start from the basics and
build a solid background in Formatting, Analysis, Reporting, and Dash Board Creation.

The course is designed for those with little or no functional knowledge of Excel and those who regularly use Excel at a basic level but wish to enhance their skills. From basic operations to an introduction to more advanced techniques, within 8 weeks, you’ll gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations, and produce creative charts and graphs from your data while building an aptitude for data analysis that is critical to the success of any organization.

Show More

What Will You Learn?

  • Master Microsoft Excel from Beginner to Intermediate
  • Build a solid understanding of the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office across different job roles
  • Harness the full power of Microsoft Excel by automating your day-to-day tasks
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Impress your Manager by unlocking dynamic formulas with IF, VLOOKUP, XLOOKUP, INDEX, MATCH, AND, OR functions, and many more

Course Content

INTRODUCTION TO EXCEL (BASIC TO INTERMEDIATE)

  • Getting Started with Excel
    35:37
  • Data Cleaning 1
    31:14
  • Data Cleaning 2
    27:17
  • Working with dates 1
    30:38
  • Working with dates 2
    20:36
  • Statistics/Conditional Functions and Formulas
    32:19
  • Text Functions & Data Separation
    22:27
  • Working with Data, Formulas and Functions
    37:23
  • Working with Large Worksheets
    22:34
  • Conditional formatting & Cell Reference
    30:23
  • List Management
    34:26
  • Lookup Function
    38:48
  • Intro to Pivot table & Charts
    36:35
  • Graph in Excel
    27:19
  • E-Books
  • Excel Shortcuts
  • Excel Formulas
  • Intro Pivot Table, Slicer & Dashboard 2
    01:04:13

Alunmi Community

Student Ratings & Reviews

No Review Yet
No Review Yet