What is Excel?
Microsoft Excel is one of the most simplest and powerful software applications. It lets users do quantitative analysis, statistical analysis with an intuitive interface for data manipulation, so much so that its usage spans across different domains and professional requirements. It is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros.
Course Overview?
This Microsoft Excel short course will help you improve the way you manage and present information, and take the legwork out of calculations and data manipulation. It provides the skills and knowledge necessary to create and manage workbooks and covers topics including adding data, editing data, working with formulas, printing and charting. This is an ideal introductory course before progressing onto Microsoft Excel Course: for Intermediate, This course aims to provide new Excel users with a foundation knowledge of Excel’s core features such as formulas, formatting, navigation, printing and creating charts.
Microsoft Excel is a powerful and versatile spreadsheet software that has become a staple tool in both personal and professional settings. With its extensive range of functions and features, Excel allows users to organize and analyze data, perform complex calculations, and create visually appealing reports and graphs. In this article, we will explore the many capabilities of Microsoft Excel and its applications in different industries
Course objectives
By the end of this course, you should be able to:
- navigate your way around Excel
- create and work with a new workbook
- open and navigate within workbooks and worksheets
- understand and work with ranges in a worksheet
- understand, create and work with formulas and functions used to perform calculations
- copy and paste data
- understand and use formula cell referencing
- use font formatting techniques
- align the contents of cells in a number of ways
- format rows and columns in a worksheet
- understand and use the number formatting features
- print workbook data
- create effective charts.
Course contents
- Understanding the start screen
- The workbook screen
- How Excel works
- 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 quick access toolbar
- Understanding the status bar
- Exiting safely
- Understanding workbooks
- Using the blank workbook template
- Typing text
- Typing numbers
- Typing dates
- Typing formulas
- Easy formulas
- Saving a new workbook on your computer
- Checking the spelling
- Making basic changes
- Printing a worksheet
- Safely closing a workbook
- Opening an existing workbook
- Navigating a workbook
- Navigating using the keyboard
- Using go to
- Recent files and folders
- Understanding data editing
- Overwriting cell contents
- Editing longer cells
- Editing formulas
- Clearing cells
- Deleting data
- Using undo and redo
- Understanding cells and ranges
- Selecting contiguous ranges
- Selecting non-contiguous ranges
- Using special selection techniques
- Selecting larger ranges
- Selecting rows
- Selecting columns
- Understanding copying
- Using fill for quick copying
- Copying from one cell to another
- Copying from one cell to a range
- Copying from one range to another
- Copying relative formulas
- Copying to a non-contiguous range
- Copying to another worksheet
- Copying to another workbook
- Understanding pasting
- Pasting to another worksheet
- Pasting to another workbook
- Using Paste Special
- Creating formulas that add
- Creating formulas that subtract
- Formulas that multiply and divide
- Understanding functions
- Using the sum, count and counta functions
- Summing non-contiguous ranges
- Using an average and rank functions
- Finding a maximum and minimum value
- Using today and now functions
- Creating more complex formulas
- What if formulas
- Common error messages
- Absolute versus relative referencing
- Relative formulas
- Problems with relative formulas
- Creating absolute references
- Creating mixed references
- Understanding font formatting
- Working with live preview
- Growing and shrinking fonts and Changing font size
- Making cells bold
- Italicizing text
- Underlining text
- Changing font colors
- Changing background colors
- Using the format painter
- Applying strikethrough
- Subscripting text
- Superscripting text
- Practice exercise
- Understanding cell alignment
- Horizontal cell alignment
- Vertical cell alignment
- Rotating text
- Indenting cells
- Wrap text
- Marge and Center
- Understanding number formatting
- Applying general formatting
- Formatting for money
- Formatting percentages
- Formatting as fractions
- Formatting as dates
- Using the thousands separator
- Increasing and decreasing decimals
- Approximating column widths
- Setting precise columns widths
- Setting the default column width
- Approximating row height
- Setting precise row heights
- Understanding worksheets
- Changing the worksheet view
- Worksheet zooming
- Viewing the formula bar
- Viewing worksheet gridlines
- Viewing the ruler
- Inserting cells into a worksheet
- Deleting cells from a worksheet
- Inserting columns into a worksheet
- Inserting rows into a worksheet
- Deleting rows and columns
- More than one worksheet
- Worksheet wisdom
- Understanding lists
- Performing an alphabetical sort
- Performing a numerical sort
- Sorting on more than one column
- Sorting numbered lists
- Sorting by rows
- Understanding filtering
- Applying and using a filter
- Clearing a filter
- Creating compound filters
- Multiple value filters
- Creating custom filters
- Using wildcards
- Inserting Shapes
- Adding a Hyperlink
- Find and Replace values
- 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