Description: Build professional, shareable Excel 2016 workbooks using conditional logic, PMT loan modeling, headers/footers, hyperlinks, HTML export, and graphical tools.
Search Results for: "Excel"
Free PDF Courses for "Excel" (57)
Microsoft EXCEL Training Level 3
Description: Master PivotTables, slicers, timelines, PivotCharts and calculated fields in Excel Level 3. Includes hands-on exercises and projects for analysts and managers.
Microsoft EXCEL Training Level 2
Description: Explore in-depth Microsoft Excel Level 2 training covering data analysis, formatting, formulas, charting, and advanced functions to enhance your productivity.
Microsoft EXCEL Training Level 1
Description: Learn the fundamentals of Microsoft Excel with our comprehensive Level 1 training guide. Master formulas, formatting, data management.
Data Dashboards Using Excel and MS Word
Description: Learn to build automated data dashboards using Excel and Word: dashboard design, Word templates with bookmarks, Excel data structuring, and report automation.
Excel 2013: Advanced Excel Tools
Description: Boost productivity with Excel 2013: nested functions, macros, templates, data linking and worksheet protection. Includes practical tips and hands-on projects.
Making Graphs In Microsoft Excel 2013
Description: Master Excel graphing with this comprehensive tutorial on creating and customizing graphs in Microsoft Excel 2013, perfect for beginners and pros alike.
Access 2016 - Reports & Queries
Description: Learn how to create reports, use queries, and import Excel data in Access 2016. Step-by-step instructions for beginners and professionals.
Conducting Data Analysis Using a Pivot Table
Description: Learn to conduct powerful data analysis using Excel pivot tables. This guide covers basics to advanced techniques with practical exercises for all skill levels.
VBA Notes for Professionals book
Description: Download free VBA Notes for Professionals PDF. Learn variable declaration, string comparisons, debugging techniques, and module access. Perfect for beginners.
Learning VBA
Description: Download free Learning VBA PDF. Learn Visual Basic Editor, Debugging Techniques, Macro Security, and Object-Oriented VBA. Perfect for beginners and developers.
Getting Started with Power BI
Description: Download free Getting Started with Power BI PDF. Learn datasets, reports, dashboards, and visualization techniques. Perfect for beginners.
Word 2016 - Mail Merge and Creating Forms
Description: Learn to create fillable forms, restrict editing, save templates, and use Mail Merge in Word 2016 with our detailed, step-by-step guide.
Visio 2013 Workshop
Description: Microsoft Visio 2013 with this comprehensive workshop guide, covering flowcharts, organizational charts, floor plans, and database diagrams for beginners
Access 2013: An introduction
Description: Master Microsoft Access 2013 with this comprehensive guide covering data entry, queries, forms, and reports — perfect for beginners and intermediate users.
Tally.ERP 9 at a Glance
Description: Download free Tally.ERP 9 at a Glance PDF. Learn report generation, scenario creation, inventory management, and data import. Perfect for beginners.
97 Things Every Programmer Should Know
Description: Programming wisdom from industry experts! 97 actionable tips to improve your coding skills, avoid pitfalls, and become a better developer. Free GitBook edition.