Microsoft Excel Training: Learn Essential Excel Skills

Microsoft Excel Training: Learn Essential Excel Skills

All Exercise Files are Included

What you’ll learn

  • Worksheet basics: Creating a worksheet, Entering data automatically with Auto Fill, Inserting/deleting cells, columns, and rows, and cell formatting.
  • Excel Formula Basics: Adding numbers using Sum and AutoSum, working with numbers in columns, using IF, using SUMIF and AVERAGEIF, naming and using cell ranges.
  • Excel Formatting: Adjusting fonts, colors, adding pictures, shapes and borders, inserting SmartArt, built-in styles and creating and using templates.
  • Printing: Inserting headers and footers, generating PDFs.
  • Data Analysis: Named ranges, data validation, data sorting and filtering, working with goal seek and using the scenario manager in excel.
  • Dealing with large data: Using Find and Replace, managing worksheets, applying formulas across multiple worksheets.
  • Discovering PivotTables: Creating and modifying a PivotTable and a PivotChart.
  • Charts: Choosing chart types, inserting sparklines, creating and modifying a column chart and a pie chart.
  • Macros: Understanding, recording, using and editing a macro.

Requirements

  • Nothing! This course assumes you are a beginner to Excel.

Who this course is for:

  • Students who have little or no familiarity with Microsoft Excel or more experienced Excel users who want to learn the topics covered in this course.

Tags:

Tutorial Bar
Logo