MP4 | Video: h264, 1280x720 | Audio: AAC, 44100 Hz
Language: English | Size: 628 MB | Duration: 1h 1m
What you'll learn
This course is designed to teach you the basic foundations of Microsoft Excel, so that you will feel comfortable navigating the world's most popular spreadsheet software.
- Developed on the latest Office 365 Software
Requirements
Have a working knowledge of using a keyboard and mouse
Be able to open and close programs in Microsoft Windows
Be familiar with navigating to stored files
Have the ability to save files in folders
Description
This course is designed to teach you the basic foundations of Microsoft Excel, so that you will feel comfortable navigating the world's most popular spreadsheet software. Learn what Excel is used for, what workbooks and worksheets are and how to manage them. Navigate your way around cells, rows and columns in a worksheet. Discover how to format different types of data and use conditioning formatting to highlight relevant data making analysis easier. Work with formulas and formulae and discover how to add them to perform calculations. Learn about charts and changing views, as well as discover how to print your worksheets.
Achieve tasks like:
Signing into Excel.
Finding the Quick Access toolbar.
Discovering the Menu options.
Navigating through Worksheets.
Opening a recently used Workbook
Starting from scratch
Saving Workbooks
Pinning a Workbook
Creating New
Copying and Renaming
Changing colours
Selecting cells
Selecting a range of cells
Selecting non-adjacent cells
Selecting an entire Worksheet
Selection cursors
Scrolling using the scroll bars
Changing the width of a column
Changing the height of a row
Inserting columns
Deleting columns
Inserting rows
Deleting rows
Inserting text
Inserting values
Spell check
Moving data
Copying and Pasting data
Autofill
Inserting a picture
Changing the font and size
Adding visual effects
Adding borders
Highlighting cells and changing the font color
Using the format painter
Aligning and wrapping data
Merging cells
Changing the format of data
Formatting cells as a table
Sorting and filtering data
Highlight cell rules
Sorting by color
Top/Bottom rules
Icon sets
Data Bars
Color Scales
SUM, TODAY
Inserting formulae
Absolute and relative cell references
AutoSum, AVERAGE, COUNT, MAX, MIN
Types of charts
Recommended charts
Moving charts
Changing the chart title
Changing the data source
Formatting chart axis
Zoom
Freeze Panes
Quick Access toolbar
Hide/Show
Default Options
Page Orientation
Scaling
Margins
Header/Footer
Print Area
Print Titles
Print Preview
Who this course is for:
Beginner Students who want to learn and master the basics of Excel
- Developed on the latest Office 365 Software to include the latest features
Screenshots
Download link:
Só visivel para registados e com resposta ao tópico.Only visible to registered and with a reply to the topic.Links are Interchangeable - No Password - Single Extraction
Cantinho Satkeys
