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.
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