This course is designed for beginners and covers: Excel basics; working with data; editing a worksheet; editing text; formatting a worksheet; page setup and printing; working with pages; formulas and functions; and modifying workbooks.
The course is held in Peterborough at the following address:
4-5 Newark Rd
Creating An Excel Workbook, Examining The Excel Environment, Opening An Existing Workbook, Navigating A Worksheet, Creating A New Workbook, Saving A New Workbook, Moving Between Workbooks, Setting Excel Options, Switching Between Views, Using Help, Closing A Workbook And Exiting Excel
Working With Data
Entering Text And Numbers, Entering Simple Formulas, Choosing Formula Cell References Manually, Using Autosum, Changing & Deleting Data, Using Undo/Redo, Using Find And Replace, Using The Go To Command, Spell Checking Your Worksheet, Inserting Symbols
Editing A Worksheet
Working With Ranges, Copying And Pasting Data, Using The Office Clipboard, Cutting And Pasting Data, Copying And Moving Cells Using Drag-And-Drop, Changing Column Width, Changing Row Height, Inserting And Removing Rows And Columns, Copying Data And Formulas With Autofill, Filling In Cells Using Flash Fill
Formatting A Worksheet
Formatting Text, Using The Format Cells Dialog Box, Formatting Values, Using The Format Painter Button, Alignment And Text Wrapping, Merging Cells And Centering Text, Adding Cell Borders, Applying Colors And Shading To Cells, Applying Cell Styles, Hiding And Unhiding Rows And Columns, Freezing And Unfreezing Rows And Columns, Inserting And Removing Page Breaks
Page Setup And Printing
Adjusting Margins, Setting Page Orientation, Setting Paper Size, Defining A Print Area, Printing Worksheet Titles, Forcing A Worksheet To Fit, Inserting Headers And Footers, Printing A Worksheet
Formulas And Functions
Relative References, Absolute References, Mixed References, Copying Formulas, Min, Max, Count And Average Functions, The Insert Function Button
Adding And Deleting Worksheets, Copying Worksheets, Renaming Worksheets, Repositioning Worksheets, Grouping Worksheets, Changing Worksheet Tab Colors, Using 3-D Formulas & References
Save This Event
When & Where
4-5 Newark Rd
PE1 5WS Peterborough
G Com Solutions Limited
G Com Solutions specialise in providing Microsoft Power BI training, as well as IT training on a variety of web technologies and computer software packages, especially those by Microsoft and Adobe. These software environments have become the standard for business, web and multimedia development since they empower companies to develop web solutions more quickly than ever.
Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you.