
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