76- 0
How to Use Wyre Bash for "Skyrim" Mods to Create a Bashed Patch
Wyre Bash will improve "Skyrim" mod compatibility. It will fix load order issues, merge levelled lists, create a Bashed Patch to combine mods and more.
- 10
Skyrim Creation Kit Beginner's Guide
The Skyrim Creation Kit allows you to create fantastic mods to both use yourself and share with the community. This guide is designed for beginners and includes detailed instructions to get you started.
- 1
Mods to Improve Appearance of and Customise Your Skyrim Player Character
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.
- 0
The Best "The Elder Scrolls: Skyrim" Armour Mods
"The Elder Scrolls: Skyrim" armour mods improve the graphics of vanilla armour and adds wonderful new armour sets to your game for both NPCs and player characters.
- 1
"The Elder Scrolls V: Skyrim": Create Player Characters With CBBE or UNP
Using body model mods such as "CBBE'' and "UNP", as well as high-quality texture replacers, you can make your Player Character look beautiful (or handsome).
- 0
The best Skyrim weapon mods available to both improve the graphics of weapons and to add new weapon sets
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.
- 33
How to Diagnose and Resolve a "Skyrim" Crash
"Skyrim" can crash on start-up, when loading an exterior cell, or during fast travel. Here's how to diagnose and resolve crashes using BOSS, Windows Grep, and Papyrus logs.
- 1
Guide To The Best Skyrim Clothing Mods
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.
- 0
How to Best Use the Nexus Mods Website for Skyrim Mods as Well as Fallout 3, Fallout New Vegas, Dragon Age and Oblivion
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.
- 4
How to Use BOSS and TES5Edit to Optimise Your "Skyrim" Mods
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.
- 0
How to Manually Install and Use "The Elder Scrolls V: Skyrim" Mods
This guide will help you install "Skyrim" mods manually—a method that is more accurate than using a Mod Manager. You can also partially install mods. BOSS is used to set load order and check for mod issues or conflicts.
- 0
The top Elderscrolls V Skyrim Immersion mods available Wet and Cold, Frostfall and Realistic Needs and Diseases
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.
- 0
How to use Scratch to create games, art and to teach children to code
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.
- 2
How to Install and Configure Mod Organizer for "Skyrim," "Fallout 3," "Fallout New Vegas," and "Oblivion"
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.
- 1
Creating and Using Templates in Outlook 2007 and Outlook 2010 to Save Time
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.
- 0
Using Templates in Excel 2007 as a model to save you work and time formatting your spreadsheets and adding common data
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.
- 4
Creating a Speedometer, Dial or Gauge chart in Excel 2007 and Excel 2010
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.
- 1
Using "Skyrim" Mods SKSE, Sky UI With MCM, and Skyrim Unbound
This article introduces four essential mods for the "Elderscrolls V Skyrim." Skyrim Unbound, Unofficial Skyrim Patch, SKSE, and Sky UI allow you to vary new games, improve the user interface, and squash hundreds of game bugs.
- 2
How to use MP3Tag rules to edit your music files metadata tags to tidy up your iTunes or music library
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.
- 14
How to Use Nexus Mod Manager to Download, Install, Remove, and Manage Mods
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."
- 3
Creating Dynamic Charts Using the OFFSET Function and Named Ranges in Excel 2007 and 2010
Dynamic charts in Excel change automatically if data 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.
- 0
Guide to the Improvements to Conditional Formatting Icon Sets and Data Bars in Excel 2010
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.
- 3
How to create and use Sparklines in Excel 2010 to summarise and add context to your data and to also show trends
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.
- 2
Beginners Guide to Excel Formulas and Mathematical Operators Using Excel 2007 and 2010
Learn how to use the maths operators + - * / % ( ) and SUM, COUNT and AVERAGE in formulas in Excel 2007 and 2010. I'll cover how to use and join cells and $ to make a cell an absolute reference.
- 2
How to create and configure a bubble chart template in Excel 2007 and Excel 2010
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.
- 3
Renaming, Reordering, and Grouping Shapes in Excel 2007 and 2010
Shapes in Excel 2007 and Excel 2010 can be renamed and reordered using the Selection Pane. In order to save time, shapes can also be grouped so that they can be formatted, manipulated, or moved at the same time.
- 1
Visual Basic Loops, IF, ELSE and ELSEIF statements and creating ranges in Visual Basic 6 for Excel 2007 and Excel 2010
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
- 2
How to write Visual Basic code to configure a User Interface created using a UserForm in Excel 2007 and Excel 2010
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.
- 4
How to create a thematic or Choropleth map in Excel 2007 and Excel 2010
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.
- 6
User Interface design using a UserForm in Excel 2007 and Excel 2010
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.
- 2
How to Create a Formula in Excel With the Function Library in Excel 2007 or 2010
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.
- 12
How to Get Excel 2007 and 2010 to Ignore Empty Cells in a Chart or Graph
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.
- 3
Conditional Formatting in Excel 2007 and 2010 Spreadsheets Using Formulas and Icon Sets
Conditional formatting in Excel 2007 and 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.
- 6
How to Create a Gantt Chart Template Using Excel 2007 or Excel 2010
A Gantt chart in Excel 2007 or Excel 2010 is a Project Management tool that shows the progress of tasks over time. This article shows how to create a 3D Gantt chart template from a stacked bar chart.
- 0
Use the Sampling Tool in the Excel 2007 and 2010 Analysis ToolPak for Sampling and Analysing Periodic Variations
The Sampling Tool from the Analysis Toolpak in Excel 2007 and 2010 allows you to create random samples or smaller samples from larger data sources as well as analysing your data for variations.
- 1
Using the Analysis ToolPak in Excel 2007 and Excel 2010
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.
- 0
Using the Correlation Tool from the Excel 2007 and Excel 2010 Analysis ToolPak
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.
- 0
Use the Rank and Percentile Tool From the Analysis ToolPak in Excel 2007 and 2010 to Create Ranking Tables
The Excel 2007/2010 Rank and Percentile tool allows you to create ranking tables. In this article, we use Rank and Percentile with MATCH, INDEX and IF functions to create a fully automated ranking table.
- 0
Using the Moving Average Tool from the Excel 2007 and Excel 2010 Analysis ToolPak
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).
- 3
Use OFFSET and COUNTA to create dynamic ranges with automatically updating formulas in Excel 2007 and Excel 2010
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.
- 2
How to Use CHOOSE to Sum or Average Cell Ranges and Replace Nested IF Statements in Excel 2007 and Excel 2010
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.
- 3
Using the REPLACE and REPLACEB Functions in Formulas and the Find and Replace Tool in Excel 2007 and 2010
The REPLACE and REPLACEB functions allow you to precisely replace part of a cell's contents. It can be combined with functions such as IF. Find and Replace is best used for replacing entire cells.
- 0
Using the CONVERT Function in Formulas in Excel 2007 and 2010
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.
- 5
Beginners guide on how to read music with examples, Part One
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.
- 1
Beginners guide on how to read music with examples, Part Two
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
- 4
How to use the SUMIF and SUMIFS functions in formulas in Excel 2007 and Excel 2010 with examples
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).
- 2
How to use tasks to create an Outlook To Do List using Outlook 2007 or Outlook 2010
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.
- 7
How to Use VLOOKUP and the TRUE and FALSE Value Correctly in Excel 2007 and 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.
- 0
How to Use the MATCH Function to Compare Lists in Excel 2007 and 2010
Use the MATCH function in Excel 2007 and 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.
- 0
How to Create and Use a Header or Footer in Word 2007 and Word 2010
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.
- 0
Creating an Amortization loan or mortgage schedule using Excel 2007 and Excel 2010
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.
- 0
Using the PMT, PPMT, IPMT and ABS functions to create a Mortgage Calculator in Excel 2007 and Excel 2010
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.
- 1
Using the IF and IFERROR Functions in Excel 2007 and 2010
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.
- 0
Configuring and Using Forms created using ActiveX List Boxes and a Command Button in Excel 2007 and Excel 2010
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.
- 6
How to use, create and configure ActiveX Controls List Boxes in Excel 2007 and Excel 2010
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.
- 1
How to Create, Configure and Use Form Controls and ActiveX Controls Scroll Bars in Excel 2007 and Excel 2010
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.
- 0
How to create, configure and use Form Controls and ActiveX Controls Spin Buttons in Excel 2007 and Excel 2010
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.
- 2
How to use, create and configure Form Controls / ActiveX Controls Option / Radio Buttons in Excel 2007 / Excel 2010
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.
- 1
How to Create ActiveX Controls Toggle Buttons in Excel 2007 and 2010
Toggle buttons in Excel 2007 and Excel 2010 using Visual Basic code allow you to toggle or switch between two states—like turning grid lines on and off or hiding/showing rows—by clicking a button.
- 0
How to use the Excel 2007 and Excel 2010 Solver Tool in a spreadsheet for solving problems and optimization
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.
- 2
Creating Top 10 Lists and League Tables in Excel 2007
Here is a detailed guide on creating league tables and top 10 lists using the MIN, MAX, SMALL, LARGE, INDEX, and MATCH functions in Excel 2007.
- 0
Creating a Thermometer Graph or Chart Template in Excel 2007
This article contains a 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.
- 1
Guide to housekeeping in Outlook 2007 to help reduce mailbox size
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...
- 0
Using Rules to assist with Outlook 2007 housekeeping
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.
- 0
Using the CONCATENATE, LEFT, RIGHT and MID functions in Excel 2007
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.
- 0
Importing Data Into Excel 2007 and Removing Non-Printable Characters Using the TRIM, SUBSTITUTE and CLEAN Function
This is a 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. Use the TRIM, CODE, SUBSTITUTE and CLEAN functions to remove unwanted or non-printable characters.
- 0
Using the DATEDIF, NETWORKDAYS, MONTH, YEAR and TODAY() functions in Excel 2007
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.
- 0
Adding trend lines to Excel 2007 charts
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.
- 0
Using Shapes in Excel 2007
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.
- 0
How to Use the VLOOKUP Formula in Functions in Excel 2007 and 2010
VLOOKUP is a very powerful function in Excel 2007 and 2010. When it's used in formulas, it looks for a value within a table of data and returns some specific information related to that value.
- 0
Filtering and Grouping data in Excel 2007
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.
- 1
Conditional Formatting – how to create a to do list in Excel using Excel 2007 and Excel 2010
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.
- 0
Create a Command Button in Excel 2007
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.
- 0
Configuring and Using 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.
- 0
Guide to using the Subtotal button in Excel 2007 and Excel 2010 to group and summarise data
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.
- 0
Using the COUNTIF and COUNTIFS functions and Remove Duplicates in Excel 2007 and Excel 2010
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.
- 1
How to Create, Align, and Use a Check Box for a To-Do List in Excel 2007 and 2010
Check boxes can be used to create visually striking but easy to use lists, including to-do lists in Excel 2007 and 2010. This article covers how to create, configure, edit, copy, and align a check box.
- 2
How to password protect Excel spreadsheets, worksheets or a cell range in Excel 2007 and Excel 2010
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.
- 6
Tourist Guide to the Tian Tan Buddha on Lantau Island, Hong Kong
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.
- 0
Outlets Shopping and Sightseeing at Citygate in Tung Chung on Lantau Island, 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.
- 0
Step-by-Step Guide: How to Install and Configure Shadow Copy for Windows Server 2003 and 2008
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.
- 0
Learn Chinese characters - A guide for people planning a trip to China
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.
- 0
Guide to Living in Tung Chung
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.