The Easiest Beginners Guide to Microsoft Excel

The Easiest Beginners Guide to Microsoft Excel

If you’ve struggled with Excel or you don’t know much about it, I’ve created this course just for you.

What you’ll learn

Getting started from absolute basics – Opening and Saving Excel, Screen navigation, Screen Elements Explained, Typing and Deleting Data
Text and Cell formatting – Font Selection and Sizing, Bold, Italic and Underline, Border Creation, Horizontal and Vertical Justification, Wrap Texting, Row and Column Adjustment
Number Formatting – Decimal Places, Data Types, Decimal Places, Currency and Accounting, Dates, Format Paint
AutoSum and Count Function – Application, Average, Minimum, Maximum, Count, Connection Readjustment, Large Table Considerations
Formulas – Arithmetic Operations, Cell Linking, BODMAS, Formula Duplication, Fill Handle
Equation Creator, Symbols, WordArt and Hyperlinks (File, Workbook and Webpage Options)
Data Organisation using Sheets – Do’s and Don’ts, Renaming, Reordering, Tab Colouring, Moving, Copying, New Window Function
Images – Importation Methods, Moving, Resizing, Rotating, Picture Styling, Artistic Effects, Bring/Send to Front/Back, Cropping
Shapes – Textboxes and Formatting, Arrows and Arrow Locking, Shape Proportion Adjustments, Object Rotation, Quick Duplication Techniques
SmartArt – Insertion, Indenting and Hierarchies, Colours, Accents, Styles, Layout Changes, Graphic Restting
Data Sorting and Filtering – A-to-Z, Z-to-A, Primary Key Theory, Custom Sort by Field Name, Sorting by Colour, Multi-Level Sorting
Line Charts – Data Preparation, Chart Elements, Styling Options, Chart Features
Printing – Page Breaks, Margin Settings, Orientation, Paper Select, Page Layout, Scaling, Print Tiles, Printing, Portable Document Format (PDF)

Close Menu