- Courses/
- Microsoft Excel/
- Excel Introduction/
Microsoft Excel Training Courses For Beginners
Excel Introduction
Gain essential Excel skills with our 1-day beginner course. Learn how to use Excel efficiently for business, perform calculations, create and use formulas, modify and format worksheets, and style data for greater impact. This training course is ideal for understanding and analysing your organisation's data to make informed business decisions.
Gain essential Excel skills with our 1-day beginner course. Learn how to use Excel efficiently for business, perform calculations, create and use formulas, modify and format worksheets, and style data for greater impact. This training course is ideal for understanding and analysing your organisation's data to make informed business decisions.
Virtually Online Or On-Site
1 Days
Next Running:
6th January
UPCOMING COURSES
Course Information
This 1-day Excel Introduction training course has been designed specifically for beginners. Our skilled trainer will provide you with foundational Excel knowledge and equip you with the necessary skills to start using it for your business straight away.
Choose from our online public courses dates to book your course today.
Alternatively, contact us to arrange on-site training tailored to your needs!
What you will learn
After completing this Excel Introduction course, you will be able to:
- Get working with Microsoft Excel efficiently and effectively
- Perform Excel calculations
- Optimise your worksheets by creating and using formulas
- Modify worksheets to manipulate and edit data
- Format and style Excel worksheets to get more impact from data
- Basic Excel spreadsheet training for business
By the end of this 1-day instructor-led Excel Introduction course, you will know how to use Excel to make sense of your organisation's raw data. You will gain a level of insight into that data which will empower you to make better business decisions.
All with our 100% Money-Back Guarantee and Unlimited Email Support.
1
Getting Started With Excel
- Starting Excel
- Selecting the Blank Worksheet Template
- The Excel Cell Referencing System
- Entering Numbers and Text
- Default Text and Number Alignment
- Summing a Column of Numbers
- Entering a Date
- Worksheets and Workbooks
- Saving a Workbook to Your Hard Disk
- Creating,Opening and Closing a Workbook
- Opening a Recently Used Workbook
- Saving a Workbook Using another Name
- Getting Help within Excel
2
Excel Selection Techniques
- Why Are Selection Techniques Important?
- Selecting a Cell, a Row and a Column
- Selecting a Range of Cells
- Selecting a Range of Rows
- Selecting a Range of Columns
- Selecting the Entire Worksheet
- Recommended Techniques When Creating or Editing Lists
3
Manipulating Rows And Columns Within Excel
- Inserting Rows and Columns into a Worksheet
- Deleting Rows and Columns within a Worksheet
- Modifying Column Widths
- Modifying Column Widths Using 'Drag and Drop'
- Automatically Resizing the Column Width to Fit Contents
- Modifying Row Heights
4
Manipulating Cells and Cell Content within Excel
- Copying a Cell or Range Contents within a Workbook
- Deleting Cell Contents
- Moving the Contents of a Cell or Range within a Workbook
- Editing Cell Content
- Undo and Redo
- Copying or Moving Data between Worksheets (Within the Same Workbook)
- Copying or Moving Data between Worksheets (In Different Workbooks)
- AutoFill
- Copying a Data Range Using AutoFill
- Searching and Replacing Data
5
Excel Worksheets
- Switching between Worksheets
- Renaming a Worksheet
- Recommended Techniques with Naming Worksheets
- Inserting and Deleting a Worksheet
- Copying or Moving a Worksheet within a Workbook
- Copying or Moving Worksheets between Workbooks
6
Alignment Formatting within Excel
- Horizontally Aligning Contents in a Cell Range
- Centring a Title over a Cell Range
- Text Wrapping within a Cell
- Format Painter
7
Number Formatting within Excel
- Number Formatting
- Decimal Point Display
- Applying and Removing Comma Style
- Formatting (To Indicate Thousands)
- Currency Symbol
- Date Styles
- Percentages
8
Freezing Titles
- Freezing Row and Column Titles
9
Excel Formulas
- Creating Formulas
- The Easy Way to Create Formulas
- Copying Formulas
- Operators
- Using Operators in Formulas
- Relative Cell Referencing within Formulas
- Absolute Cell Referencing within Formulas
10
Excel Functions
- What Are Functions?
- Common Functions
- Sum and Average Function
- Max and Min Function
- Count and Counta Function
11
Excel Charts
- Inserting a Column Chart
- Changing the Chart Type
- Formatting Charts
12
Customising Excel
- Modifying Basic Excel Options
Private courses.
We’ll help you meet your company training needs with instructor-led business skills and IT training courses, or your money back. Take courses in our UK classrooms or online - it’s your choice!
Tailored
Post Course Support
Cost Effective
Reviews
- Microsoft Excel
Excel Intermediate
Enhance your Excel skills with our 1-day Excel Intermediate course. You will learn advanced formulas, named ranges, data analysis, and conditional formatting. An ideal choice if you already have basic Excel knowledge. This course will empower you to make data-driven decisions.
Virtually Online Or On-Site
1 Days
- Microsoft Excel
Excel Advanced
Elevate your Excel prowess in our 1-day Excel Advanced training course. Master task automation, complex formulas, PivotTables, and data visualisation. Suited for experienced users, this course boosts your ability to analyse and present data.
Virtually Online Or On-Site
1 Days
- Microsoft Excel
Excel VBA Introduction
Boost your Excel skills with our Future Savvy 2-day Excel VBA course. Learn to automate spreadsheets, record macros, edit VBA code, and create custom forms. Perfect for gaining control and developing dynamic applications. Unlock the potential of workbooks and worksheets with hands-on guidance. Ideal for simplifying repetitive tasks and enhancing your Excel capabilities.
Virtually Online Or On-Site
2 Days
© 2024 - All Rights Reserved.
All trademarks are owned by their respective owners.
