Microsoft Online Trainings
Training Excel 2016
What does the training contain?
This training is dedicated to both beginners, interested in gradually discovering the vast possibilities offered by Excel 2016, as well as more experienced users, looking for proven ways to leverage the full potential of Excel formulas to boost their working performance.
What are you going to learn?
• Program handling and data input methods
• Practical use of Excel formulas
• Creating data charts
A Microsoft Excel 2016 training for everyone!
In the training on Excel 2016, you will learn how to effectively work with data cells. In doing so, you will delve into a number of highly reliable methods for formatting, sorting and filtering entered data as well as grouping thematically related information. You will learn how to use the conditional formatting feature and the Excel status bar in your day-to-day work with the program. The training will also introduce you to the principles underlying the process of designing charts and sparklines based on specific data. Moving further, you will familiarize yourself with the very kernel of the program, i.e. formulas, including financial, logical and text functions as well as formulas related to date and time. The skills obtained in the course of the training will enable you to effectively use the program tools to spare your valuable time. You will also learn how to create tables and pivot charts. Not only that, you will familiarize yourself with the concept of macro commands, enabling you to automate frequently performed actions. Apart from that, you will delve into a number of data analysis tools and learn how to save a ready workbook in order to share it with customers and colleagues.
You can start this topic for free
- Unlimited access to training course
- Interactive lectures and exercises
- Tips and knowledge of Microsoft experts
- Course Completion Certificate
And get access to the topic that interests you!