Wyre Bash will improve Skyrim mod compatibility. It will fix load order issues, merge levelled lists and create a Bashed Patch to combine mods. Wyre Bash can also be used to install mods.
The Skyrim Creation Kit allows you to create fantastic mods to both use yourself and to share with the community. This guide is designed for beginners and gives detailed help to get you started.
Being able to fully customise your Skyrim characters appearance, class, starting attributes and skill progression will allow you to have a truly unique character and improve the games re-playability.
Skyrim armour mods allow you to improve the graphics of vanilla armour as well as adding wonderful new armour sets to your game for both NPCs and player characters.
Using body model mods such as CBBE and UNP as well as high quality texture replacers, such as Apachii hairstyles and Coverwoman you can make your Player Character look beautiful (or handsome).
Review of the very best Skyrim weapons mods available. Texture replacer mods that update the graphics as well as mods that add tonnes of beautiful new swords, bows and other weapons are introduced.
Learn how to fix Skyrim game crashes. Skyrim can crash when starting, loading an exterior cell or fast travelling. You will learn how to use BOSS, Windows Grep and Papyrus logs to fix Skyrim crashes.
The look of clothing worn by NPC and Player characters in Skyrim can be greatly improved by installing mods. This article introduces the best available. Stunning cloaks, beautiful mage robes and more.
Guide to Nexus Mods, which is the best website available for Skyrim mods. There are also many mods hosted for Fallout 3, Fallout New Vegas, Dragon Age, Dark Souls, Morrowind and Oblivion.
An optimised Skyrim mod load order will improve performance and reduce crashes. BOSS will sort your load order, check for conflicts, warnings, patches and errors. TES5Edit will clean any "dirty" mods.
Guide to installing Skyrim mods manually which is more accurate that using a Mod Manager. You can also partially install mods. BOSS is used to set load order and check for mod issues or conflicts .
Best Immersion Skyrim mods are examined including Wet and Cold, Frostfall, Open Cities, Realistic Needs and Diseases and Hunterborn. All of these mods will greatly enhance your Skyrim experience.
Scratch is a free programming language created by MIT. It can be used to create games, art, animations and stories and is used in Code Clubs in the UK to teach children how to programme.
Mod Organizer is an advanced mod manager for "Skyrim," "Fallout 3," "Fallout New Vegas," and "Oblivion." It installs mods separately to keep your game folder clean and allow for easy mod removal. It detects conflicts, checks load order, and much more.
Outlook templates are a great time-saving tool. Any email you send regularly can be stored either in Outlook or on your computer as a template and re-used as often as you like to save you time.
Excel 2007 has lots of built in templates as well as hundreds online. They allow you to save time and effort by saving formatting and data into a template which is then available for new spreadsheets.
A Speedometer, Dial or Gauge chart in your Excel 2007 / 2010 spreadsheet will look impressive, especially in a dashboard. It uses a Doughnut chart and Visual Basic code to create a moving needle.
Introducing four essential mods for the Elderscrolls V Skyrim. Skyrim Unbound, Unofficial Skyrim Patch and Sky UI allow you to vary new games, improve the user interface and squash 100s of game bugs.
MP3Tag allows you to make rules to rename the tags or metadata in your music tracks quickly and easily to update song titles, artist and album names. You can even replace words or specific characters.
Nexus Mod Manager allows you to easily download, cleanly install, update and remove mods for many popular PC games including Skyrim, Fallout New Vegas, Fallout 3, Dragon Age and Mount and Blade.
Dynamic charts in Excel change automatically if data it is added or removed saving you time and effort. They use a formula with the OFFSET and COUNTA functions and named ranges using Defined Names.
In Excel 2010, Conditional Formatting Icon Sets and Data Bars have been greatly improved. Icons Sets can now be mixed and matched and Data Bars show negative values on an axis in a different colour.
Sparklines are a new chart in Excel 2010 and can be simply and quickly placed in just one cell. They can be placed directly next to the data to add context to that data and show trends and variations.
Learn how to use the maths operators + - * / % ( ) and SUM, COUNT and AVERAGE in formulas in Excel 2007 and Excel 2010. Also how to use & to join cells and $ to make a cell an absolute reference.
Bubble charts created in Excel 2007 or Excel 2010 allow you to show data in three dimensions in a visually stunning chart. This can then be saved as a template to be used to create additional charts.
SUMPRODUCT in Excel 2007 and Excel 2010 allows you to multiply data from multiple data ranges and then sum the result. It can be used, for example, to calculate stock levels or sales commissions.
Shapes in Excel 2007 and Excel 2010 can be renamed and reordered using the Selection Pane. To save time, shapes can also be grouped so that they can be formatted, manipulated or moved together.
Guide to Visual Basic or Visual Basic for Applications (VB or VBA) code in Excel 2007 and 2010, learning the basic commands, how to work with errors and how to run the code that you have written.
Visual Basic loops can use IF, ELSE and ELSEIF or FOR NEXT statements to allow you to perform the same task on a large number of cells easily and quickly. You can easily group cells using cell ranges
Visual Basic code allows you to configure a User Interface using a UserForm in Excel 2007 or Excel 2010. Scripts initialise the User Interface, configure the buttons and add data into the worksheet.
Thematic maps show themes or variations across geographical regions. Data is linked to the chart in Excel 2007 or Excel 2010 using Visual Basic code which updates each part of the map automatically.
UserForms in Excel 2007 and Excel 2010 allow you to add fully configurable dialogue boxes or User Interfaces to your spreadsheets. They are easy to use, reduce typing errors, save time and look great.
Data validation in Excel allows you to control both the type of data or values that are entered. Input messages and errors are fully customisable. Formulas can also be used for validation criteria.
How to share documents & use track changes to highlight changes in a document. Use Document Inspector to find hidden & personal data, Compatibility checker shows issues older Excel versions may have.
The Insert Function allows you to search for a function and easily create formulas. The Function Library groups all Excel 2007 and Excel 2010's functions in logical groups to make them easy to find.
If your data range contains many blank cells, it can be hard to correctly create a chart. Use the IF function to convert blank cells to #N/A which Excel ignores or change how Excel deals with blanks.
Conditional formatting in Excel 2007 and Excel 2010 allows you to add visual impact to your spreadsheets. Use icon sets and cell formatting to add colour to highlight data or illustrate trends.
Ubersuggest, the Google AdWords Keyword Tool & Google Search can assist you in writing new content for websites, blogs and HubPages. Use the Keyword tool for SEO keyword research to increase traffic.
A Gantt chart in Excel 2007 or Excel 2010 is a Project Management tool that shows the progress of tasks over time. This hub shows how to create a 3D Gantt chart template from a stacked bar chart.
The Sampling Tool from the Analysis Toolpak in Excel 2007 and Excel 2010 allows you to create random samples or smaller samples from larger data sources as well as analysing your data for variations.
The Analysis ToolPak allows you to perform complex statistical analysis on your data including: correlation, regression, random sampling, moving averages, creating rank and percentiles and histograms.
Regression allows you to examine the relationship between a number of variables. The results can then be displayed in a Scatter chart which includes a regression line to illustrate the relationship.
Correlation is a relationship between two variables. Using the Correlation Tool in the Analysis ToolPak in Excel 2007 / Excel 2010 we can statistically test for a positive, negative or no correlation.
The Excel 2007 / 2010 Rank and Percentile tool allows you to create ranking tables. In this hub we use Rank and Percentile with MATCH, INDEX and IF functions to create a fully automated ranking table.
The Moving Average Tool from Excel 2007 and Excel 2010's Analysis ToolPak allows you to calculate a trend in data using a moving average which is defined by an interval (or number of values averaged).
The Histogram Tool in the Analysis ToolPak in Excel 2007 / Excel 2010, allows you to create histograms with defined boundaries quickly and easily. Cumulative and ranked histograms are also possible.
The OFFSET and COUNTA functions allow you to create dynamic ranges of data. Formulas created to SUM this data (for example) will automatically update if data is added or removed from within the range.
The CHOOSE function allows you to ask Excel to select an item from a list, add up or average a range of numbers by using CHOOSE with SUM or AVERAGE or to replace multiple nested IF statements.
The REPLACE and REPLACEB functions allow you to precisely replace part of a cell's contents and can be combined with functions such as IF. Find and Replace is best used for replacing entire cells.
The Excel CONVERT function allows you to convert numbers between a variety of measurements including weight and mass (grams, pounds and ounces), distance (meters and miles) and time among many others.
Learning how to read music is an essential first step when learning a musical instrument. This guide covers the basics including note names, note durations, bars (measures), clefs and time signatures.
In Part 2 of this guide on how to learn to read music, we will examine key signatures, rests (silences in music), musical notation that tell you how to play the music (loudly, softly etc) and repeats
SUMIF sums or adds data based on a single criteria (e.g. add up all CD sales). SUMIFS adds up data based on up to 127 criteria (e.g. add up all sales of a specific album on CD sold on Wednesday).
An Outlook To Do list allows you to organise all your work and personal tasks into one list. You can then create categories, reminders and follow up flags for tasks in Outlook 2007 and Outlook 2010.
The VLOOKUP function finds a value within a range of cells and returns information about that value. The TRUE / FALSE values allow you to choose whether Excel looks for an exact or approximate match.
Use the MATCH function in Excel 2007 and Excel 2010 to compare lists or look for an item in lists to find its relative position which can then be compared to see if the item has moved up or down.
A header or footer in Word allows you to add text or graphics to the top or bottom of your document. They allow you to add chapter or section headings as well as page numbers to your document.
Using PMT, PPMT, IPMT, IF and IFERROR functions in Excel, we create an amortization schedule to calculate repayments / over payments as well as the amount of interest and principal paid on a mortgage.
Using PMT, PPMT, IPMT and ABS functions we create a simple mortgage calculator using Excel 2007 and Excel 2010. The calculator works with repayment / interest only and monthly / quarterly mortgages.
The IF function returns one value if a condition is true and another if false. The AND, OR, and NOT functions allow for comparisons against multiple conditions. Use IFERROR to suppress known errors.
Forms created in Excel 2007 and Excel 2010 using ActiveX List Boxes allow you to enter data into Excel quickly, easily and with a minimum of errors. A Command Button is also used to complete the form.
Using List Boxes in Excel 2007 and Excel 2010 you can create visually appealing and very easy to use boxes containing lists of items from which users can select one or multiple items.
Use Form and ActiveX Controls List Boxes to create lists from which users can select either one or multliple items. List Boxes are visually attractive, familiar to users and easy to use and configure.
Using Scroll Bars in Excel 2007 and Excel 2010 allows you to add visually appealing,easy to use and intuitive controls to your spreadsheets; users can then quickly and easily select a value using it.
Spin buttons created within a panel in Excel 2007 and Excel 2010 allow users to quickly and easily select a number from a range using arrows. Spin buttons are familiar to users and are easy to use.
Option or Radio buttons in Excel 2007 / Excel 2010 allow you to create visually appealing and user friendly panels with selectable items in a list. Users can then select a single item from each panel.
Toggle Buttons in Excel 2007 and Excel 2010 using Visual Basic code allow you to toggle or switch between two states; e.g. turning grid lines on and off, hiding or showing rows by clicking a button.
Step by step guide to creating an Index in Word 2007. Creating, modifying the style of and deleting an Index are covered in detail as well as adding and deleting individual words and phrases to the Index. The difference between a Table of Contents and an Index are also discussed.
The Solver tool in Excel 2007 and Excel 2010 allows you to solve problems, perform what-if analysis and optimization through the use of optimization models to forecast or achieve different goals.
Detailed guide on creating league tables and top 10 lists using the MIN, MAX, SMALL, LARGE, INDEX and MATCH functions in Excel 2007.
Detailed step by step guide to creating a beautiful thermometer chart using Excel 2007. Starting with a 2D stacked column chart, each step is detailed throughout. Included are tips to remove the zero on the vertical axis and tips on creating the various shapes needed.
How to guide on housekeeping your mailbox in Outlook 2007. The tutorial includes determining the mailbox size and identifying firstly the biggest folders and secondly the biggest emails which should be the focus of attention to reduce overall mailbox size. Working with the deleted items folder as...
Step by step guide on creating rules in Outlook 2007. Examples used were creating rules to move emails from specific people to a folder as well as deleting emails containing particular words from certain people. Best practice for using rules in Outlook 2007 is also discussed in depth.
How to guide on using the LEFT, RIGHT and MID functions to extract text from cells in Excel 2007. Examples of extracting first names, surnames and middle initials were provided. Use of the CONCATENATE function to join cells or text was also illustrated.
Step by step guide to importing data into Excel 2007 from text files such as *.csv and *.txt files. The correct use of delimiters such as commas when importing data is also covered. Using the TRIM, CODE, SUBSTITUTE and CLEAN functions to remove unwanted or non-printable characters including spaces...
How to guide or tutorial on using date functions in formulas in Excel 2007. The tutorial covers the DATEDIF, TODAY(), NETWORKDAYS, MONTH and YEAR functions using a real life example.
How to guide or tutorial on how to add trend lines to graphs or charts in Excel 2007. Choosing the correct type of trend line is covered as well as how to ensure that the data is accurate to allow accurate forecasting of data to occur. Configuring a trend line to show forecasting is also covered.
How-to guide on using shapes in Excel 2007. I illustrate how to create a button in Excel 2007 using a rounded rectangle and a hyperlink.
VLOOKUP is a very powerful function in Excel 2007 and Excel 2010 that when used in formulas looks for a value within a table of data and returns some specific information related to that value.
Step by step guide or tutorial to filtering and grouping data in Excel 2007. Also covered are configuring filtering, using numerical filters as well as text filters. Configuring grouping as well as ungrouping data is also covered.
Guide for creating to do lists in Excel 2007 / Excel 2010 using Check boxes and Combo boxes. Use Conditional Formatting using formulas and cell values with icon sets to add visual impact to your list.
This is a step by step guide on creating and configuring command buttons in Excel 2007. This includes configuring and adding VB script to your button to enable it to perform functions when pressed, in this case resetting combo boxes in Excel 2007.
Guide to creating and configuring combo boxes in Excel 2007. This step by step guide covers how to create and configure combo boxes both individually and in greater numbers easily and quickly.
Guide to using the Subtotal button in Excel 2007 and Excel 2010 which allows you to add subtotals, grand totals, group and summarise your data into a table even when you have enormous amounts of data.
How to use the COUNTIF and COUNTIFS functions in Excel 2007 and Excel 2010 to count text in a cell range. Remove Duplicates allows you to create lists of unique items from a larger data source.
Check boxes can be used to create visually striking but easy to use lists including To Do lists in Excel 2007 / Excel 2010. This hub covers how to create, configure, edit, copy and align a check box.
Step by step guide to password protecting and encrypting spreadsheets, worksheets and cell ranges as well as preventing the deletion, moving and copying of worksheets in Excel 2007 and Excel 2010.
Here is my tourist guide to the Tian Tan Buddha (also known as the Big Buddha) at Ngong Ping, near Tung Chung on Lantau Island, Hong Kong. This is a must see attraction if you are visiting Hong Kong.
Tung Chung offers Outlets Shopping with designer labels at permanent discounts. It also offers top class sightseeing attractions including the Tian Tan or Big Buddha and the Ngong Ping 360 cable car.
Guide to installing and configuring the shadow copy client on Windows 7, Windows Vista, Windows 2000 and Windows 98. Detailed Instructions for the configuration of Shadow Copy on a server running Server 2003. Demonstration of how to use Previous Versions to restore a deleted file or a deleted...
Guide to learning and remembering important Chinese characters a visitor to China should learn to make a trip to China safer and more enjoyable. Includes warning characters,days/months/year and sizes.
Welcome to my guide to learning traditional chinese characters using memory hooks. In part one we cover the numbers one to ten, points of the compass and left and right. I also discuss the methods and tools I use to help me memorise traditional chinese characters
Tung Chung, on Lantau Island, Hong Kong boasts excellent amenities and a wide range of flats with sea views that are relatively cheap. Shopping is excellent and there is a wide variety of things to do.
Tourist guide for the Monastery of the 10,000 Buddha's in Sha Tin, Hong Kong which is one of Hong Kong's best (and relatively unknown) attractions. Advises how best to get there and what to see.