Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
|If you would like to work along with the instructor, please download the attached .zip file, which contains all the files used throughout this course.|
|Section 2: Using Advanced Functions|
Help with FunctionsPreview
|Section 3: Conditional Formatting and SparkLines|
Applying Conditional FormatsPreview
Managing Conditional Formats
Modifying SparkLine Styles
|Section 4: Managing Data|
Working with Tables
Sorting a List
|Section 5: Using PivotTables, Pivot Charts, and Slicers|
Creating and a Pivot Table
Filtering and Sorting
Filtering with Slicers
Adding a PivotChart
|Section 6: Analyzing Data|
Auditing and Error Checking
Using the Scenario Manager and Goal Seek
|Section 7: Importing and Exporting Data|
Transferring between Word and Excel
Importing a Text FilePreview
Transferring between Access and Excel
|Section 8: Conclusion|
At Intellezy, we believe learning should be simple, engaging, and relevant. We make this possible by building innovative, short-segment eLearning videos and easy-to-use quick reference cards designed to educate and empower companies and individuals. In today’s rapidly evolving workplace it is imperative to make sure you have the skills required to succeed. Our library provides dynamic, task-focused videos right at your fingertips, right when you need them. Our goal? To educate the world, one video at a time.