Microsoft Excel Step by Step Training for Beginners!
Learn all the basics of Microsoft Excel and begin creating amazing templates and tables in just a few hours!!
Bạn sẽ học được:
- 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!
- Microsoft Excel 2007 or later
- Access to a computer
- Access to the internet
- Pdf file reader (Adobe Acrobat, Adobe Reader, etc. This should come standard with your computer)
- No prior Excel knowledge required
- Access to computer and internet
- Paper and pen to take notes