rhodes training & development
Live Learning Lounge 2020
•  eLearning
•  Live Learning Lounge September 2020
•  Live Learning Lounge October 2020
•  Psychometric Profiling with Feedback
 
Search Courses
 
 
 
 
NHS Discounts
 
Tel:   Email:

Live Learning Lounge 2020 > 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

Places:

< back

 

Website contents copyright © Rhodes Training & Development | Site by Satsuma Media