Enable Technology

Excel 

Excel 2016 Basic




Course Overview


A one day course introducing Excel 2016.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

Duration: 1 day course



Course Content


Getting to Know Excel 2016
Starting Excel From the Desktop
Understanding the Excel Start Screen
The Excel Workbook Screen
How Excel 2016 Works
Using the Ribbon
Showing and Collapsing the Ribbon
Understanding the Backstage View
Accessing the Backstage View
Using Shortcut Menus
Understanding Dialog Boxes
Launching Dialog Boxes
Understanding the Quick Access Toolbar
Adding Commands to the QAT
Understanding the Status Bar
Exiting Safely From Excel 2016

Creating a New Workbook
Understanding Workbooks
Using the Blank Workbook Template
Typing Text
Typing Numbers
Typing Dates
Typing Formulas
Easy Formulas
Saving a New Workbook on Your Computer
Checking the Spelling
Making Basic Changes
Safely Closing a Workbook

Working With Workbooks
Opening an Existing Workbook
Navigating a Workbook
Navigating Using the Keyboard
Using Go To
Recent Files and Folders

Editing in a Workbook
Understanding Data Editing
Overwriting Cell Contents
Editing Longer Cells
Editing Formulas
Clearing Cells
Deleting Data
Using Undo and Redo

Selecting Ranges
Understanding Cells and Ranges
Selecting Contiguous Ranges
Selecting Non Contiguous Ranges
Selecting Larger Ranges
Selecting Rows
Selecting Columns

Copying Data
Understanding Copying in Excel
Using Fill for Quick Copying
Copying From One Cell to Another
Copying From One Cell to a Range
Copying From One Range to Another

Filling Data
Understanding Filling
Filling a Series
Filling a Growth Series
Extracting With Flash Fill

Moving Data
Understanding Moving in Excel
Moving Cells and Ranges
Moving by Dragging

Formulas and Functions
Understanding Formulas
Creating Formulas That Add
Creating Formulas That Subtract
Formulas That Multiply and Divide
Understanding Functions
Using the SUM Function to Add
Summing Non-Contiguous Ranges
Calculating an Average
Finding a Maximum Value
Finding a Minimum Value
Creating More Complex Formulas
What if Formulas
Common Error Messages

Formula Referencing
Absolute Versus Relative Referencing
Relative Formulas
Problems With Relative Formulas
Creating Absolute References
Creating Mixed References

Font Formatting
Understanding Font Formatting
Working With Live Preview
Changing Fonts
Changing Font Size
Growing and Shrinking Fonts
Making Cells Bold
Italicising Text
Underlining Text
Changing Font Colours
Changing Background Colours
Using the Format Painter

Cell Alignment
Understanding Cell Alignment
Horizontal Cell Alignment
Vertical Cell Alignment
Indenting Cells

Number Formatting
Understanding Number Formatting
Applying General Formatting
Formatting for Money
Formatting Percentages
Formatting as Fractions
Formatting as Dates
Using the Thousands Separator
Increasing and Decreasing Decimals

Row and Column Formatting
Approximating Column Widths
Setting Precise Columns Widths
Setting the Default Column Width
Approximating Row Height
Setting Precise Row Heights

Working With a Worksheet
Understanding Worksheets
Changing the Worksheet View
Worksheet Zooming
Viewing the Formula Bar
Viewing Worksheet Gridlines
Inserting Cells Into a Worksheet
Deleting Cells From a Worksheet
Inserting Columns Into a Worksheet
Inserting Rows Into a Worksheet
Deleting Rows and Columns
Working With Multiple Worksheets
Worksheet Wisdom

Sorting Data
Understanding Lists
Performing an Alphabetical Sort
Performing a Numerical Sort
Sorting on More Than One Column

Filtering Data
Understanding Filtering
Applying and Using a Filter
Clearing a Filter
Creating Compound Filters
Multiple Value Filters
Creating Custom Filters
Using Wildcards

Printing
Understanding Printing
Previewing Before You Print
Selecting a Printer
Printing a Range
Printing an Entire Workbook
Specifying the Number of Copies
The Print Options

Creating Charts
Understanding the Charting Process
Choosing the Right Chart
Using a Recommended Chart
Creating a New Chart From Scratch
Working With an Embedded Chart
Resizing a Chart
Repositioning a Chart
Printing an Embedded Chart
Creating a Chart Sheet
Changing the Chart Type
Changing the Chart Layout
Changing the Chart Style
Printing a Chart Sheet
Embedding a Chart Into a Worksheet
Deleting a Chart

Getting Help
Understanding How Help Works
Using Tell Me
Accessing the Help Window
Navigating the Help Window
Using Google to Get Help
Printing a Help Topic
Other Sources of Assistance

 






Email us about this courses         Telephone on 01952 305730






Training Locations: Enable Technology run courses in Wolverhampton, Telford, Shrewsbury, Birmingham, Cannock, Walsall, Dudley, Sandwell, Bridgnorth, Lichfield, Burton-upon-Trent, Stafford, Redditch, Bromsgrove, Solihull, Tamworth, Worcester, Shropshire, Staffordshire, Worcestershire and across the West Midlands.




West Midlands Scheduled Courses: Excel VBA; MS Project, SSRS; SQL; Crystal Reports; HTML;Adobe Illustrator; ASP.NET; Dreamweaver; Flash; Photoshop; InDesign; Google Scripting; Visio; PHP; Microsoft Access; JQuery JavaScript; Web Development; Office;

Birmingham Scheduled Courses: SQL; Excel VBA; MS Access;Photoshop; Adobe Illustrator; InDesign; Dreamweaver; MS Project;Visio; Flash; SSRS;PHP; JavaScript JQuery; HTML CSS; Microsoft Office;

Wolverhampton Scheduled Courses: Microsoft Access; Excel VBAMS Project; Visio; Adobe Illustrator; Photoshop; Dreamweaver; InDesign; Flash; HTML CSS; JavaScript; SQL; Microsoft Office; Adobe

Telford Scheduled Courses: SQL; Excel VBA; MS Project; Visio; PowerPoint; Photoshop; Adobe InDesign; Illustrator; Dreamweaver; Web Design; Office;

Cannock Scheduled Courses: Excel VBA; PHP; Microsoft Access; Visio; MS Project; PowerPoint; Dreamweaver; Photoshop; InDesign; Adobe Illustrator; Flash; JavaScript; HTML CSS;

Walsall Scheduled Courses: Excel; Access; MS Project; Visio; Photoshop; InDesign; Adobe Illustrator; Dreamweaver; Flash; SQL; JavaScript; HTML CSS;

Dudley Scheduled Courses: Excel; MS Access; SQL; MS Project;Visio; Adobe Illustrator; InDesign; Photoshop; Dreamweaver; Flash; JavaScript; HTML CSS;

Sandwell Scheduled Courses: Access;Excel; Microsoft Project; Visio; PowerPoint; Adobe Illustrator; Photoshop; Adobe InDesign; Dreamweaver; Flash; JavaScript; HTML CSS; SQL;

Shropshire Scheduled Courses: Illustrator; InDesign; Adobe; Dreamweaver; Flash; Photoshop; Excel; Project; Visio; PowerPoint; Office; JavaScript; HTML; Access;

Staffordshire Scheduled Courses: Illustrator; InDesign; Photoshop; Dreamweaver; Flash; Adobe; Excel;