Our
considerable experience with Microsoft Office Excel shows us that this
program is like an ocean of possibilities, where you can constantly find new
things, and most importantly - practically applicable in life. Once you have the basic knowledge and skills to work with Microsoft Office Excel, it is essential to continue the gradual development to reach the heights. Those who skip the in-between increase the risk that many things can become complicated, unclear and confusing. If this happens, people lose the desire to learn and go for the goal. This principle is vitally proven. In the intermediate course, my goal is to help you master Excel at an intermediate level and use the program effectively. Pre-requisites: Microsoft Office Excel installed on your PC Basic Excel skills and knowledge Willingness to learn and practice Who is this course for? For those who already have a basic level of Excel knowledge and skills but want to deepen them For those who need to use Excel on a daily basis at work. For those who are interested in Excel and its capabilities Who this course is for: Those who already have a basic level of Excel knowledge and skills but want to deepen them Those who need to use Excel on a daily basis at work Those who are interested in Excel and its capabilities What you will learn Apply sorting and filtering tools in a database (DB) Find and eliminate duplicates in the database Work with functions specifically designed for use in a database Validate (verify) data You will become a confident user of the Pivot Table and Summary Chart Import and export data from text files Create a variety of charts Work with Power Pivot and its basic tools Explore important Excel printing options Work with 3D (pass-through) formulas Consolidate data And much more Course content 10 sections - 57 lectures - Total duration 3 hrs 17 mins
|