![online beginner excel courses online beginner excel courses](https://i.ytimg.com/vi/BK16ZYtmxzg/maxresdefault.jpg)
Lesson Five: Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, deleting a custom theme, page orientation, adjusting margins and scaling, centring the sheet horizontally and vertically, print preview and print a worksheet, viewing/hiding gridlines and row and column headings, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions, using Quick Analysis, sorting columns in ascending and descending order. Lesson Four: Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom, page break preview, page layout view, naming a worksheet, inserting and deleting a worksheet, repositioning worksheets, using the count function, saving a workbook as a template, creating a workbook from a template, online templates. Lesson Three: Inserting and deleting rows and columns, hiding and unhiding rows and columns, minimising the ribbon, modifying column widths and row heights, aligning cell contents vertically, wrapping and indenting text, applying a fill c o lour, a p plying borders, undo and redo, moving and copying cell contents using drag and drop, moving and copying cell contents using cut, copy and paste, copying formats using format painter, clearing formats.
![online beginner excel courses online beginner excel courses](https://prod-discovery.edx-cdn.org/media/programs/card_images/a9bdcab5-c199-478d-9220-a74cc2f077c6-2e34065bb917.png)
Lesson Two: Applying bold, italic and underline formats, changing font type and size, using the mini toolbar, changing the font colour, selecting and formatting cells ranges, selecting columns and rows, aligning cell contents horizontally, using merge and centre, applying number formats, printing the active worksheet, creating a new folder, saving a workbook with a different name and file type, viewing files in the open dialog box, using AutoFill, entering formulas for subtraction, multiplication, division and percentages. Lesson One: Opening the Excel program, identifying the elements of the opening screen, creating a worksheet with text and numbers, entering addition formulas, adjusting column widths, using the SUM function in a formula, using the AutoSum feature, editing text and numbers, navigating a workbook and worksheets, saving, naming and closing a workbook, opening an existing workbook, exiting Excel. Below is a break down of the lessons included in the Excel course: Or you could give your career a serious boost by completing one of our highly respected diplomas, in Bookkeeping or Microsoft Office, which could help maximise your career potential.Ĭomprising ten lessons this course covers areas such as creating worksheets, formatting text, simple and complex formulas handling rows and columns, autocomplete, using styles, headers and footers, average, max and min functions and using charts.
![online beginner excel courses online beginner excel courses](https://www.goskills.com/static/images/family/certificate-example.png)
Having completed your Microsoft Excel course, you could add Microsoft PowerPoint and Word to your list of achievements. This Excel course comprises several lessons, which provide a detailed but manageable study programme, so you can be confident about your new skills in the workplace. Our Microsoft Excel course is very flexible – you will have the freedom to take the Excel lessons at your own pace, based at one of our handy town or city centre locations, with support on hand should you need it.
Online beginner excel courses how to#
Microsoft Excel is the world’s most popular spreadsheet program learning how to use the software with Pitman Training shows that you’ve taken one of the best Excel courses available.