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.
|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|
CompuWorks is a collaborative of computer training specialists with over 25 years’ experience teaching students how to get the most out of their technology tools. CompuWorks innovative elearning videos display trainers on screen all the time creating a learning experience that most closely mimics a traditional classroom.
30 day money back guarantee
Available on desktop, iOS and Android
Certificate of completion
Hours of video content