Learn all the basics of Microsoft Excel and begin creating amazing templates and tables in just a few hours!!
What you’ll learn
Basic controls – Opening Excel, Navigation, Scrolling Zooming
A Quick Glimpse of the Power of Excel – Full Table Design, fill handle, Autosums, Basic Formula’s, Formatting, Wordart, Status Bar
The Quick Access Toolbar – Productivity Tool, Keyboard Shortcuts
Cell and Sheet Control – Cell Inputting, Table Navigation, Formatting Cells, Copying and Pasting, Fonts, Row and Column Manipulation, Sheets, Screen Tiling
“If” function – Logic Functions, “If” Formula, “And” Formula, “Or” Formula
Charts and Graphs – Line Graphs, Scatter Plots, Column Charts, Pie Graphs, Trend Lines
Images and shapes – Inserting Images, Print Screen, Grouping, Cropping, Brightness, Contrast, Colouring, Resizing, Rotation, Frames
Cleaning and Preparing a Table for Presentation – Spellchecker, Search and Replace, Text Cleaning, Pasting Types, Sort and Filter, Freeze Panes, Custom Borders, Cell Merging
How to Print like an Artist – Page Views, Setting Print Area, Paper Size, Orientation, Print Margins, Scaling, Headers and Footers, PDF Print, Printing
Life Management Tools – Custom designed spreadsheets to assist in planning holidays, Finances and Dinner!