learning
learning hours
MS Excel 2013: Advanced
Introduction
The course MS Excel 2013: Advanced is focused mainly on the creation of charts and automation of the work in the program by using macros. Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics. You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content. You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.
Lessons
- Sparklines
- Charts creation
- Chart design
- Chart formatting
- Screenshots and screen clipping
- Shapes
- SmartArt
- Themes
- Proofing tools
- Tracking changes
- Comments
- Managing multiple windows
- Splitting worksheets into panes
- Workbook views
- Header and footer
- Page setup
- Microsoft account
- File properties
- Workbook protection
- Workbook inspection
- File AutoRecovery
- Using templates
- Compatibility issues
- Saving a workbook to the Web
- Introduction to macros
- Macro recording
- Macro editing
- Macro security
- Digitally signed macros
90.9%
On successful completion of your course you will receive the learndirect Certificate of Completion of Training in MS Excel 2013: Advanced.
Your course certificate will also state the number of CPD points/hours the course is eligible for.
View a sample of the certificate (opens in new window)
learndirect is one of the largest integrated providers of courses and qualifications, training, and employment services in the UK
- Each year around 6,000 businesses equip their staff for success with learndirect
- learndirect have helped more than 75,000 businesses equip their employees with the skills needed to improve productivity.
- Almost 700,000 maths and English test passes have been achieved with learndirect.
- 300,000 people fulfilled their career ambitions last year with learndirect.
- Over 250,000 apprentices have achieved with learndirect.
MS Excel 2013: Advanced
Introduction
The course MS Excel 2013: Advanced is focused mainly on the creation of charts and automation of the work in the program by using macros. Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics. You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content. You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.
Lessons
- Sparklines
- Charts creation
- Chart design
- Chart formatting
- Screenshots and screen clipping
- Shapes
- SmartArt
- Themes
- Proofing tools
- Tracking changes
- Comments
- Managing multiple windows
- Splitting worksheets into panes
- Workbook views
- Header and footer
- Page setup
- Microsoft account
- File properties
- Workbook protection
- Workbook inspection
- File AutoRecovery
- Using templates
- Compatibility issues
- Saving a workbook to the Web
- Introduction to macros
- Macro recording
- Macro editing
- Macro security
- Digitally signed macros
Qualifications
On successful completion of your course you will receive the learndirect Certificate of Completion of Training in MS Excel 2013: Advanced.
Your course certificate will also state the number of CPD points/hours the course is eligible for.
View a sample of the certificate (opens in new window)
learndirect is one of the largest integrated providers of courses and qualifications, training, and employment services in the UK
- Each year around 6,000 businesses equip their staff for success with learndirect
- learndirect have helped more than 75,000 businesses equip their employees with the skills needed to improve productivity.
- Almost 700,000 maths and English test passes have been achieved with learndirect.
- 300,000 people fulfilled their career ambitions last year with learndirect.
- Over 250,000 apprentices have achieved with learndirect.
90.9%
Just Learning
With
Boost your wellbeing and career prospects at the same time with a major perk offered only to learndirect students! CLUB FIVE is the exclusive wellness and health partner of learndirect, providing a revolutionary fitness programme that is packed full of daily workouts. Whether you want to sweat it out with a HIIT workout or relax with a mindful Yoga session, the programme has various options designed to enhance your overall wellbeing.
Payment options
Just Learning
With
Boost your wellbeing and career prospects at the same time with a major perk offered only to learndirect students! CLUB FIVE is the exclusive wellness and health partner of learndirect, providing a revolutionary fitness programme that is packed full of daily workouts. Whether you want to sweat it out with a HIIT workout or relax with a mindful Yoga session, the programme has various options designed to enhance your overall wellbeing.
