Microsoft Excel Training - Level 1
Learning Outcomes: The Excel Level 1 course is designed for the novice spreadsheet user who needs to be able to work with existing Excel files as well as create new ones from scratch. The course will give you the skills you need to enter, edit and format data, create formulas from scratch, design charts that have professional appeal and use the database tools to sort and filter information. You will learn many useful shortcuts that will save you time at work.
Course Pre-Requisites: Participants should have either completed the three hour Introduction to MS Excel or have some basic exposure to the concepts of spreadsheeting. It is also desirable that students have a general understanding of personal computers and the Windows operating system, especially in regard to working with files and folders.
Duration: 3 hours
Getting to Know Excel
Starting Excel From the Desktop
The Excel Workbook Screen
Using the Ribbon
Showing and Collapsing the Ribbon
Understanding the Backstage View
Accessing the Backstage View
Using Shortcut Menus
Understanding Dialog Boxes
Launching Dialog Boxes
Understanding the Quick Access Toolbar
Adding Commands to the QAT
Understanding the Status Bar
Exiting Safely From Excel
Creating a New Workbook
Using the Blank Workbook Template
Typing Text & Numbers
Typing Dates
Typing Formulas
Easy Formulas
Saving a New Workbook on Your Computer
Checking the Spelling
Making Basic Changes
Safely Closing a Workbook
Working With Workbooks
Opening an Existing Workbook
Navigating a Workbook
Navigating Using the Keyboard
Using Go To
Recent Files and Folders
Editing in a Workbook
Understanding Data Editing
Overwriting Cell Contents
Editing Longer Cells
Editing Formulas
Clearing Cells
Deleting Data
Using Undo and Redo
Selecting Ranges Understanding Cells and Ranges Selecting Contiguous Ranges Selecting Non Contiguous Ranges Selecting Larger Ranges Selecting Rows Selecting Columns
Copying Data Understanding Copying in Excel Using Fill for Quick Copying Copying From One Cell to Another Copying From One Cell to a Range Copying From One Range to Another
Filling Data Understanding Filling Filling a Series Filling a Growth Series Extracting With Flash Fill
Moving Data Understanding Moving in Excel Moving Cells and Ranges Moving by Dragging
Formulas and Functions Understanding Formulas Creating Formulas That Add Creating Formulas That Subtract Formulas That Multiply and Divide Understanding Functions Using the SUM Function to Add Summing Non-Contiguous Ranges Calculating an Average Finding a Maximum Value Finding a Minimum Value Creating More Complex Formulas What if Formulas Common Error Messages
|
Formula Referencing Absolute Versus Relative Referencing Relative Formulas Problems With Relative Formulas Creating Absolute References Creating Mixed References
Font Formatting Understanding Font Formatting Working With Live Preview Changing Fonts & Font Sizes Growing and Shrinking Fonts Making Cells Bold Italicising Text Underlining Text Changing Font Colours Changing Background Colours Using the Format Painter
Cell Alignment Understanding Cell Alignment Horizontal Cell Alignment Vertical Cell Alignment Indenting Cells Number Formatting Applying General Formatting Formatting for Money & Percentages Formatting as Fractions Formatting as Dates Using the Thousands Separator Increasing and Decreasing Decimals
Row and Column Formatting Approximating Column Widths Setting Precise Columns Widths Setting the Default Column Width Approximating Row Height Setting Precise Row Heights
Working With a Worksheet Understanding Worksheets Changing the Worksheet View Worksheet Zooming Viewing the Formula Bar Viewing Worksheet Gridlines Inserting Cells Into a Worksheet Deleting Cells From a Worksheet Inserting Columns Into a Worksheet Deleting Rows and Columns Working With Multiple Worksheets Worksheet Wisdom |
Sorting Data
Understanding Lists
Performing an Alphabetical Sort
Performing a Numerical Sort
Sorting on More Than One Column
Filtering Data
Understanding Filtering
Applying and Using a Filter
Clearing a Filter
Creating Compound Filters
Multiple Value Filters
Creating Custom Filters
Using Wildcards
Printing
Understanding Printing
Previewing Before You Print
Selecting a Printer
Printing a Range
Printing an Entire Workbook
Specifying the Number of Copies
The Print Options
Creating Charts
Understanding the Charting Process
Choosing the Right Chart
Using a Recommended Chart
Creating a New Chart From Scratch
Working With an Embedded Chart
Resizing a Chart
Repositioning a Chart
Printing an Embedded Chart
Creating a Chart Sheet
Changing the Chart Type
Changing the Chart Layout
Changing the Chart Style
Printing a Chart Sheet
Embedding a Chart Into a Worksheet
Deleting a Chart
Getting Help
Understanding How Help Works
Using Tell Me
Accessing the Help Window
Navigating the Help Window
Using Google to Get Help
Printing a Help Topic
Other Sources of Assistance
A Guide to Brilliant Spreadsheets
Good Planning Is Essential
Organisation and Design
Writing Effective Formulas
Documented and Easy to Use