Are you looking to become a proficient Word and Excel user? Professional Word and Excel training from CSCDC can get you on the path to mastering this popular data spreadsheet and Documenting software.

DURATION:

1 Month

Microsoft Word and Excel  are the industry standard spreadsheet and Documenting program used for data calculations, analysis, visualization, and much more.

Course Objectives

  • Master Microsoft Word and Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Word and Excel
  • Learn the most common Excel functions used in the Office and formatting tools in Word
  • 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
  • Access to a Professional Trainer with 10+ years of Excel Training

Course Content

  • Getting Started with Microsoft Office Word and Excel 2016
  • Formating a Document and different saving options
  • Modifying a Worksheet
  • Performing Calculations
  • Formatting a Worksheet
  • Printing Workbooks
  • Working With Functions
  • Working With Lists
  • Analyzing Data
  • Visualizing Data With Charts
  • Analyzing Data With PivotTables and PivotCharts
  • Working With Multiple Worksheets and Workbooks
  • Using Lookup Formulas and Formula Auditing
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Creating Sparklines and Mapping Data