Wednesday, October 2, 2013

Interactive tutorial - Microsoft Excel basic functions SUM, AVERAGE, COUNT, MAX, MIN

Are you beginner in Microsoft Excel? Do you want to know what are top used basic functions in Excel?
In practice many people using the most used common functions such as SUM, AVERAGE, COUNT, MAX and MIN.
In this article I've prepared interactive video for beginners. It means you can click in the video to the buttons for next steps or return back. Video is available by clicking to Basic functions in Microsoft Excel.
The file for testing you can download by clicking to Basic functions in Microsoft Excel - sheet example download.

Sunday, September 8, 2013

Microsoft Excel PivotTable - easy steps how to do it


Often listening listeners to Microsoft Excel training on how they would like to know to create pivot tables. I had the impression that this is something difficult for them, but the reality is not difficult at all. In the following lines I describe as quickly and easily create pivot table in Microsoft Excel. Let's do it!

Saturday, September 7, 2013

Microsoft PowerPoint slide layout

  • Determines the visual layout of content (text, images, graphs, tables, etc.) on a slide 
  • For the first slide the PowerPoint sets slide layout titled as: Main slide 
    • Then the text and other content we insert into the center of the slide 
  • Other layouts for example: 
  • Title and content (most common) 
    • The content means: 
      • The text, table, chart, SmartArt (e.g. organizational chart), images, sounds, art or media clip (video) and so on ...

Microsoft PowerPoint Slide

  • Microsoft PowerPoint Slide – the cornerstone of each presentation
  • Each presentation includes minimally one slide 
  • Each of all slides in presentations should include title and content itself 
  • Prepared slides (the presentation) we launch in the tab SLIDE SHOW by: 
    • From beginning (if we want to launch presentation from beginning); shortcut F5 or
    • the button From Current Slide (if want to launch presentation from current slide); shortcut SHIFT + F5

Microsoft PowerPoint Slide – the cornerstone of each presentation