![]( "Live Learning Lounge September 2020")
Excel Level 1 - Parts 1&2
Microsoft
Excel Bite Size Level One – Part 1
Duration: 90
minutes (both sessions)
Medium: Zoom
Audience
This
course is aimed at participants wanting to refresh their Excel skills. Focusing on building formulas using
functionality such as "Absolute Cell†referencing. The Autofill facility will also be explored
including building your own default fill lists.
Content
·
Autofill
·
Flash
Fill
·
Building
defined Autofill lists
·
Using
the Status bar to quickly complete calculations
·
Using
the formula bar
·
Using
the "Insert Function, FX†functionality
·
Basic
formula creation
·
Creating
an "Absolute Cell†reference in a formula
·
Creating
cross sheet formulas
·
Creating
cross workbook formulas
·
AutoSum
·
Quickly
copy or move worksheet information within a spreadsheet or new workbook
·
Freeze
pains
·
Splitting
screens
Microsoft Excel Bite Size Level One – Part 1
Audience
This
course is aimed at participants wanting to expand on their Excel knowledge form
the level 1 – part 1 training session.
This session will continue with the concepts taught on the previous session
and include checking knowledge. Creating
charts using Conditional Formatting to manage will also be explored on part 2.
Content
· A
brief recap on previous functionality taught on level 1 – part 1
·
Creating
charts – using two different methods
·
Manipulating
charts
·
Applying
Conditional Formatting
·
Applying
Formulas within Conditional Formatting
·
Clearing
conditional formatting
·
Managing
print layout
·
Managing
orientation
·
Managing
print selection
·
Apply
Headers and Footers
·
Managing
print scale
Cost: 0
< back
|
