Excel 2010: Essentials
Course
Online
*Indicative price
Original amount in USD:
$ 47
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
This Excel training series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you’ve never used Excel, this is your starting point. No prior experience is necessary. If you’ve used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you’ve used previous versions of Excel (prior to Office 2007), then there are a lot of features and changes you need to be aware of to fully utilize this software.
Facilities
Location
Start date
Start date
About this course
This Excel training series is for anyone who wants to know Excel in a non-intimidating, soup-to-nuts manner. If you’ve never used Excel, this is your starting point. No prior experience is necessary. If you’ve used Excel but never had formal training, this course will fill in the gaps so it all makes sense and so you are efficient and accurate. If you’ve used previous versions of Excel (prior to Office 2007), then there are a lot of features and changes you need to be aware of to fully utilize this software.
Reviews
Subjects
- MS Excel
- Options
- Excel
- Conditional Formatting
- Data tables
- Pivot tables
- Advanced Formulas
- Tables & Formatting
- Advanced Charting
- Pivot Reporting
- VBA & Macros
- Excel Productively
- Simulations & Solver
Teachers and trainers (1)
Name Name
Teacher
Course programme
- Introducing Excel
- Recognizing Interface Features Unique to Excel
- Understanding Workbook Structure
- Navigating through Workbooks
- Making Workbook Selections
- Entering Text
- Entering Dates & Numbers
- Editing Cell Entries
- Copying & Moving Data
- Filling a Series
- Modifying Workbook & Worksheet Structure
- Resizing Worksheet Elements
- Hiding Workbook Components
- Excel Calculations 101
- Entering Formulas
- Enforcing Absolute Referencing
- Controlling Calculation Options
- The Foundation of Functions
- Using AutoSum & the Formulas Tab
- Using Function AutoComplete
- Creating Named Cells
- Defining Names
- Creating Names from Selections
- Creating Named Formulas
- Using Names as References
- Managing & Displaying Names
- Applying Basic Formatting
- Formatting Numbers
- Exploring the Format Cells Dialog Box
- Deffning Custom Formats
- Creating & Applying Cell Styles
- Conditional Formatting
- Applying & Editing Conditional Formatting Rules
- Getting In-Cell Summaries with Sparklines
- Creating Charts
- Modifying Chart Design
- Working with Chart Layout & Format
- Saving & Using a Chart Template
- Converting Data Ranges to Tables
- Modifying Table Formatting
- Working with Table Records
- Using Table Calculations
- Sorting Data
- Creating Custom Lists
- Filtering Data
- Configuring Excel Options
- Adjusting the View
- Controlling Excel Windows
- Print Area, Print Titles & Sheet Options
- Renaming Sheets & Adding Headers/Footers
- Printing Worksheets
- Credits
Additional information
Break down Excel into its component parts to make it more manageable and less overwhelming
Use common, understandable names to replace confusing cell references
Apply traditional formatting, create custom formats and apply formatting that automatically changes based on conditions you designate
Truly understand how formulas and functions work, no matter how seemingly simple or complex
Learn the Commandments of Excel Usage™ to ensure your work is efficient and accurate
Embrace the power of tables to sort, filter and manage data more easily Create charts with just one click
LENGTH
Total Run Time: 7.2 hrs
Excel 2010: Essentials
*Indicative price
Original amount in USD:
$ 47