Excel 2007/2010 Essentials special 9 January R 1050 excl VAT

By: College Africa Group (Pty) Ltd  12-11-2012
Keywords: Computer Training, Computer Education, Microsoft Office

This course is specially for those who need to be prepared before the real work starts in 2013! Not only that discounted as well by 30%. Other course are available. Call Arnold 0837784903 EASYEXCEL EXCEL BEGINNER LEVEL 2007/2010 TABLE OF CONTENTS • HOW TO USE THIS MANUAL • SPREADSHEET BASICS • RUNNING MICROSOFT EXCEL • THE EXCEL SCREEN • NAVIGATING WITHIN A WORKSHEET • CHANGING THE WORKBOOK VIEW • WORKING WITH HELP • PRINTING HELP TOPICS • EXITING HELP • SCREENTIPS • ENTERING INFORMATION • THE AUTOCOMPLETE FEATURE • PICK FROM LIST • EDITING DATA • DELETING DATA • CLEARING A CELL • OOPS! UNDOING THE DELETION • REDOING COMMANDS • WORKING WITH BLOCKS • MOUSE SHAPES • SELECTING A CONTIGUOUS BLOCK OF CELLS • SELECTING NONCONTIGUOUS BLOCKS OF CELLS • SELECTING THE ENTIRE WORKSHEET • ADJUSTING COLUMN WIDTH & ROW HEIGHT • ENTERING A FORMULA • ENTERING NATURAL LANGUAGE FORMULAS • CORRECTING FORMULAS • USING THE AUTO FILL • USING THE FILL TOOL • AUTO FILL OPTIONS • SPELL CHECKING THE WORKSHEET • SAVING YOUR WORKBOOK • PREVIEWING A WORKBOOK • CHANGING THE PAGE SETUP • CHANGING MARGINS • CHANGING ORIENTATION • CHANGING PAPER SIZE • CHANGING THE PRINT AREA • SETTING/REMOVING PAGE BREAKS • DEFINING PRINT TITLES • ACCESSING THE PAGE SETUP DIALOG BOX • CUSTOMIZING MARGINS • CUSTOMIZING HEADERS/FOOTERS • SHEET PRINTOUT OPTIONS • PRINTING YOUR WORKSHEET • CLOSING A DOCUMENT • CREATING A NEW WORKBOOK • SWITCHING BETWEEN MULTIPLE WORKBOOKS • OPENING AN EXISTING WORKBOOK • MOVING DATA • COPYING TEXT • PASTE FORMAT OPTIONS • PASTE OPTIONS • DRAGGING & DROPPING • MOVING CELLS WITH DRAG & DROP • COPYING CELLS WITH DRAG & DROP • MOVING DATA ACROSS WORKSHEETS • COPYING DATA ACROSS WORKSHEETS • WORKING WITH THE OFFICE CLIPBOARD • CLIPBOARD OPTIONS • ALIGNING CELL DATA • MERGE AND CENTER ACROSS COLUMNS • VERTICALLY ALIGNING DATA • INDENTING TEXT WITHIN A CELL • CHANGING TEXT ORIENTATION • WRAPPING TEXT WITHIN A CELL • FORMATTING NUMBERS • INSERTING A ROW/COLUMN • DELETING A ROW/COLUMN • WORKING WITH FUNCTION ARGUMENTS • WORKING WITH FUNCTION ARGUMENTS • THE AUTOSUM FEATURE • ACCESSING OTHER FUNCTIONS • APPLYING ATTRIBUTES • REMOVING ATTRIBUTES • CHANGING FONTS & POINT SIZE • CELL BORDERS AND COLORS • ADDING CELL BORDERS • ADDING A FILL COLOR • CHANGING THE FONT COLOR • CUSTOMIZING CELL FORMATS • THE NUMBER TAB • THE ALIGNMENT TAB • THE FONT TAB • THE BORDER TAB • THE FILL TAB • THE PROTECTION TAB • USING CELL STYLES • USING THE FORMAT PAINTER • CREATING A CHART • SELECTING CHART OBJECTS • SIZING THE CHART • MOVING THE CHART • EDITING THE CHART • PRINTING THE CHART • APPLYING TEXT ATTRIBUTES TO CHART OBJECTS • CHANGING THE FONT OF CHART OBJECTS • CHANGING FONT SIZE • CHANGING THE FONT COLOR • APPLYING NUMERIC FORMATS TO CHART OBJECTS • CHANGING COLORS • ABSOLUTE CELL ADDRESSING • DOCUMENT RECOVERY • WORKING WITH TEMPLATES • CREATING A NEW TEMPLATE • USING A TEMPLATE • OPENING A TEMPLATE • SAVING AN EXISTING WORKBOOK AS A TEMPLATE

Keywords: Computer Education, Computer Learning, Computer Training, Excel Training, Microsoft Office

Contact College Africa Group (Pty) Ltd

Email

Print this page

Share

Other products and services from College Africa Group (Pty) Ltd

National Microsoft Office and other training from College Africa Group (Pty) Ltd thumbnail
08-04-2015

National Microsoft Office and other training

National Professional accredited Microsoft Office and interpersonal training provider


12-06-2012

Microsoft office, Excel, Word & PowerPoint Durban special

Durban Microsoft training holiday special


12-06-2012

SETA accredited Microsoft office and soft skills training provider

SETA accredited Microsoft office, Excel, Word, PowerPoint and soft skills training provider


12-06-2012

Microsoft Office and softskills training anywhere in South Africa

Professional, accredited Microsoft office and soft skills training throughout South Africa