HOT COURSE - Introduction to Microsoft Excel Training in Belfast Northern Ireland OR On your Own Premises - Call NOW to Book

5 August 2024

Online and Classroom Based Courses Now Available:

• Delivered From Our Belfast City Centre Training Suites
• Fully Interactive & Instructor Led
• Hands on

 

• 1 day Intro to MS Excel course - delivered via our virtual classrooms - fully interactive & instructor led.
• Our 1 day Microsoft Excel Introduction course is suitable for complete beginners to Microsoft Excel.

PREREQUISTES

A working knowledge of Windows is required, or our Introduction to MS Windows course. No experience of MS Excel is required.

BENEFITS

At the end of this course you will have a good working knowledge of Excel basics. You will feel more confident using Excel and be able to create a spreadsheet from scratch. Understanding and using some of the calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable.

 

Tips For Setting Up Your Spreadsheet Properly

• How To Structure Your Spreadsheet To Maximise Efficiency

• Ensure Your Data Is Entered Correctly (Dates, Numbers, Text eg 0032)

• Understand How Excel ‘Thinks’ & Why It Behaves As It Does

Formatting

• Font Formatting

• Cell Formatting:

o Formats For Number, Currency, %age, Date

o Border& Fill

o Merge Cells & Centre Across Selection

o Text Wrapping Within A Cell

o Aligning Cell Contents Horizontally & Vertically

o Using The Format Painter

Working With Rows And Columns

• Inserting Rows & Columns

• Deleting Rows & Columns

• Hiding And Unhiding Rows & Columns

• Modifying Column Widths:

o Using 'Drag’

o Automatically To Fit Contents

• Modifying Row Heights

Working With Sheets

• Add & Rename

• Hide & Unhide

• Move & Copy

• Change Tab Colour

• Freeze Title Panes & Split Window

• View Multiple Sheets Side By Side

Sorting Data

Filtering Data

Using Formulas In Microsoft Excel

• Entering Formulas

o Math Operators + - * / % $

o Order Of Operations

• Entering Functions

o Sum, Count, Average, Min, Max

• Using The Replicate Node To Copy Formulas And Functions

• Relative And Absolute Cell References

Updating How Your Sheets Look When Printed

• Setting Margins

• Setting Page Orientation (Portrait/ Landscape)

• Setting The Print Area

• Print Scaling

o Print At Set %Age

o Set Pages To Print At ? Wide By ? Tall

• Headers And Footers:

o Page Numbering

o File Path & Filename

o Date & Time Of Print

• Gridlines

• Print Sheet Titles On Every Page

o Row & Column Headers

Charts

• Visualising Your Data By Creating Column/ Bar/ Bar Charts

• Updating Chart:

o Titles

o Data Labels

o Colours