About this Course
This on site company private course is adapted at the level of the participants
Participants: From 2 to 6 people
Instructor: Microsoft Excel Certified trainer
Date: According to your availability
Audience profile
Anyone who uses Microsoft Excel and needs to acquire the knowledge, skills and techniques to design formulas, create and edit worksheets and present data results.
Knowing how to leverage Excel enables you to simplify complex tasks, essential to daily work responsibilities. In this course, you gain the skills needed to create Excel worksheets, develop formulas and apply sophisticated formatting to capture and present your data.
Teaching Methodology
Mixed sessions of theory and practice, with description of the subjects by the trainer and experimentation in the personal computer. Exercises and role plays to practice individualized resolution
Summary and commercial proposal
- Numbers of day: 1 day
- Software in English Version Excel 2013
- Time : 9:00 to 12:00 & 13: 30 to 17:00
- Certificates: Each participant receive a Besteam Certificate of Achievement
- Material: Excel 2013 User Guide – Softcopy
Course Outline:
- The spreadsheet model
- Navigating the interface
- Basic data editing
- Acquiring and Conforming Data
- Importing data from outside sources
- Excel tables and lists
- Worksheet Formatting and Presentation
- Initial formatting
- Worksheet presentation
- Innovative formatting
- Leveraging Formulas and Functions
- Formula basics
- Extending formulas and functions
- Auditing worksheet formulas
- Creating a Visual Presentation of Data
- Charting your data
- Printing workbooks
- Introducing Advanced Excel Features
- PivotTable basics
- Final workbook touches
Creating and managing macros