Like Drupal Views but for WordPress, The Loops allows you to query the database for content and display it in a page without having to write php code.
Click on the 'Loops' link in the 'Appearance' menu, click 'Add New' to add a new loop. Use the shortcode provided or go to the widgets screen to add the loop to a sidebar.
Copy a default template file from the directory 'tl-templates' in the plugin directory to your theme directory. Then feel free to modify it to your liking!