In this advanced training course for Microsoft Excel 2013, expert author Guy Vaccaro takes you beyond the basics of Excel, and teaches you how to use the advanced features and functions in this spreadsheet program from Microsoft.
You will start with basic operations such as SUM, MIN, and MAX, as well as conditional mathematical functions. Guy proceeds to instruct you on using IF statements to control conditions. You will learn how to perform data lookups using VLOOKUP and HLOOKUP, and how to create Sparklines. Other features that are covered in this advanced Excel tutorial are; working with time, outlining, custom views, text manipulation, error checking, pivot tables and pivot charts. Guy also covers some basic Macro operations within Excel for optimizing your workflow.

In this WordPress Mobile Development training course from Geoff Blake, you will learn how to create websites using WordPress that look great no matter what device or screen size you are viewing them with. Responsive web design allows you to build and maintain one website, but have it respond according to the device that it is being viewed on. This tutorial will show you how to create a responsive website by way of customizing a WordPress template. Some experience and familiarity with WordPress and CSS is suggested in order for you to get the most out of this training.

During this tutorial, we will build a game-res mesh from a high-res sculpt. We will then transfer the high-res detail so our game model looks as close as possible to our high-res character. We will start by retopologizing our character in 3D-Coat, then we will create UVs in 3D-Coat. Next, we will transfer all of the maps using TopoGun. Finally, we will view our final result in Marmoset Toolbag.

In this ZBrush tutorial we will learn how to create a scary creature with ZBrush - starting from the basic blocked-in meshes and finishing with high-res details and textures.
Throughout these lessons we will learn the key features to design a memorable and terrifying female monster within ZBrush. We'll start by using a concept painting that we'll use as source of inspiration and then move to ZBrush. In ZBrush we'll block out a basic mesh using the DynaMesh feature.

No time to exercise? No problem! Alycea Ungaro's 15-Minute Everyday Pilates series gives you all the tools you need to squeeze regular exercise into your life. In the Everyday Pilates: From The Bottom Up Vook, Ungaro shows you how to get a toned, strong body, and graceful posture in just 15-minutes a day. This fantastic new format offers easy, step-by-step instruction, full color images and 11 videos to take you through the full Bottom Up routine, which focuses on precision, activating your stance and learning the sidekick series. Strengthen, stretch, and build your way to a more toned, more healthy you.

In this 2:40 HR very advanced Photoshop tutorial we cover every detail in creating a realistic composite from advanced selections, exposure and color blending to stylization and creating custom brushes.

This is a set of videos that focus on car Sales training but they are excellent sales tactics for ANYTHING you want to sell, yourself, cars, real estate, pocket watches, etc. These videos are a bit dated but the information is still good and very valid. These videos are currently one of the standard required training tools of many of the most successful car dealerships. Learn to sell and what to see from other when they are trying to sell you as well.

Stephen Wells covers his process of sculpting, poly painting, and baking normal maps step-by-step for this Next-Gen Orc Head model. You will learn about various tools and workflow aspects of ZBrush and work your way through the sculpting process and become more familiar with the ZBrush interface and the use of its more powerful features

Description: A universal software system of finite-element method (FEM) analysis, the existing and evolving over the past 30 years, is quite popular among professionals in the field of automatic engineering design (CAE, Computer-Aided Engineering) and CE solutions of linear and nonlinear, stationary and non-stationary spatial problems of solid mechanics and mechanics of structures (including non-stationary geometrically and physically nonlinear problems of contact interaction of structural elements), problems of gas and fluid mechanics, heat transfer and heat transfer, electrodynamics, acoustics, and mechanics-related fields.