Microsoft Excel

• Lectures: 1
• Students: 92
• Duration: 3 weeks

Microsoft Excel is the world’s most popular spreadsheet application. Master Pivot tables, formulas, Macros, Data analysis. In this course you will learn how to Create and edit worksheet, work with formulas and functions, Create and edit charts, Format, organize and retrieve Data from data sources,  Use Data Visualization, Lookup functions, Master Charts, Pivot Tables, and Printing. The course is divided into 4 modules. You will learn step-by-step with hands on projects how to create, edit and use formulas. By the end of the course you will be confident to use Microsoft Excel.

• The topics covered in module 1 are:
  • Create, save, and open an Excel workbook
  • Enter and edit labels and values in a worksheet
  • Use the SUM function to build a simple formula
  • Format a worksheet with font attributes, borders, fill, cell styles, and themes
  • Modify columns and rows in a worksheet
  • Insert, delete, and move worksheets in a workbook
  • Modify the appearance of a workbook by adjusting zoom size, changing views, and freezing panes
  • Review and prepare a workbook for final distribution by spell checking, setting properties, and adjusting page setup options
• The topics covered in module 2 are:
  • Build and edit basic formulas
  • Set mathematical order of operations in a formula
  • Use absolute, mixed, relative, and 3D references in a formula
  • Use formula auditing tools in a worksheet
  • Work with Statistical and Date & Time functions
  • Work with functions from the Financial, Logical, and Lookup & Reference categories
  • Build functions from the Math & Trig category
• The topics covered in module 3 are:
  • Create Excel chart objects and chart sheets
  • Use quick layouts and chart styles to design a chart
  • Edit chart elements including titles, data labels, and source data
  • Format chart elements with shape styles, fill, outlines, and special effects
  • Use pictures, shapes, and WordArt in a chart
  • Build pie charts and combination charts
  • Create sunburst and waterfall charts
  • Insert and format Sparklines in a worksheet
• The topics covered in module 4 are:
  • Create and format a list as an Excel table
  • Apply Conditional Formatting rules as well as Color Scales, Icon Sets, and Data Bars
  • Sort data by one or more columns or by attribute
  • Filter data by using AutoFilters and creating an Advanced Filter
  • Use subtotals, groups, and outlines for tabular data in a worksheet
  • Import data into an Excel worksheet from a text file, a database file, and other sources
  • Export Excel data as a text file into a Word document
  • Build and format a Pivot Table