Career Computer Skills Multimedia Bundle
Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro
This course is not an introduction to Excel. It features some of the most powerful and effective tools and techniques used by Excel professionals, and shares them through crystal-clear demos and unique, real-world case studies.
Unlike most Excel courses, this course is non-linear and constantly evolving, which means that you can jump to different sections or individual lectures freely. Each video is designed to be an independent and self-contained demo, to help you learn these tools and techniques in quick, bite-sized lessons.
The Excel tips and techniques covered in this course fall into six categories:
- Productivity tips (navigation, flash fill, cell protection, advanced sorting & filtering, and more)
- Formatting tips (freeze panes, row/column grouping, advanced custom formats, and more)
- Formula tips (formula auditing tools, fuzzy lookups, detecting duplicates, randomization, and more)
- Visualization tips (sparklines, filled maps, custom templates, Excel form controls, and more)
- Pivot Table tips (slicers & timelines, custom layouts, value calculations, and more)
- Analytics tips (outlier detection, Monte Carlo simulation, forecasting, CUBE functions, and more)
While the level of difficulty varies considerably, the demos generally start simple and become progressively more complex within each section. There are no strict prerequisites for this course, but keep in mind that some demos may be challenging without a strong foundational knowledge of underlying Excel concepts (such as Pivot Tables or formulas, for example).
The codes are placed in the GitHub link as below-
About this Bundle
Learn multiple critical components of everyday computing and build up your skills with the brand-new Career Computer Skills Multimedia Bundle - featuring 12 new-to-Fanatical products!
Across a range of eBooks and video courses, you’ll be able to approach in-depth topics on a whole spectrum of computing-based subjects from security and business use to programming and software development.
Get to know the basics of cybersecurity awareness, social engineering, and network security and learn the skills you need to prevent attacks and breaches with The Beginners 2021 Cyber Security Awareness Training Course; and boost your confidence when working with advanced data visualizations, data mining, and machine learning with Power BI for Business Professionals.
Get a masterclass in improving your coding skills as well as sprucing up your portfolio to become more appealing to job opportunities with Careers in Programming: How to Get a Great Coding Job (2019); and delve into user behavior analytics to solve challenges faced while designing user interfaces with Learn Human-Computer Interaction.
Find these and more fantastic, easy-to-use courses right here with the Career Computer Skills Multimedia Bundle. All eBook products in this bundle are available in EPUB, MOBI, and PDF format (video courses MP4).