↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • Learn Computer Skills
    • Basic Computer Skills
    • Common Tasks
    • Intermediate Computer Skills
  • Website Building
    • Web Building Lessons
    • Using WordPress
  • Business Tutorials
    • Management
    • Career Tutor
  • FaQ
1 2 >>

Monthly Archives: January 2016

Post navigation

← Previous Post

Advanced Spreadsheets – Filter and Sort Data

The Place For Free Online Training Courses

Filter, sort data in a pivot table/data pilot. Filtering data means applying some conditions to the data so that only those data fields get displayed which satisfy these conditions. To filter data in a pivot table, simply right-click anywhere on … Take lesson

Advanced Spreadsheets – Using Pivot Tables

The Place For Free Online Training Courses

Create and modify a pivot table/data pilot. A pivot table is a very effective and efficient tool for comparing, combining, and analyzing large amounts of data in a simple manner. To use pivot table, the first thing which is required … Take lesson

Advanced Spreadsheets – Format chart to display an image

The Place For Free Online Training Courses

Format columns, bars, plot area, chart area to display an image. In Calc charts, we cannot use custom images by importing them into the charts from our local machine. Though Calc does provide the option for using the different types … Take lesson

Advanced Spreadsheets – Change scale of chart value

The Place For Free Online Training Courses

Change scale of value axis: minimum, maximum number to display, major interval. In Calc, the values displayed with the axes of a chart are normally the default ones which are selected by the system as per the data being used. … Take lesson

Advanced Spreadsheets – Re-position chart title, legend, data labels

The Place For Free Online Training Courses

To re-position the chart title or legends in a Calc chart, first of all select the chart. After this, click once on the chart title or the legends box, the chart title or the legend box will get selected. Now … Take lesson

Advanced Spreadsheets – Add and delete a data series in a chart

The Place For Free Online Training Courses

In the same way as we can change the chart type for a chart, in case some new data field is added for a chart, we can simply update this in the already existing chart and we do not need … Take lesson

Advanced Spreadsheets – Change the chart type for a defined data series

The Place For Free Online Training Courses

Changing the chart type for any chart is helpful when we want to showcase our data in a different format. Sometimes, we might create a particular chart for a set of data but then later figure out that some other … Take lesson

Advanced Spreadsheets – Add a secondary axis to a chart.

The Place For Free Online Training Courses

To add a secondary axis to a chart, first of all select the chart. After this, right-click anywhere on the chart area, and from the resulting menu click on ‘Insert/Delete Axes’. This will open the ‘Axes’ dialog box. In this … Take lesson

Advanced Spreadsheets – Creating Charts

The Place For Free Online Training Courses

Create a combined column and line chart. A combined column and line chart is a combination of two chart types. It is useful for combining two distinct but related data series. To create a combined column and line chart in … Take lesson

Advanced Spreadsheets – 3-D and Mixed Reference

The Place For Free Online Training Courses

Use a 3-D reference within a sum function. Till now we have seen how to use the cell ranges from the same sheet as the arguments for the functions. But we can also use cell ranges from other sheets as … Take lesson

Post navigation

← Previous Post

Latest Lessons

  • Advanced Database Quiz
  • Advanced Database – Assign/attach a macro to a control
  • Advanced Database – Assign/attach a macro to a command button
  • Advanced Database – Create a simple macro
  • Advanced Database – Import from existing database into a database.

Available Courses

  • Customising Your PC (5)
  • IT Training (12)
  • Learn Computer Skills (25)
    • Basic Computer Skills (12)
    • Common Tasks (8)
    • Intermediate Computer Skills (5)
  • Microsoft Certified Professional (79)
    • Disaster Recovery (5)
    • Hardware (5)
    • Installations (1)
    • Interoperability (3)
    • Introduction To Networking (25)
      • Managing Disks (9)
      • Windows Quickstart (8)
      • Windows XP Server 2003 (8)
    • Local Security (6)
    • Local Users and Groups (4)
    • Monitoring and Optimisation (5)
    • NTFS (4)
    • Printing (3)
    • Remote Desktop and Terminal Services (6)
    • Shared Folders (5)
    • TCP/IP (7)
  • Microsoft Certified Systems Engineer (86)
    • Active Directory Overview (8)
    • Active Directory Sites And Replication (5)
    • Active Directory Trusts (2)
    • Active Directory Users and Groups (4)
    • Certificate Services (6)
    • Deploying Applications (3)
    • DFS (5)
    • DHCP (5)
    • DNS (8)
    • Group Policy (5)
    • IIS (5)
    • IPsec (3)
    • Remote Access (6)
    • RIS (7)
    • Routing (6)
    • SUS (3)
    • WINS (6)
  • Microsoft Certified Technology Specialist (129)
    • Windows Server 2008 Active Directory, Configuring (78)
      • Active Directory Federation Services (3)
      • Active Directory Rights Management (3)
      • Active Directory Sites And Replication (3)
      • Active Directory Trusts (2)
      • Administration (5)
      • Authentication (5)
      • Certificate Services (9)
      • Computers (4)
      • Directory Business Continuity (5)
      • Domain Controllers (4)
      • Group Policy (4)
      • Groups (6)
      • Installation (5)
      • Integrating Domain Name System (6)
      • Lightweight Directory Services (2)
      • Users (9)
    • Windows Server 2008 Network Infrastructure, Configuring (59)
      • Configuring IP Routing (4)
      • Configuring Name Resolution (8)
      • Configuring Windows Firewall and Network Access Protection (4)
      • Connect To A Network (6)
      • Creating a DHCP Infrastructure (5)
      • Managing Files (11)
      • Managing Printers (3)
      • Managing Software Updates (4)
      • Monitoring Computers (4)
      • Protecting Network traffic with IPSec (3)
      • TCP/IP (7)
  • Office Software (287)
    • LibreOffice (285)
      • Advanced Database (54)
      • Advanced Presentations (25)
      • Advanced Spreadsheets (47)
      • Advanced Word Processing (38)
      • Base (29)
      • Calc (20)
      • Math (16)
      • Presentations (33)
      • Writer (22)
        • Mail Merge (3)
  • Uncategorized (1)
  • Website Design (22)
    • Creating websites with HTML (9)
    • CSS (6)
    • Extras (3)
    • What is the internet (4)
  • Windows Maintenance (9)
  • Wordpress (12)
  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2019 - The Place For Free Online Training Courses Privacy Policy
↑