Microsoft Excel Formulas & Functions, Data Tools and More
Learn formulas & functions, tables, spreadsheet data tools and charts to take your Excel skills to the next level
4.19 (36 reviews)
3,371
students
3.5 hours
content
Oct 2022
last update
$49.99
regular price
What you will learn
Our EXCEL INTERMEDIATE course will give you a solid understanding of Excel Formulas & Functions, along with more advanced tools and concepts
The course has its own workbook with exercises – downloadable in the “General Introduction” module – so you can practice and reinforce what you have learned
Enhance your skills and the quality of your work with Formulas & Functions, using Tables, managing data, doing more with Charts and using SparkLines
Formulas & Functions - Absolute References - Autosum Functions - IF & Nested Functions - Named Ranges - Array Functions - Formula Auditing - Text Functions
Advanced File Tasks - Saving & File Management - Converting & Encrypting Files - File Properties & Digital Signatures - File Accessibility & Compatibility
Managing Tables in Microsoft Excel - Creating Excel Tables - Working with Records and Filters - Advanced Filters
Data Tools in Excel - Text to Columns - Flash Fill - Remove Duplicates - Data Validation - Consolidate
Doing More with Charts in Excel - Trendlines - Error Bars - Working with Axis Options - Advanced Chart Formatting
Sparklines - Creating Sparklines - Editing Sparklines
Screenshots
Related Topics
2153002
udemy ID
1/15/2019
course created date
11/20/2019
course indexed date
Bot
course submited by