Free MS Excel Course
Microsoft Excel Training Session
Life is full of exciting new beginnings, as a great ocean starts from a tiny droplet. Our Excel for training is designed to support you every step of the way, taking you from being a complete novice to feeling confident and skilled in using Excel. We’ll kick things off by covering all the basics of Excel, from understanding spreadsheets to learning useful formulas and time-saving shortcuts. Then, we’ll dive into the fun stuff, teaching you essential Excel formulas and helping you become a pro at using handy data tools like sorting, filtering, data validations, and Data Importing.
At the end of this intensive Training
01.
- Introduction to Excel Interface
- Navigating the Interface: Understand the Excel window, Ribbon, and toolbars.
- Using the Quick Access Toolbar: Customize the toolbar for quick access to frequently used commands.
- Worksheet Basics: Learn about workbooks, worksheets, cells, rows, and columns.
- Basic Data Entry and Formatting
- Entering and Editing Data: How to input and modify cell text and numbers.
- Basic Formatting: Apply font styles, colours, and borders.
- Number Formatting: Format numbers as currency, percentages, dates, etc.
- Basic Formulas and Functions
- Simple Formulas: Perform basic arithmetic operations (addition, subtraction, multiplication, division).
- Using Functions: Introduction to common functions like SUM, AVERAGE, MIN, MAX.
- AutoSum: Quickly sum columns or rows of data.
- Working with Rows and Columns
- Inserting and Deleting Rows/Columns: Add or remove rows and columns.
- Resizing Rows and Columns: Adjust row height and column width.
- Hiding and Unhiding Rows/Columns: Manage the visibility of data.
- Basic Data Management
- Sorting Data: Sort data alphabetically or numerically.
- Filtering Data: Use AutoFilter to display only the data you need.
- Basic Data Validation: Ensure data entry accuracy.
- Basic Chart Creation
- Creating Charts: Introduction to creating simple charts like Bar, Column, and Pie charts.
- Customizing Charts: Modify chart titles, labels, and legends.
- Formatting Charts: Change chart styles and colors.
- Introduction to Printing
- Print Preview: View how your data will look when printed.
- Page Setup: Adjust page orientation, margins, and scaling.
- Printing Options: Print entire worksheets, selected areas, or specific pages.
02.
- Basic Chart Creation
- Creating Charts: Introduction to simple charts like Bar, Column, and Pie charts.
- Customizing Charts: Modify chart titles, labels, and legends.
- Formatting Charts: Change chart styles and colors.
- Introduction to Printing:
-
-
-
Print Preview: View how your data will look when printed.
Page Setup: Adjust page orientation, margins, and scaling.
Printing Options: Print entire worksheets, selected areas, or specific pages.
-
-
- Working with Multiple Worksheets
- Renaming Worksheets: Change worksheet names for better organization.
- Color Coding Worksheets: Use colors to organize different worksheets.
- Copying and Moving Worksheets: Duplicate or move worksheets within a workbook.
- Basic Data Analysis Tools
- Using AutoFill: Quickly fill cells with repetitive or sequential data.
- Basic Conditional Formatting: Highlight cells based on specific criteria.
- Using Freeze Panes: Keep row and column headers visible while scrolling.
- Saving and Sharing Workbooks
- Saving Workbooks: Save your work in different formats (Excel Workbook, PDF, etc.).
- Sharing Workbooks: Share your work via email or cloud storage.
Version Control: Save different versions of your workbook
Free MS Excel Course
Duration of the Course: 3 Hours
- Date: October 5, 2024
- Time: 10 am to 1 pm MT
- Course fee: CAD 00.00 + GST
Call Today
403-402-4264