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.
some of the learning objectives for our session:
budget and expense workbooks,
and navigate through rows, columns, and worksheets in Excel with ease,
worksheets with text positioning, merging cells, number formatting, and colors,
include SUM, AVERAGE, and COUNT,
different cell referencing and syntax for formulas and functions,
headers and footers on worksheets,
Page Set-up to change our orientation, titles, margins, and set print area,