Description
In Class & Live, Online Training(Microsoft Excel)
You will learn:
- Create a formula-safe data entry template that may be reused.
- Apply conditional formatting to sales data analysis.
- Using editing tools, formulae, and Flash Fill, connect, prepare, and validate data.
- Navigate and alter worksheets and workbooks with ease.
- Construct decision-making IF functions and visually display the results
- Combining Data and 3-D formulas.
- With conditional formatting, graphing, sparklines, and printing parameters, you can present and analyse data.
- PivotTables can be used to analyse summary data and create a rapid dashboard.
- Use formulas, functions, and names to create an income and cost statement.
- Tables and slicers can be used to find, sort, and select detail data.
Who Should Participate:
- There are no pre requisite’s for this course.
Topics Covered:
- Advanced PowerPoint 2016
- PowerPoint for Mac
- Advanced PowerPoint for Mac
- Word 2016 Expert for Mac
- Word 2016 Mail Merge for Mac
- End User Security Awareness
- Skype for Business
- Outlook 2016
- Outlook on the Web
- Word 2016 Essentials
- Access 2016 Essentials
- Excel 2016 Essentials
- Excel 2016 Essentials for Mac
- Excel 2016 Advanced
- Excel Charts and Pivot Tables
- Excel Functions
- Relational Database Design
- PowerPoint 2016
- Word 2016 Advanced
- Word 2016 Expert
- Word 2016 Mail Merge
- Word 2016 Essentials for Mac
- Word 2016 Advanced for Mac
Frequently asked questions: Can I take this course online? Yes
Reviews
There are no reviews yet.