Microsoft Excel (Basic)
Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Microsoft Excel provides a grid interface to organize nearly any type of information. The power of Excel lies in it’s flexibility to define the layout and structure of the information you want to manage. MS Excel allows you to work with text, numbers, and date information in a relatively open and unstructured way. Nearly 30 years after it’s initial introduction, Excel remains the worlds leading spreadsheet software.
The Basics
- Creating a New Workbook
- Navigating in Excel
- Moving the Cell Pointer
- Using Excel Menus
- Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
- Entering Values in a Worksheet and Selecting a Cell Range
- Previewing and Printing a Worksheet
- Getting Help from the Office Assistant
- Saving a Workbook & Re-opening a saved workbook
Formatting a Worksheet
- Creating Headers, Footers, and Page Numbers
- Adjusting Page Margins and Orientation
- Adding Print Titles and Grid lines, rows to repeat at top of each page
- Formatting Fonts & Values
- Adjusting Row Height and Column Width
- Changing Cell Alignment
- Adding Borders
- Applying Colors and Patterns
- Using the Format Painter
- Using Auto Format
- Merging Cells, Rotating Text, and using Auto Fit
- Using Auto Fill
Managing your workbooks
Editing a Workbook
- Entering Date Values and using Auto Complete
- Editing, Clearing, and Replacing Cell Contents
- Cutting, Copying, and Pasting Cells
- Moving and Copying Cells with Drag and Drop
- Collecting and Pasting Multiple Items
- Using the Paste Special Command
- Inserting and Deleting Cells, Rows, and Columns
- Using Undo, Redo, and Repeat
- Checking Your Spelling
- Finding and Replacing Information
- Inserting Cell Comments
Formulas
Creating & Working with Charts
USING RANGES
COPYING & PASTING FORMULAS
COLUMNS & ROWS
Course Rating
Microsoft Excel (Basic)
Course Provider: Organization
Course Provider Name: Rolla Academy Dubai
Course Provider URL: https://rollaacademydubai.com/
4.98
- Duration 15 hours
- Lessons 63
- Enrolled 1670 student
- Access Lifetime
More Courses You Might Like
Microsoft Outlook
Microsoft Outlook is a personal information manager from Microsoft, available as a part of the Microsoft Office suite. Although often used mainly as an email application, it also includes a calendar, task manager, contact manager, note taking, journal, and web browsing.
MS Excel (Advanced)
Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Advanced Microsoft Excel training is for those people who know Excel already and is designed for students to gain advanced
Microsoft Access
Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
