Access 2013 Power Tips

Access 2013 Power Tips
English | Size: 390.67 MB
Category: Video Training


Your tables are built, your relationships are defined, your queries and reports are ready to run. But is your Access database really ready for users? With these power tips, you can create a better user experience for your database and transform it into a fast, efficient, and even fun place to work. Adam Wilbert will show you how to remove typical Access interface elements (like the Welcome screen) for a better start-up experience, and borrow some tricks from web design to make your database more attractive and interactive. Plus, learn how to clean up a cluttered navigation pane, filter long lists with cascading combo boxes, and build in contextual help and keyboard shortcuts that your power users will thank you for. Adam also shows how to package the database for users who don’t have Microsoft Access installed.
[Read more…]

Word 2013: Mail Merge in Depth

Word 2013: Mail Merge in Depth
English | Size: 233.46 MB
Category: Video Training


Take advantage of Word’s Mail Merge feature to save time building customized documents. This course offers tutorials on creating personalized letters, envelopes, labels, and even email messages. Author Gini Courter shows how to connect to data sources in Access, Outlook, and Excel; create new data sources; add attachments to merged email messages; use IF…THEN…ELSE and other rules for advanced mail merges; and troubleshoot Mail Merge issues.
[Read more…]

Learn Excel Formulas & Functions + Make a Pro Excel Template

Learn Excel Formulas & Functions + Make a Pro Excel Template
English | Size: 1.23 GB
Category: CBTs

Operators and Precedence of Operators: I will start from zero and if you don’t know about the operators and precedence of operators that Excel uses in its formulas, then it will be tough for you to decode complex Excel formulas. So I have covered them in very details.
How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box.
Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. [Read more…]

ExcelVbaIsFun – Excel VBA

ExcelVbaIsFun – Excel VBA
English | Size: 1.25 GB
Category: Video Training


Auto-Hide Your Worksheet When You Click Away! Excel VBA
Capture Worksheet info To Userform and Save Back to Worksheet
Change MultiPage Tabs to Left, Right, Top or Bottom – Easy
Count and CountA in VBA Excel
CountIF Excel VBA
Custom Ranges and Getting LastRow to Work with Copy and Paste
[Read more…]

ITPro TV – Microsoft Office 365 – 70-346

ITPro TV – Microsoft Office 365 – 70-346
English | Size: 8 GB
Category: Video Training


Office 365 is a cloud based productivity suite for individuals, companies and even government agencies. It is designed to deliver software as service to any and every user regardless of location. The Office 365 solution is designed to relieve the technical challenge of software management and delivery, regardless of location from the local IT personnel. This allows the IT professional to focus in implementing, deploying and operating Office 365 services and administrating supporting technologies, like email, collaboration and storage. If you’re an IT professional who takes part in evaluating, planning, deploying, and operating the Office 365 services, including its dependencies, requirements, and supporting technologies this series will demonstrate and help you to see what is involved in setting up Office 365 for your organization. [Read more…]

ITPro TV – Word 2016 – Level 1

ITPro TV – Word 2016 – Level 1
English | Size: 3 GB
Category: Video Training


The Microsoft Word 2016 show helps a viewer to have a fundamental understanding of the Word 2016 environment and the ability to complete tasks independently. The show demonstrates the correct application of the principal features of Word 2016. Viewing all the episodes should help viewers to create and edit basic documents for a variety of purposes and situations. This should help someone who might be a student, clerical worker, IT support staff as well as someone seeking the Microsoft Office Specialist Certification. [Read more…]

ITPro TV – Excel 2016 – Level 1

ITPro TV – Excel 2016 – Level 1
English | Size: 9 GB
Category: Video Training


The Microsoft Excel 2016 episodes will give you a fundamental understanding of the Excel environment, and demonstrate the correct application of the principal features of Excel 2016. These episodes cover how to create and edit worksheets and workbooks with multiple sheets, working with cells and ranges, creating tables, applying formulas and functions, and creating charts and objects. [Read more…]