Microsoft Excel for Beginners

Microsoft Excel is a powerful tool for data analysis and documentation, featuring an interface of columns and rows where each intersection forms a “cell” that holds individual pieces of data or information. Organizing data in this structured manner makes it easier to locate specific information and allows for automatic updates as data changes. This course covers the basics of opening an Excel document, creating a spreadsheet from scratch, writing formulas, and saving your work to your computer.

In this course, you will quickly become comfortable navigating the entire Excel dashboard, including its tabs, ribbon, and various tools. Whether you are a beginner or have some experience with Excel, this course will enhance your skills and confidence in using Excel for a variety of tasks, from simple data entry to more complex data analysis.

No prior skills are required. You just need Microsoft Excel installed on your computer.

1: Introduction

• Learn the basic structure of Excel, including columns, rows, and cells.
• Understand how to open, create, and save Excel documents.
• Master the use of formulas for data calculation and analysis.
• Get comfortable with navigating the Excel dashboard, including tabs, ribbons, and tools.
• Explore practical applications for data organization, analysis, and visualization.

2: Excel Interface

• Workbook and Worksheets
• Tabs and Ribbon
• Formula Bar
• Quick Access Toolbar
• Status Bar
• Cell Address Box
• Navigation Pane

3: Modifying a Worksheet

• Inserting and deleting rows and columns
• Resizing rows and columns
• Moving and copying cells
• Using cut, copy, and paste functions
• Applying cell formatting (font, color, borders)
• Merging and splitting cells
• Using find and replace functions

4: Formatting

• Font styles, sizes, and colors
• Text alignment (left, center, right)
• Cell borders and shading
• Number formats (currency, date, percentage)
• Conditional formatting for data visualization
• Applying cell styles
• Clearing formatting from cells

5: Formula Syntax and Keyboard Shortcuts

• Writing formulas using operators (+, -, *, /)
• Understanding cell references (absolute, relative, mixed)
• Utilizing functions (SUM, AVERAGE, IF, VLOOKUP)
• Applying logical operators (>, <, =)
• Using parentheses to control calculation order
• Accessing common functions through keyboard shortcuts
• Employing keyboard shortcuts for quick navigation and editing in Excel

6: Formulas & Functions

• Basic arithmetic operations (addition, subtraction, multiplication, division)
• Using built-in functions for mathematical calculations (SUM, AVERAGE, MAX, MIN)
• Logical functions for conditional operations (IF, AND, OR)
• Lookup and reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
• Text manipulation functions (CONCATENATE, LEFT, RIGHT, MID)
• Date and time functions (TODAY, NOW, DATE, YEAR, MONTH, DAY)
• Statistical functions for data analysis (COUNT, COUNTIF, SUMIF, AVERAGEIF)

7: Sorting and Filling Tables

• Sorting data alphabetically or numerically by one or multiple columns
• Sorting data in ascending or descending order
• Using custom sort options to prioritize specific criteria
• Auto-filling data series or patterns in adjacent cells
• Utilizing the fill handle to quickly copy and fill data across rows or columns
• Applying fill series options for linear or growth sequences
• Managing and adjusting table ranges after sorting or filling operations

8: Quick Access Toolbar

9: Share & Co-author

10: Linked Data Types

11: Pivot Tables

12: Charts

13: Introduction to Power Query

14: Summary

Our aim is not just to get you the qualification but also guide you through all processes while you are applying for your SIA Licence. Following are some of the reasons why you should choose us as your training provider:

• Excellent Success Rate!
• Fully accredited and authorized training center in London!
• Most competitive prices with NO HIDDEN COSTS!
• Prices are all inclusive of tuition, handbook, notebook, exams and certificate costs!
• Nationally recognized and Ofqual accredited training course!
• Highly skilled and qualified trainers with a great wealth of practical knowledge & experience!
• Post-qualification email support while you are preparing to book your licence application!
• Free guidance session on how to apply and obtain a SIA Licence!