Microsoft Excel 2013® Fundamentals

0 student

Who Should Attend:

  • IT Professionals who provide tech support
  • Business Users with data manipulation requirements

Course Objectives

  • An overview of the features and functions available in Microsoft Excel 2010®
  • Learn how to analyse alternative data sets and create a variety of charts
  • Learn how to create dynamic worksheets using PivotTables
  • Learn how to automate repetitive tasks
  • Learn how to integrate with other Microsoft programmes and collaborate on workbooks.

What will you gain?

By the end of this course, you will be able to:

  • Create worksheets and work seamlessly with multiple workbooks
  • Get the confidence and know-how to work with large amounts of data and generate tables to present findings
  • Master the skill of working with complex formulas and functions to calculate values and analyse data
  • Sort and use data filters to refine data
  • Organise and summarise multiple sets of data with a few clicks
  • Customise and format a pivot table to suit your needs
  • Become proficient in analysing data by using descriptive statistics
  • Create meaningful charts and customise them using the design, layout and formatting available in Excel
  • Make relevant data stand out by using data and conditional formatting such as changing workbook themes and Excel table styles
  • Know your way around the Print option, and print full worksheets or set specific areas of printing
  • Save time by automating repetitive tasks using Macros
  • Work with other Microsoft applications and incorporate data from Excel into other applications easily
  • Share workbooks with colleagues and manage changes
  • Use built-in Excel features to protect worksheet date and authenticate your workbook/s.

Course Content

  1. Chapter 1 Setting Up a Workbook
  • Creating workbooks
  • Modifying workbooks
  • Modifying worksheets
  • Customising the Excel 2010 Programme Window
  • Key points
  1. Chapter 2 Working with Data and Excel Tables
  • Entering and revising data
  • Moving data within a workbook
  • Finding and replacing data
  • Correcting and expanding upon worksheet data
  • Defining Excel tables
  • Key points
  1. Chapter 3 Performing Calculations on Data
  • Naming groups of data
  • Creating formulas to calculate values
  • Summarising data that meets specific conditions
  • Finding and correcting errors in calculations
  • Key points
  1. Chapter 4 Changing Workbook Appearance
  • Formatting cells
  • Defining styles
  • Applying workbook themes and Excel table styles
  • Making numbers easier to read
  • Changing the appearance of data based on its value
  • Adding images to worksheets
  • Key points
  1. Chapter 5 Focusing on Specific Data by Using Filters
  • Limiting data that appears on your screen
  • Manipulating worksheet data
  • Defining valid sets of values for ranges of cells
  • Key points
  1. Chapter 6 Reordering and Summarising Data
  • Sorting worksheet data
  • Organising data into levels
  • Looking up information in a worksheet
  • Key points
  1. Chapter 7 Combining Data from Multiple Sources
  • Using workbooks as templates for other workbooks
  • Linking to data in other worksheets and workbooks
  • Consolidating multiple sets of data into a single workbook
  • Grouping multiple sets of data
  • Key points
  1. Chapter 8 Analysing Alternative Data Sets
  • Defining an alternative data set
  • Defining multiple alternative data sets
  • Varying your data to get a desired result by using goal seek
  • Finding optimal solutions by using solver
  • Analysing data by using descriptive statistics
  • Key points
  1. Chapter 9 Creating Dynamic Worksheets by Using PivotTables
  • Analysing data dynamically by using PivotTables
  • Filtering, showing and hiding PivotTable data
  • Editing PivotTables
  • Formatting PivotTables
  • Creating PivotTables from external data
  • Key points
  1. Chapter 10 Creating Charts and Graphics
  • Creating charts
  • Customising the appearance of charts
  • Finding trends in your data
  • Summarising your data by using Sparklines
  • Creating dynamic charts by using PivotCharts
  • Creating diagrammes by using SmartArt
  • Creating shapes and mathematical equations
  • Key points
  1. Chapter 11 Printing
  • Adding headers and footers to printed pages
  • Preparing worksheets for printing
  • Printing worksheets
  • Printing parts of worksheets
  • Printing charts
  • Key points
  1. Chapter 12 Automating Repetitive Tasks by Using Macros
  • Enabling and examining Macros
  • Creating and modifying Macros
  • Running Macros when a button is clicked
  • Running Macros when a workbook Is opened
  • Key points
  1. Chapter 13 Working with Other Microsoft Office Programmes
  • Including office documents in workbooks
  • Storing workbooks as parts of other office documents
  • Creating hyperlinks
  • Pasting charts into other documents
  • Key points
  1. Chapter 14 Collaborating with Colleagues
  • Sharing workbooks
  • Managing comments
  • Tracking and managing colleagues’ changes
  • Protecting workbooks and worksheets
  • Authenticating workbooks
  • Saving workbooks for the web
  • Key points.
Curriculum is empty

Instructor

No student enrolled.

0.00 average based on 0 ratings

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%
20,000.00 ل.س

Course Features

  • Lectures 0
  • Quizzes 0
  • Students 0
  • Assessments Yes

Leave a Comment