Microsoft Excel Training, in this course, students will use Microsoft Excel to streamline and enhance spreadsheets with a wide variety of techniques such as templates, charts, graphics, and formulas. Students will apply visual elements and advanced formulas to a worksheet to display data in various formats. Course covers the basics of how to use Microsoft Excel and explains things such as how to format tables and also how to customise the excel environment.
Microsoft Excel Training includes:
Calculating Data
Organizing Worksheet and Table Data
Presenting Data Using Data
Pivot Tables and Pivot Charts
Insert Graphical Objects
Customizing Workbook & the Excel Environment
Level: 2
Duration: 7 hours
Microsoft Excel Training includes:
Calculating Data
- Manage Cell and Range Names
- Calculate Data Across Worksheets
- Use Specialized Functions
- Analyze Data with Logical and Lookup Functions
Organizing Worksheet and Table Data
- Create and Modify Tables
- Format Tables
- Sort or Filter Worksheet or Table Data
- Calculate Data in a Table or Worksheet
Presenting Data Using Data
- Create a Chart
- Modify Charts
- Format Charts
Pivot Tables and Pivot Charts
- Create a PivotTable Report
- Analyze Data Using PivotCharts
Insert Graphical Objects
- Insert and Modify Pictures and ClipArt
- Draw and Modify Shapes
- Illustrate Workflow Using SmartArt Graphics
- Layer and Group Graphic Objects
Customizing Workbook & the Excel Environment
- Customize the Excel Environment
- Customize Workbooks
- Manage Themes
- Create and Use Templates
Level: 2
Duration: 7 hours
Copyright © by SysTech Savvy Inc. All Rights Reserved. | Privacy Policy | Terms of Use | Disclaimer | Site Map