Excel @ Excel: The FUNdamentals Manual


Excel @ Excel: The FUNdamentals Manual

This manual teaches clients how to create and edit workbooks as well as navigating and selecting multiple worksheets, columns, rows, and cells. We will learn important short cuts and timesaving tips and tricks as we create a budget and expense workbook. Worksheet formatting and proper set-up with formulas and functions are included. We will format cells with different fonts, fill colors, number formats, and use Merge and Center. You will customize Excel’s Quick Access Toolbar and Ribbon will increase efficiency in using Excel plus we will work with the different views of Excel (Normal, Page Layout, and Print Preview). We will work with AutoFill, function creation and editing, syntax for formulas and functions, and various cell references.   We will examine Print Preview, Page Set-up, Headers/Footers, and we will learn how to print large worksheets effectively.

Here some of the learning objectives for our session:

  • Create budget and expense workbooks,
  • Edit existing workbooks/worksheets,
  • Select and navigate through rows, columns, and worksheets in Excel with ease,
  • Enhance worksheets with text positioning, merging cells, number formatting, and colors,
  • Functions include SUM, AVERAGE, and COUNT,
  • Understand different cell referencing and syntax for formulas and functions,
  • Incorporate headers and footers on worksheets,
  • Use Page Set-up to change our orientation, titles, margins, and set print area,
  • Print worksheets effectively,
  • And much more.>