LEARNING FOR LIFE

Get Yourself a Better Life! Free eLearning Download

Linkedin – Learning Cert Prep Powerpoint Associate Microsoft Office Specialist for Office 2019 and Office 365-BiFiSO

Leave a Comment

Linkedin – Learning Cert Prep Powerpoint Associate Microsoft Office Specialist for Office 2019 and Office 365-BiFiSO
English | Size: 0.98 GB
Category: Tutorial


Demonstrate your knowledge of Excel 2019 by becoming a Microsoft Office Specialist (MOS). Get training to prepare for the Excel Associate certification exams for Office 365 and Office 2019. This course, created by Microsoft Certified Instructor and MOS Master Jennifer McBee, helps you prepare for the five main areas of focus for the Excel Associate Office 365 and Office 2019 exams: managing worksheets and workbooks, managing data cells and ranges, managing tables and table data, performing operations with formulas and functions, and managing charts. The course includes an overview of the MOS certification program, its costs, and all the exam objectives. Follow along with the downloadable sample files. Then take the full-length practice test at the end of the course to test your skills and speed.
[Read more…]

Packt – VBA Intermediate Training

Leave a Comment

Packt – VBA Intermediate Training-JGTiSO
English | Size: 1.08 GB
Category: Tutorial


Learn
How to write and implement Excel events, to modify how Excel reacts to different user actions.
Discover how to modify a variety of standard behaviors, such as double-clicking, opening files and saving files through VBA.
Learn how to design and implement specialized classes of objects.
Discover how to customize the right-click menu within cell ranges.
Learn external libraries, and how you can extend VBA’s capabilities beyond standard Excel options.
Learn about where VBA falls within the Excel file structure, and how different Excel file types use VBA differently.
How to modify the Excel user interface, including the “Ribbon” and context menus to interact with your VBA code
Learn custom classes, including introducing you to blank custom classes, and how to use user form classes. [Read more…]

Packt – Essential VBA Training for Excel

Leave a Comment

Packt – Essential VBA Training for Excel-JGTiSO
English | Size: 739.74 MB
Category: Tutorial


Learn
General syntax rules, what keywords are, and how to add comments.
What variables are, and how they relate to functions versus methods and subroutines.
How to specify different variables, including arrays, and how to manage them in code.
How to use intellitext with variables, particularly those that are defined constants.
What functions are, how they are used, and how to stage a scenario to complete.
How functions return values.
How to define inputs for functions.
How to use input boxes and message boxes to interact with the user.
The intricacies surrounding creating an array formula.
How to use the application object to control the user experience.
How to use errors to improve your code.
How to use the name and names object to manage named ranges.
General information about the PivotTable object and basic approaches to utilizing it. [Read more…]