Below you will find useful informational articles , including tips and tricks, how-to articles etc. Content is updated on a weekly basis.
Microsoft Office Learning Resources:
Working with Gantt Charts
The Gantt Chart is a horizontal bar chart that represents each task in the time scale of the project. Each task entered in the project will be shown and by default the name of the resource allocated to the task appear next to the bar. Read more.
Hiding and Unhiding Data
When you develop workbooks for others to use, it may be wise to restrict the access they have to certain cells, worksheets, or even the entire workbook. Some cells may contain formulas that you do not want changed, and certain workbooks may be confidential. You can hide columns and rows within a worksheet, as well as hide worksheets within a workbook. Read more.
Modifying Page Breaks
Word automatically determines where each page of a document should begin and end by inserting automatic page breaks. As you create and edit multipage documents, you might find that you need to manipulate the automatic page breaks. You can quickly create a manual (forced) page break by clicking the Page Break button in the Pages group on the Insert tab. Read more.
Running a Macro in Excel
If you perform certain opertations over and over in Excel, you can record a macro which stores all the steps, and when you run the macro it will automatically perform each step automatically save you a lot of manual repetitive work. Read more.
More Microsoft Office Learning Resources
Adobe Learning Resources:
Creating a Spot Color effect in Premiere Pro
The spot color effect is when everything on the screen is in black and white except for a certain color.
This effect can be done with both stills and video. Read more.
Using Conditional Text with Images in InDesign
Conditional Text in InDesign is similar to Layer Comps in Photoshop. But in InDesign it is limited to text only. You can use conditional text with images by changing them to Inline Graphics. Read more.
Getting to know the Photoshop Interface
In this article, you will familiarize yourself with the Adobe Photoshop interface. Also covered are Preferences, Shortcuts, Workspaces and Menu Customization. Read more.
More Adobe Learning Resources
Business and Softskill Resources:
Work Life Balance
Work- life balance is essential to combat stress, ensuring both individual and company success. The stress associated with unbalanced lifestyles is costly; it damages productivity and increases individual health risks. Employees who have the tools to balance their professional and personal lives are happier, healthier, and more productive. Read more.
Great Customer Service over the Phone
When you are talking to someone in person, body language makes up a large part (some would say more than half) of your message. But as soon as you pick up the phone, body language becomes irrelevant. The success of your interactions depends almost entirely on your tone of voice and your choice of words. Read more.
Time management is about more than just managing our time; it is about managing ourselves, in relation to time. It is about setting priorities and taking charge. It means changing habits or activities that cause us to waste time. It means being willing to experiment with different methods and ideas to enable you to find the best way to make maximum use of time. Read more.
Business Dining Rules
Conducting business over meals is a great way to build business relationships. Meals make for a more casual atmosphere compared to offices, and are therefore more conducive for a relaxed discussion. In this module, we would discuss some of the etiquette rules when dining with business associates such as understanding place setting, etiquette rules while eating, and ways to avoid sticky situations. Read more.
Web Development Learning Resources:
Applying CSS Tags to HTML
In my HTML/CSS class at Training Connection we learn different ways of adding CSS styles to our HTML documents. There are benefits and drawbacks of each method available but first let's make sure we understand what a CSS Style is and why we use them. Read more.
You know what a function is and you know how to create variables. But, did you know that a variable behaves differently when it is used inside a function? Specifically, we are talking about variable scope. No, not the mouthwash for variables, although sometimes I feel like my variables could use a good cleaning. We are talking about the scope, as in the range of the effect of a variable. Read more.
CSS Specificity Explained
What is CSS Specificity? Specificity in CSS is the way a browser will determine which declarations are applied to HTML elements when there is a conflict from multiple rules. Ok, so what does that mean exactly? Read more.
More Web Development Learning Resources