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
Ratings 4.06 / 5.00
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
Description
Do you want to be more productive with Excel?
Whether you’re a basic Excel user who wants to take your skills to the next level, or someone who’d like a “best practice” refresher, here's your way to learn a whole range of skills that will enhance the speed and quality of what you achieve with Excel..
With every ZandaX Microsoft course, you get a workbook and exercises (downloadable from the short “General Introduction” module at the start of each course). These are a great addition because they enable you to practice the skills you learn.
Our Microsoft instructors are seasoned professionals - they don't just know the software: they've used it commercially and taught it in a classroom environment for years. You won't be in better hands!
And we don’t woffle! Do you want to sit through hours of over-explaining before you get the knowledge you need? We doubt it! So we make sure that everything is covered in easy-to-follow video lessons, and we get to the point so you make the best use of your time.
The course teaches you how to use formulas and functions - probably the most important step that everyone makes - but also shows you how to use tables, manage data in Excel and add to your work with enhanced chart options and SparkLines.
Each lecture is self-contained, so you don’t need to sit through them all: once you’re at a comfortable level, you’ll be able to use this as your reference library, where you can select what you want to view.
We’ll say it again: don’t forget the course workbooks and exercises – downloadable with the first “General Introduction” module in each course – which really enhance and deepen your learning. Remember that practice makes perfect!
So this course is genuinely much more than just a talk-through video. We don’t think you’ll find better value, so why not enrol with us now?
Who Should Attend!
- You may have a basic understanding of Microsoft Excel and want to improve your skills and knowledge of the software
- Or you could be an existing user who wants a "refresher" to clarify a few hazy areas, or even unlearn some bad habits!
- Above all, we want you to get the most from your training, so make sure you enjoy your time doing the course, and revisit it as often as you want
