BioPharmaChem Skillnet

Microsoft Excel Level 2

Microsoft Excel Level 2

95.00

Our Microsoft Excel Level Two – Intermediate course offers a comprehensive one-day program designed for individuals seeking to enhance their Excel skills beyond the basics. Tailored for users with prior experience but lacking formal training, this course covers a range of intermediate topics essential for proficient Excel usage.Participants will begin with a review of essential Excel functions and shortcut keys before delving into advanced formatting options, including conditional formatting and custom lists. They will learn to efficiently view and modify worksheets, master formulae and functions, and effectively work with multiple worksheets, including linking and copying data across them.The course also covers creating professional charts, utilising drawing tools, and managing database features such as sorting and filtering. Additionally, participants will gain proficiency in working with dates, formatting them, and performing date calculations for data analysis.By the end of the course, participants will have the skills and knowledge necessary to navigate Excel with confidence, improving their efficiency and effectiveness in handling data and presenting information

SKU: N/A Category:

Description

Empower yourself with essential Excel skills and take your data management and presentation abilities to the next level with our Microsoft Excel Level Two – Intermediate course. This comprehensive one-day program is tailored for individuals who have been using Microsoft Excel but have never undergone formal training. Participants will delve into both basic and intermediate topics, starting with essential skills such as shortcut keys and formatting options. The course then progresses to more intermediate functions including working with multiple worksheets, creating professional charts, and utilising database features like sorting and AutoFilter. Throughout the program, participants will also gain access to a library of tutorials to reinforce their learning.

Objectives:

What will you gain?

  • Master shortcut keys for efficient Excel usage
  • Utilise formatting tools, including the format painter, and conditional formatting
  • Write and copy formulas, understanding the concepts of relative vs. absolute cell addressing
  • Effectively work with multiple worksheets, including linking sheets and writing formulas across them
  • Create professional-looking charts and enhance them using drawing tools
  • Utilise database functionalities such as sorting and AutoFilter for efficient data management

Who Should Attend?

This course is ideal for individuals with a good working knowledge of MS Excel 2007 or 2010 but have never undergone formal training.

Outline:

Excel Basics (An Overview)

  • Review of essential Excel functions and commands
  • Introduction to shortcut keys for quick command execution

Formatting

  • Advanced formatting options including conditional formatting
  • Utilising the format painter for consistent formatting
  • Working with custom lists for efficient data management

Viewing and Modifying Worksheets

  • Zoom settings and splitting a worksheet for better visibility
  • Freezing titles and print titles for improved presentation
  • Hiding and unhiding columns and rows for better organisation

Formulae and Functions

  • Recap of basic formulae and functions
  • Understanding relative vs. absolute cell addressing
  • Copying formulae for efficient data manipulation

Working with Multiple Worksheets

  • Inserting, renaming, and deleting sheets
  • Moving and copying sheets for better organisation
  • Linking sheets using formulae for streamlined data management

Charts and Drawing Tools

  • Creating professional charts and changing chart types
  • Formatting charts for better visualisation
  • Utilising drawing tools for enhanced presentation

Database Features

  • Sorting records and utilising AutoFilter for efficient data management

Working with Dates

  • Formatting dates and performing date calculations for data analysis
  • The Today Function

Additional information

Course Date

22nd,23rd,24th&26th April

Course Timing

9.30am – 11am

Microsoft Excel Level 2
95.00